Connect Google Sheets to Zendesk and automate your tasks

Why integrate Google Sheets with Zendesk

The Google Sheets to Zendesk integration helps you sync data, automate manual tasks, and keep your stack aligned — without writing code.

Log every Shopify order to a Google Sheet automatically

When an order is placed in Shopify, MESA writes the relevant details — customer, line items, order value, fulfillment status — to the right sheet in real time. Your team works from a current, structured record without anyone running manual exports or copying data out of the Shopify admin.

Build a live ops dashboard your whole team can see

When Shopify order, inventory, and customer events occur, MESA pushes the details to Google Sheets as they happen. Your team tracks what's in motion from a single shared view without digging through the Shopify admin or waiting for a scheduled report.

Trigger Shopify workflows when a Google Sheet is updated

When a row is added or a value changes in a designated sheet — a product approved, a vendor confirmed, a reorder threshold flagged — MESA kicks off the corresponding action in Shopify. Your spreadsheet-based processes connect directly to your store operations without a manual handoff step between them.

Create Zendesk tickets from Shopify order events automatically

When an order is flagged — a failed fulfillment, a return request, a delayed shipment — MESA opens a ticket in Zendesk with the order details already attached. Your support team works the issue without hunting for context.

Keep Shopify customer data current when tickets are resolved

When a Zendesk ticket is closed or a resolution is logged, MESA updates the customer's record in Shopify — tags, notes, fields. Your store reflects what your support team learned without anyone syncing it manually.

Route support tickets based on order and customer details

When a ticket arrives in Zendesk, MESA reads the associated Shopify data — order value, customer tier, product type — and applies the right tags, priority, or assignee. Every ticket lands with the right team from the start.

Build any Google Sheets and Zendesk automation

MESA helps you connect apps to automate repetitive tasks. A trigger is an event that starts a workflow, and actions are the steps that occur when it's running.

Attachment Linked to Ticket Comment

Starts when an attachment is linked to a ticket comment.

• ID
• Subject
• Description
• Created At
• Updated At
• Status
• Priority
• Type
• Actor ID
• Requester ID
• Submitter ID
• Assignee ID
• Organization ID
• Group ID
• Brand ID
• Form ID
• External ID
• Is Public
• Tags
• Custom Status
• Via
• Event

Attachment Redacted from Ticket Comment

Starts when an attachment is permanently redacted from an existing comment on a ticket.

Comment Created

Starts when a comment is created.

Comment Made Private

Starts when a comment is made private.

Comment Redacted

Starts when a comment is redacted.

Ticket Agent Assignment Changed

Starts when a ticket is reassigned to another agent.

Ticket Brand Updated

Starts when a brand associated with the ticket is updated.

Ticket Created

Starts when a ticket is created.

• ID
• Subject
• Description
• Created At
• Updated At
• Status
• Priority
• Type
• Actor ID
• Requester ID
• Submitter ID
• Assignee ID
• Organization ID
• Group ID
• Brand ID
• Form ID
• External ID
• Is Public
• Tags
• Custom Status
• Via

Ticket Custom Field Updated

Starts when a ticket's custom field is updated.

Ticket Custom Status Updated

Starts when a ticket's custom status is updated.

Ticket Deleted

Starts when a ticket is deleted.

Ticket Description Updated

Starts when a ticket's description is updated.

Ticket Email CCs Updated

Starts when users are added or removed from a ticket.

Ticket External ID Updated

Starts when a ticket's external ID is updated.

Ticket Followers Changed

Starts when followers on a ticket are updated.

Ticket Form Updated

Starts when a ticket's form is updated.

Ticket Group Assignment Changed

Starts when a ticket is reassigned to another group of agents.

• ID
• Subject
• Description
• Created At
• Updated At
• Status
• Priority
• Type
• Actor ID
• Requester ID
• Submitter ID
• Assignee ID
• Organization ID
• Group ID
• Brand ID
• Form ID
• External ID
• Is Public
• Tags
• Custom Status
• Via
• Event
• Timestamp

Ticket Merged

Starts when a ticket is merged.

Ticket Organization Updated

Starts when a ticket's organization is updated.

Ticket Priority Updated

Starts when a ticket's priority is updated.

Ticket SLA Policy Updated

Starts when a ticket's SLA policy is updated.

Ticket Status Updated

Starts when a ticket's status is updated.

Ticket Subject Updated

Starts when a subject is updated.

Ticket Updated

Starts when a ticket is updated.

Row Created

Starts when a row is added to your spreadsheet.

Row Updated (Advanced)

Trigger a workflow after each spreadsheet edit. Requires creating an Apps Script in Google Sheets.

Add Tag to Ticket

Add a tag to a ticket.

• 0

Create Group

Create a group.

Create Organization

Create an organization.

• Organization

Create Ticket

Create a ticket.

• Ticket

Create Ticket Comment

Add a comment to a ticket.

• Ticket

Create User

Create a user.

• User

Delete Group

Remove a group.

Delete Organization

