ConditionalVisibility

new-products-promo

Find a Zap quiz

Zapier tutorials

zapier-tutorials-00-form-spreadsheet

Need to identify trends among survey or form responses? The quick and easy way is to analyze their information and interactions in a spreadsheet. The hard part: getting that information in one place. 

How to send form and ticket information to a spreadsheet for better analysis

Wish you had an easily accessible record of your Zendesk account activity? Use this integration to add new Zendesk tickets to rows in a specified Google Spreadsheet. It's an easy way to list every support ticket that comes in, graph your support activity, and more.

Zendesk is a web-based help desk support tool that makes it simple to provide great customer support.

Zendesk

New Group

Triggers when a new ticket is added to a view.

New Ticket in View

Triggers when a new ticket is created. Optionally select an organization.

New Ticket

Triggers when a one or more tags are added to a user.

Tag Added to User

Triggers when a new organization is created.

New Organization

Triggers when a new ticket is added (Zendesk may take an hour to make tickets available via their API with this trigger).

Recent Ticket

Triggers when there is activity (an audit) on a specific ticket. Non-admins can only watch one ticket per Zap.

New Action on Ticket

Triggers when an existing ticket is updated.

Updated Ticket

New User

New View

Find an Agent

Finds an existing ticket. With line item support for multiple tickets resulting from a query.

Find Ticket(s)

Find a Group

Find Latest Comment

Find an Organization

Find a Ticket

Find a User

Finds a ticket, or creates one if none are found.

Find or Create Ticket

Finds a organization, or creates one if none are found.

Find or Create Organization

Finds a user, or creates one if none are found.

Find or Create User

Deletes the user and associated records from the account.

Delete User

Create Organization

Remove one or more tags from an existing ticket.

Remove Tag(s) from Ticket 

Create Ticket

Attach File to Ticket

Add Comment to Ticket

Add one or more tags to an existing ticket.

Add Tag(s) to Ticket

Update Organization

Update an existing ticket status or add comments.

Update Ticket

Update User

Create User

Custom Actions (Beta)

This is an advanced action which makes a raw HTTP request that includes this integration's authentication.

API Request (Beta)

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Google Sheets

Triggers when a new row is added to the bottom of a Google Team Drive spreadsheet.

New Spreadsheet Row (Team Drive)

Triggers when a new row is added to the bottom of a spreadsheet.

New Spreadsheet Row

Triggers when a new spreadsheet is created.

New Spreadsheet

Triggers when a new row is added or modified in a spreadsheet - works best with Team Drives.

New or Updated Spreadsheet Row (Team Drive)

Triggers when a new row is added or modified in a spreadsheet.

New or Updated Spreadsheet Row

Triggers when a worksheet is created in a spreadsheet.

New Worksheet

Find up to 500 rows based on a column and value as line items.

Lookup Spreadsheet Rows (Advanced)

Find Worksheet

Return up to 500 rows as a single JSON value or as line items.

Get Many Spreadsheet Rows (Advanced)

Find a specific spreadsheet row based on a column and value. If found, it returns the entire row. Optionally, create a new row if no match is found.

Lookup Spreadsheet Row

Finds or creates a specific find worksheet.

Find or Create Worksheet

Find or Create Row

Create a new column in a specific spreadsheet.

Create Spreadsheet Column

Create a new row in a specific spreadsheet.

Create Spreadsheet Row

Create one or more new rows in a specific spreadsheet (with line item support).

Create Multiple Spreadsheet Rows

Creates a new worksheet by copying an existing worksheet.

Copy Worksheet

Creates a new spreadsheet. Choose from a blank spreadsheet, a copy of an existing one, or one with headers.

Create Spreadsheet

Creates a new worksheet in a Google Sheet.

Create Worksheet

Clears the contents of the selected row(s) while keeping the row(s) intact in the spreadsheet.

Clear Spreadsheet Row(s)

Deletes the selected row(s) from the spreadsheet. This action removes the row(s) and all associated data.

Delete Spreadsheet Row(s)

