Integrate Zendesk with Google Sheets

Blendr.io is an embedded integration and automation platform for SaaS companies

Offer your customers comprehensive integrations between your SaaS platform, Zendesk and Google Sheets

Fast, flexible and powerful integrations

Blendr.io is an embedded integration platform for SaaS companies. Use the Blend Editor to create comprehensive integrations between your SaaS platform and 500+ marketing, sales and events cloud tools without coding.

Integrate your SaaS platform with Zendesk and Google Sheets to sync data between cloud tools, trigger certain actions in Zendesk and Google Sheets when some data changes in your SaaS platform and the other way around.

All Connectors

Supported features

Zendesk

List recent tickets

Get ticket by id

Create ticket

Update ticket

Delete ticket

Search ticket

List new and updated tickets incrementally

List ticket comments

List organization tickets

List contact tickets

Create ticket

Update ticket

Open Ticket in Agent's Browser

List export tickets incrementally - depricated

List tickets

List new and updated tickets incrementally

List contact tickets

Create ticket comment

Delete ticket comment attachment

Make ticket comment private

Remove text from comment

Create ticket

Update ticket

List contacts

Create or update contact

Delete contact

List new and updated contacts incrementally

List deleted contacts

List organization contacts

Update contact

Get contact

Get contact related info

List contact identities

Create or update contact

Add contact to organization

Add contacts to organizations

Create contact

Get contact identity

Create contact identity

Update contact identity

Update contact

Create contact

Update contact

List new and updated contacts incrementally

List contacts

List contact identities

Get account info

Get domain

returns the selected domain from the connector authentication flow

List organizations

Get organization

Create or update organization

Delete organization

Create organization

Update organization

List new and updated organizations incrementally

List tags from contact

Add tag to contact

Remove tag from contact

List tags

List tags from organization

Add tag to organization

Remove tag from organization

Add tags to ticket

Get attachment

Upload File

Delete upload

Set identity as primary

List memberships

List triggers

Delete trigger

Create trigger

Update trigger

Create trigger category

Trigger categories allow Zendesk admins to visually group triggers and make it easier for them to organize and manage their triggers.

List trigger categories

Trigger categories allow Zendesk admins to visually group triggers and make it easier for them to organize and manage their triggers. This block lists the available trigger categories.

List fields

List activities last 30 days

List users

List ticket events incrementally

Raw API list request

Raw API request

Need another feature from Zendesk?

Google Sheets

Get spreadsheet info by id

Returns the spreadsheet at the given ID. The caller must specify the spreadsheet ID

Create spreadsheet

Creates a spreadsheet, returning the newly created spreadsheet.

Remove sheet from spreadsheet

Deletes the requested sheet. Mention the ID of the sheet to delete.

Add sheet to spreadsheet

Adds a new sheet. When a sheet is added at a given index, all subsequent sheets' indexes are incremented.

List spreadsheets

Returns a list of all spreadsheets with id and names.

Delete spreadsheet

Deletes the spreadsheet with the fileid provided.

List sheets of spreadsheet

Returns info of all the sheets present in a given spreadsheet, as per the id.

Get data from spreadsheet

Append rows to sheet

Append one row to sheet

Delete rows

Clear sheet

Update range in sheet

Get data from sheet with headers

Update range in sheet

Set cell background color

Sets the background color of the cell. Represents a color in the RGBA color space.

Get data from sheet

Allows you to read values from cells, ranges, sets of ranges and entire sheets.

Append rows to sheet

Appends values to a spreadsheet. The input range is used to search for existing data and find a "table" within that range. Values will be appended to the next row of the table, starting with the first column of the table.

Append one row to sheet

Appends one row to the to a spreadsheet.

Delete rows

Allows you to remove rows in sheets

Clear sheet

Clears values from a spreadsheet. The caller must specify the spreadsheet ID and range. Only values are cleared -- all other properties of the cell (such as formatting, data validation, etc..) are kept.

Get data from sheet with headers

Returns a range of values from a spreadsheet. The caller must specify the spreadsheet ID and a range.

Update range in sheet

Sets values in a range of a spreadsheet. The caller must specify the spreadsheet ID, range.

Update cell

Sets value of a cell in the row and column mentioned of a spreadsheet. The caller must specify the spreadsheet ID, row, column.