Remove an organization.

Delete Ticket

Remove a ticket.

Get List of Comments

Obtain a list of comments.

• Attachments
• Audit ID
• Author ID
• Body
• Created At
• HTML Body
• ID
• Metadata
• Plain Body
• Public
• Type
• Uploads
• Via

Get List of Groups

Obtain a list of groups.

• Created At
• Default
• Deleted
• Description
• ID
• Is Public
• Name
• Updated At
• URL

Get List of Organizations

Obtain a list of organizations.

• Count
• Next Page
• Organizations
• Previous Page

Get List of Tickets

Obtain a list of existing tickets.

• Allow Attachments
• Allow Channelback
• Assignee Email
• Assignee ID
• Attribute Value Ids
• Brand ID
• Collaborator Ids
• Collaborators
• Comment
• Created At
• Custom Fields
• Custom Status ID
• Description
• Due At
• Email Cc Ids
• Email Ccs
• Encoded ID
• External ID
• Follower Ids
• Followers
• Followup Ids
• From Messaging Channel
• Generated Timestamp
• Group ID
• Has Incidents
• ID
• Is Public
• Macro ID
• Macro Ids
• Metadata
• Organization ID
• Priority
• Problem ID
• Raw Subject
• Recipient
• Requester
• Requester ID
• Safe Update
• Satisfaction Rating
• Sharing Agreement Ids
• Status
• Subject
• Submitter ID
• Tags
• Ticket Form ID
• Type
• Updated At
• Updated Stamp
• URL
• Via
• Via Followup Source ID
• Via ID
• Voice Comment

Get List of Users

Obtain a list of users.

• Active
• Alias
• Chat Only
• Created At
• Custom Role ID
• Default Group ID
• Details
• Email
• External ID
• Iana Time Zone
• ID
• Last Login At
• Locale
• Locale ID
• Moderator
• Name
• Notes
• Only Private Comments
• Organization ID
• Phone
• Photo
• Remote Photo URL
• Restricted Agent
• Role
• Role Type
• Shared
• Shared Agent
• Shared Phone Number
• Signature
• Suspended
• Tags
• Ticket Restriction
• Time Zone
• Two Factor Auth Enabled
• Updated At
• URL
• User Fields
• Verified

Remove Tags from Ticket

Remove tags from a ticket.

• 0

Retrieve Group

Grab all details about a group.

• Created At
• Default
• Deleted
• Description
• ID
• Is Public
• Name
• Updated At
• URL

Retrieve Organization

Grab all details about an organization.

• Created At
• Details
• Domain Names
• External ID
• Group ID
• ID
• Name
• Notes
• Organization Fields
• Shared Comments
• Shared Tickets
• Tags
• Updated At
• URL

Retrieve Ticket

Grab all details about a ticket.

• Allow Attachments
• Allow Channelback
• Assignee ID
• Brand ID
• Collaborator Ids
• Collaborators
• Created At
• Custom Fields
• Custom Status ID
• Description
• Due At
• Email Cc Ids
• Encoded ID
• External ID
• Follower Ids
• Followup Ids
• From Messaging Channel
• Generated Timestamp
• Group ID
• Has Incidents
• ID
• Is Public
• Macro Ids
• Organization ID
• Priority
• Problem ID
• Raw Subject
• Recipient
• Requester ID
• Satisfaction Rating
• Sharing Agreement Ids
• Status
• Subject
• Submitter ID
• Tags
• Ticket Form ID
• Type
• Updated At
• URL
• Via
• Via Followup Source ID

Retrieve User

Grab all details about a user.

Search

Search for specific results.

• Count
• Facets
• Next Page
• Previous Page
• Results

Update Group

Modify a group's details.

Update Organization

Modify an organization's details.

Update Ticket

Modify a ticket's details.

• Ticket

Update User

Modify a user's details.

• User

Upload Files

Upload a file.

Add Row

Add a row to an existing Google Sheets document.

• Spreadsheet ID
• Updated Range
• Updated Rows

Add Sheet

Add a new sheet to an existing Google Sheets spreadsheet

• Spreadsheet
• Sheet Name

Bulk Add Rows

Add multiple rows to a Google Spreadsheet

• Spreadsheet
• Sheet Name

Create New Spreadsheet

Create a new Google Sheets spreadsheet.

• Spreadsheet name
• Folder

Expert support included

MESA includes hands-on support from automation experts who know how to get things done.

Free workflow setup

We'll build your first workflow with you live. Most merchants walk away with automation saving 5+ hours/week.

Fast response times

Average first response: Same day. Critical issues: Immediate escalation. Complex builds: 24-48 hours.

Ongoing optimization

Personalized workflow reviews, and quarterly check-ins to identify new opportunities as your business grows.

Real humans, always

Chat with real automation experts (not bots). Email support 9am-5pm PST. Google Meet sessions for complex workflows.

Integrate Google Sheets with Zendesk today.

Enjoy a 7-day free trial. Get your first workflow in minutes.