Help

Work with Google Sheets in Zaps

Last updated:

Working with Spreadsheets

If you’re building a Zap that uses Google Sheets—such as triggering from new rows in a sheet, or adding data to a sheet—there are a few things you will need to do to get that sheet ready to work with Zapier. These steps are necessary to ensure we can interact with your sheet effectively.

Before you read on, we recommend following these guides on how to set up your trigger and action.


1. Make sure the first row is a header row with column names

We recommend all your columns have text in the header row, but you must have text in the first column header, especially if you are using the Create Spreadsheet Row action. Without any text there, the Zap will send your data to the top of the sheet rather than to the bottom.

Example of how to set headers in your spreadsheet

Note

Zaps are intended to only add rows to the end of the spreadsheet and not any other row.


2. Don’t include headers for separate sections but do remove blank rows

Your spreadsheet should have no blank rows in between rows with content.

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

And it should not have any headers for separate sections in the same column.

Example: Do not include separate headers, like the “Clothing”, “Size”, and “Quantity” headers here.


3. Don’t delete rows

Do not delete rows in your spreadsheet while your Zap is on, and don't add rows in the middle of data your Zap has already recognized. This can cause errors with your Zap. If you need to delete any rows, ensure the Zap is turned off as you make your amendments. Once you've finished deleting your rows, you can then turn your Zap back on.


4. Don’t include punctuation in your Sheet name

If you include punctuation of any sort, it can make it harder for Zapier to find the right sheet in Google Sheets. This is especially true for colons, which will break your Zap.

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


5. Turn your Zap off before making changes to your sheet

The following changes to a sheet while a Zap is switched on can cause a disconnect with your Zap:

  • Deleting existing rows or columns
  • Adding rows anywhere other than to the bottom of your sheet
  • Resorting the sheet
  • Renaming/adding/rearranging new columns

If you need to make any of those types of changes to your Google Sheet, you will need to turn your Zap off while you make the change, and then turn it back on again after.

Once you’ve set your sheet up you’re ready to continue setting up the rest of your Zap, whether that’s setting up your action, or adding a search step.


Need More Help?

Contact Support

Tell us about your problem, and we’ll find you a solution or you can email support.
Get Help

Hire an Expert

We have a directory of professionals across the globe who are ready to help.
Find a Zapier Expert

Zapier Community

Connect with other Zapier users and industry professionals to get help crafting the perfect workflow.
Check out the community