Work with Google Sheets in Zaps

In order to use Google Sheets, you must follow several rules to use your spreadsheet in your Zaps.

Working with Spreadsheets
While the UI in this video is outdated, the core functionality remains similar in most current versions.

Spreadsheet formatting

Any spreadsheet you use in your Zap must:

  • Include headers in the first row. Clearly label each column with a descriptive name in the first row. This will tell Zapier where to send or receive data from.

Example of how to set headers in your spreadsheet

  • Not contain multiple headers. Headers are only recognized in the first row. Zapier will not recognize headers in any other row of your worksheet. Consider using separate worksheets within the workbook for better organization.
Example: Do not include separate headers, like the “Clothing”, “Size”, and “Quantity” headers here.
  • Not contain punctuation in the spreadsheet or worksheet names. Symbols such as colons (:) will make it harder for Zapier to find the right spreadsheet.

Example: Do not include colons in your sheet name like “Refunds:complete”

 

Spreadsheet permissions

You must have the following permissions to use Google Sheets with Zapier:

  • For trigger and search actions: viewer, commenter, or editor permissions.
  • For create and update actions: editor permissions.
  • If your company uses Google Suite: third-party app access.

File size

The maximum file size you can store in Google Drive is:

  • Up to 10 million cells or 18,278 columns for a spreadsheet. 
  • Up to 50,000 rows or 10 MB for pivot tables and extracts in Connected Sheets.

Spreadsheets exceeding these limits may prevent Zapier from accessing and processing your data effectively.

Additional tips

Avoid blank rows between rows that contain values. If you're trying to use a Zap to add new rows to your spreadsheet, it will always add rows after the last row with values. Similarly, rows with formulas, but no visible values are not considered empty.

Example: Do not include blank rows like you see here in rows 4, 5 and 6.

If you update your spreadsheet while your Zap is turned on, your Zap may error or you may see unexpected behaviors. The connection between Zapier and your spreadsheet will break if you:

  • Delete existing rows and/or columns.
  • Adding rows anywhere other than to the bottom of your sheet.
  • Sorting your worksheet.
  • Rename, add, or rearrange columns.
  • Rename your spreadsheet or worksheet.

If you need to update your sheet, first:

  1. Go to the Zaps page and turn off any Zaps connected to your spreadsheet.
  2. Update your spreadsheet.
  3. Re-test the Google Sheets triggers or actions in any connected Zaps. You may need to remap fields.
  4. Publish your Zap.

You must repeat this process every time you or a teammate updates the spreadsheet.

Was this article helpful?
157 out of 221 found this helpful