Google Sheets connector

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

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.

Delete Row

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.