Google Sheets connector

Google Sheets connector allows you to create, read, and update worksheets, rows, and columns.

Authorize your Google Sheets account
Google Sheets connector event cards
Google Sheets connector action cards
Google Sheets connector limitations

For information on specific errors being returned from the Google Sheets API, see the Google Sheets API docs.

You can also check the status of the Google Sheets API for any possible service outages.

Authorize your Google Sheets account

Authorization: When you add a Google Sheets card to a flow for the first time, you'll be prompted to create a configuration. This will allow you to connect to your account, save your account information, and reuse that configuration next time you build a flow with the connector. By doing so, you don't have to authenticate every time you want to build a flow with this connector. Instead, use the configuration you have already set up.

Google Sheets connector event cards

Event	Description
New Row	Trigger a flow when a new row is added to a spreadsheet.

Google Sheets connector action cards

Action	Description
Clear Row	Clear a row in a Google Spreadsheet.
Copy Spreadsheet	Copy a complete spreadsheet, including all worksheets and data, to a new spreadsheet with a new name.
Copy Worksheet	Copy a worksheet from one spreadsheet to another.
Create Row	Add a new row to the bottom of a spreadsheet.
Create Spreadsheet	Create a single spreadsheet that contains multiple worksheets.
Create Worksheet	Create a new worksheet in a spreadsheet of your choice.
Custom API Action	Make a custom authenticated HTTP call to the Google Sheets API.
Delete Rows	Delete a row in a Google Sheet.
Delete Spreadsheet	Delete an existing spreadsheet.
Delete Worksheet	Remove a single worksheet and all of its data.
Read All Rows	Read all non-header rows from a worksheet and return them as a collection.
Read All Spreadsheets	Retrieve ID information about every spreadsheet in a Google Sheets account.
Read Cell	Read the values from a specific cell in a spreadsheet.
Read Column	Retrieve values from a column in a Google Sheet.
Read Row	Read the values from a specific row.
Read Spreadsheet Info	Read information about a spreadsheet in your Google Sheets account.
Read Worksheet Info	Retrieve information about a worksheet in your Google Sheets account.
Search Column	Search one column in a Google Sheet for a specific term.
Update Cell	Change the value in a cell.
Update Row	Update the values in a spreadsheet row.
Update Worksheet Info	Update a worksheet's metadata information.

Google Sheets connector limitations

To learn more about connector performance, known issues, and limitations, see Known issues and limitations for Google Sheets connector.