How to connect Zendesk + Google Sheets + Smartsheet
Zapier lets you send info between Zendesk and Google Sheets and Smartsheet automatically—no code required. With 8,000+ supported apps, the possibilities are endless.
- Free forever for core features
- 14 day trial for premium features & apps
Do even more with Zendesk + Google Sheets + Smartsheet
With Zapier, you can do more than just connect your apps - you can automate entire processes from beginning to end! Check out the following list of triggers and actions you can use with Zendesk, Google Sheets, and Smartsheet. And don’t forget that you can add more apps and actions to create complex workflows.
New Group
Triggers when a new group is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planWho can view suspended tickets
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew View
Triggers when a new view is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNameRequired
Details
Notes
Tags
Domain Names
External Id
Group Id
Shared Tickets
Shared Comments
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SubjectRequired
Assignee
Collaborators
Collaborator Emails
Group
Requester Name
Requester Email
First Comment/Description format
First Comment/DescriptionRequired
Should the first Comment be public?
Tags
Status
Type
Priority
Submitter
Ticket form
Sharing Agreements
Brand
External ID
Email CC
Attachment
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TicketRequired
Comment body
Comment format
Should the Comment be public?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.OrganizationRequired
Name
Details
Notes
Tags
Domain Names
External Id
Shared Tickets
Shared Comments
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.UserRequired
Name
Email
Details
Notes
Phone
Tags
Role
Organization
External Id
Verified
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
Additional request headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Ticket IdRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appQueryRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appQueryRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appQueryRequired
NameRequired
Details
Notes
Tags
Domain Names
External Id
Group Id
Shared Tickets
Shared Comments
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundDrive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNo Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Frozen Rows Count
Frozen Columns Count
Sheet Position
Hide Sheet
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Source RangeRequired
Destination RangeRequired
Paste Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Validation TypeRequired
Input Message
Strict Validation
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
Additional request headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row countRequired
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appSpreadsheet IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundGet Reports
[PRIVATE] Generates report list for dropdown.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planWorkspace NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Choose a SheetRequired
RowRequired
TitleRequired
CommentRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Source FolderRequired
Destination FolderRequired
New Folder NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.WorkspaceRequired
New NameRequired
What to Include?
Skip Remap
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Choose Source SheetRequired
Choose a Destination SheetRequired
Choose RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.DestinationRequired
TemplateRequired
Copy Cells?Required
Copy Attachments?Required
Copy Discussions?Required
Sheet NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Choose a SheetRequired
Email Address(es)Required
Choose RowRequired
Email Subject
Message
CC Me?
Include Attachments ?
Include Discussions ?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Choose a SheetRequired
Email Address(es) to Share ToRequired
Access LevelRequired
Notify via Email?Required
Email Subject
Message
CC Me?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
Additional request headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Sheet IDRequired
Row IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app
New Organization
Triggers when a new organization is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planTicket (Required for non-admins)
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew User
Triggers when a new user is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planUserRequired
user_delete_copy
Permanent Deletion
user_delete_test_copy
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TicketRequired
TagsRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TicketRequired
CommentRequired
Should the comment be public?
FileRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TicketRequired
TagsRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TicketRequired
Subject
Assignee
Group
New status
New Comment to add to the Ticket
New Comment format
Should the new Comment be public?
Tags
Additional Tags
Remove Tags
Type
Priority
Submitter
Brand
External ID
Requester
Sharing Agreements
Ticket form
Collaborators
Collaborator Emails
Email CC
Attachment
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Email
Details
Notes
Phone
Tags
Role
Organization
External Id
Verified
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.QueryRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appInfo
Type
ActionThis is an event a Zap performs.SearchFind existing data in your appTicket IdRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appQueryRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appQueryRequired
NameRequired
Email
Details
Notes
Phone
Tags
Role
Organization
External Id
Verified
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNo Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Condition TypeRequired
Background Color
Text Color
Bold Text
Italic Text
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Confirm DeletionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Format TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SpreadsheetRequired
WorksheetRequired
New Sheet NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Sort by ColumnRequired
Sort OrderRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Row IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundUpdated Row
Triggers when cells in a row are updated or created (based on your settings).
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.SheetRequired
RowRequired
File AttachmentRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Choose a SheetRequired
Add Row to Top or Bottom
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Choose Source SheetRequired
Choose a Destination SheetRequired
Choose RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SheetRequired
ColumnRequired
Parent Row
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.DestinationRequired
Sheet to CopyRequired
Copy Cells?Required
Copy Attachments?Required
Copy Discussions?Required
Sheet NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Choose a SheetRequired
Row IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Choose a SheetRequired
Email Address(es)Required
FormatRequired
Email Subject
Message
CC Me?
Paper Size
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Choose a WorkspaceRequired
Email Address(es) to Share ToRequired
Access LevelRequired
Notify via Email?Required
Email Subject
Message
CC Me?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Find sheet Row (Legacy)
Find a row in a specified sheet using a query.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Sheet IDRequired
QueryRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app
Top companies trust Zapier to automate work and free up time
Join millions worldwide who automate their work using Zapier
How Zendesk + Google Sheets + Smartsheet Integrations Work
- Step 1: Authenticate Zendesk, Google Sheets, and Smartsheet.30 seconds
- Step 2: Pick one of the apps as a trigger, which will kick off your automation.15 seconds
- Step 3: Choose a resulting action from the other app.15 seconds
- Step 4: Select the data you want to send from one app to the other.2 minutes
- That’s it! More time to work on other things.