Format Spreadsheet Row

Update Spreadsheet Row

Update one or more rows in a specific spreadsheet (with line item support).

Update Spreadsheet Row(s)

Add new Zendesk tickets to Google Sheets

Want to need to analyze your JIRA issues in a spreadsheet? Use this Zap to automatically add JIRA issues to a row in a specified Google Sheets spreadsheet as soon as they are created. Once you set up this integration, new issues from that point forward are individually added as new rows to your Google Sheets spreadsheet. 

Jira is a bug and issue tracking tool that allows software developers to manage product development and build better software. This integration connects to self-hosted instances of Jira.

Jira Software Server

Triggers when you add an issue to a project of your selection.

New Issue

Triggers when a new issue is added that matches some JQL.

New Issue (Via JQL)

New Issue Type

New Priority

New Project

Updated Issue

Searches for an issue, either using the issue's key, or its summary.

Find Issue

Find User

Add Watcher to Issue

Attaches a file to an existing (or newly created) Jira issue.

Attach File to Issue

Create a new issue, select your own project and issue type.

Create Issue

Update Issue

Add new JIRA issues to Google Sheets rows

Need to get your HubSpot form submissions into Google Sheets, but don't want to manually transfer your data? No problem! This integration automatically saves each new form entry to a row in a specified spreadsheet for you.

HubSpot is your all-in-one stop for all of your marketing software needs.

HubSpot

New Company

New Contact

Triggers when a company recently created or updated.

Company Recently Created or Updated

Triggers when a contact recently created or updated.

Contact Recently Created or Updated

Triggers when a line_item recently created or updated.

Line_item Recently Created or Updated

Triggers when a product recently created or updated.

Product Recently Created or Updated

Triggers when new custom object is available.

New Custom Object

New Deal

Triggers when a specified property is provided or updated on a Deal.

Deal Property Change

Triggers when all, or some specific new email event is available.

New Email Event

Triggers when new email timeline subscription added for the portal.

Email Subscriptions Timeline

New Engagement

New Form Submission

Triggers when new line_item is available.

New Line_item

Triggers when a calendar task is created. _(Marketing Hub Professional plans and above)_.

New Calendar Task

Triggers when a contact is added to the specified list.  _(Marketing Hub Starter plans and above)_.

New Contact in List

Triggers when a new article is added to your COS blog.

New COS Blog Article

Triggers when a new custom object is created.

Triggers when a deal enters a specified stage.

New Deal in Stage

Triggers when a specified property is provided or updated on a deal.

New Deal Property Change

Triggers when a message is posted from HubSpot to the specified social media channel.

New Social Media Message

Triggers when a specified property is provided or updated on a ticket.

New Ticket Property Change

New Product

Triggers when a specified property is provided or updated on a company.

New Company Property Change

Triggers when a specified property is provided or updated on a contact.

New Contact Property Change

Triggers when a specified property is provided or updated on a custom object.

New Custom Object Property Change

Updated Deal Stage

Finds a company by searching. Deprecated, please switch to "Find Company" search for the most reliable experience with your Zap.

Find Company Deprecated

Find Company

Find Contact

Find Custom Object

Finds a deal by searching. Deprecated, please switch to "Find Deal" search for the most reliable experience with your Zap.

Find Deal Deprecated

Find Deal

Find Associations

Get Owner by Email

Finds and retrieves CRM object pipeline stage details.

Get Pipeline Stage Details

Get Deal by ID

Get Owner by ID

Find Line_item

Find Product

Find Ticket

Find or Create Company

Find or Create Contact

Find or Create Custom Object

Find or Create Deal

Find or Create Line_item

Find or Create Product

Add Contact to Deal

Adds a contact to a specific static list.  _(Marketing Hub Starter plans and above)_

Add Contact to List

Creates a new company. Deprecated, please switch to "Create Company" action for the most reliable experience with your Zap.

How to send form and ticket information to a spreadsheet for better analysis

Related articles

Improve your productivity automatically. Use Zapier to get your apps working together.