Google Sheets

Discover how to use the Google Sheets app with Zapier.

• How to get started with Google Sheets on Zapier

  Google Sheets and Zapier can automate your spreadsheets by creating workflows. You can use triggers like new or updat...

• 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 Sprea...

• Find and update spreadsheet rows in Google Sheets on Zapier

  This article will guide you through using Zapier to find and update spreadsheet rows in the same sheet.  Before you b...

• Google Sheets error: Zap not triggering

  When using Google Sheet triggers in your Zap, the Zap does not run even though the spreadsheet was updated. Your Zap ...

• Google Sheets error: Required field "Row" (row) is missing

  When using Google Sheets Update Spreadsheet Row in your Zaps, you see the error message "Required field "Row" (row) i...

• Google Sheets error: Required field "Lookup Value" (lookup_value) is missing

  When using either the Google Sheets Lookup Spreadsheet Row or Look Spreadsheet Rows (output as Line Items) action, yo...

• Google Sheets error: Unable to get a value when looking for "responses". Is it empty or missing?

  When using the Google Sheets Update Spreadsheet Row(s) action, you see the error message "Unable to get a value when ...

• Google Sheets error: Nothing could be found for the search

  When using any Google Sheet search action, you see the error message "Nothing could be found for the search." This er...

• Google Sheets error: “the app returned” “the caller does not have permission”

  When you use a create or update action in Google Sheets, you see an error message of "the app returned” “the caller d...

• Google Sheets error: There was an error writing to your Google Sheets, unable to parse range

  When you use a create or update action in a Google Sheets step, you see an error message of "There was an error writi...

• Google Sheets error: requested entity was not found

  When using any Google Sheets action in your Zaps, you see the error message "requested entity was not found". You may...

• Google Sheets: Spreadsheet doesn't appear in the dropdown menu

  Symptoms You're trying to connect a Zap to a Google Sheet, but the spreadsheet doesn't appear in the Spreadsheet drop...

• Google Sheets error: 400 Blank rows cannot be written; use delete instead

  You see an error message of "400 Error: Blank rows cannot be written; use delete instead" when Zapier attempts to cre...

• Google Sheets error: cannot pass range or requested writing within range

  You've encountered an error message that mentions 'range', specifically phrases like: "cannot parse range" "400 Erro...

• Google Sheets: fields have gone missing in the Zap editor

  Symptoms You've noticed that some of the fields in your Zap editor have gone missing. Missing fields will be highligh...

• Google Sheets: Updated spreadsheet or worksheet name not reflected in Zap editor

  Symptoms You notice that the Zapier editor is displaying the previous name of your spreadsheet or worksheet, even tho...

• Google Sheets: data sent by Zap appears as #ERROR in sheet

  In your Google Sheet, you see the #ERROR message in cells where data was sent from Zapier.   Causes This happens if t...

• Google Sheets error: Invalid query parameter value for grid_id

  You've selected your worksheet in the Zap editor and see the error message "Invalid query parameter value for grid_id...

• Google Sheets error: 400 bad request

  You find a “400 Bad Request” error when Zapier tries to update your Google Sheet. This error can appear in the Zap ed...

• Google Sheets error: SSLError read operation timed out

  In the Zap editor or Zap history, you see an error message related to SSL operations, typically shown as: "SSLError ...

• Google Sheets: results in rows with mixed values or overwriting each other

  When you run your Zap, you notice that the rows being created in your Google Sheet are either mixed up or overwriting...

• Google Sheets: values sent to the incorrect columns

  Your Zap is sending data to the wrong columns in your spreadsheet. Causes This can happen if you insert, delete, or m...

• Google Sheets: Zap is creating duplicate rows

  You've noticed that your Zap is creating duplicate rows in your Google Sheet. This means the same data is being added...

• Google Sheets error: Zap is adding rows to the top of the sheet

  When using a Zap to update your Google Sheet, you wanted it to add a new row to the bottom of the spreadsheet. Instea...

• Google Sheets: the format of data changes when added to my spreadsheet

  You've entered data into your spreadsheet by Zap, and the format of the data has changed unexpectedly. For instance, ...

• Google Sheets: Zap is triggering on rows in a sheet on another Team Drive

  Your Zaps don't trigger based on changes to spreadsheets stored in a Team Drive when using the New or Updated Spreads...

• Google Sheets: Updated Spreadsheet Row trigger isn't working

  You may encounter this issue if you're using the Updated Spreadsheet Row trigger in Zapier, and it suddenly stops tri...

• Google Sheets: triggers unexpectedly or too soon

  If your Zap, which uses a Google sheet trigger, runs too soon or expectedly, the subsequent steps might receive missi...

• Google Sheets: triggers aren't instant

  Your Zap uses a Google Sheet trigger, and it’s not running instantly as expected. It takes a few minutes for the Zap ...