Google Sheets

Use Google Sheets through a saved Integration hub connection. The catalog includes 10 actions, listed below.

What you can do

Use Google Sheets through a saved Integration hub connection. The catalog includes 10 actions, listed below.

Files and data

Authentication: OAuth 2.0 (authorize the provider or enter the details requested by the connection form)

Actions

Action	Description
Append values append_values	Appends new rows of data to a spreadsheet range.
Batch clear values batch_clear_values	Clears the values (not formatting) of one or more ranges.
Batch get values batch_get_values	Reads one range via the query string; works for tab names that contain spaces.
Batch update spreadsheet batch_update_spreadsheet	Structural changes: add/rename/delete tabs, insert/delete rows or columns, formatting, find and replace.
Batch update values batch_update_values	Writes values to one or more ranges in a single call, with typed-input parsing (formulas, dates).
Copy sheet to copy_sheet_to	Copies one tab (with values and formatting) into another spreadsheet.
Create spreadsheet create_spreadsheet	Creates a new Google spreadsheet.
Get spreadsheet get_spreadsheet	Retrieves spreadsheet metadata including title and sheet structure.
Get values get_values	Reads cell values from a specific range in a spreadsheet.
Update values update_values	Updates a range of cells with new values.

How to connect

Open Integration hub, choose Google Sheets, and create a named connection. If the connection opens the provider’s consent page, sign in and authorize access. If it opens a connection form, fill the requested OAuth details and save. The provider configuration determines which route is used.

For the shared connection process, follow Connect an app.

Use it in a workflow

Add an Integration step. Choose the app, saved connection and action, then map the action inputs from your record or workflow data.

The action list comes from the integration catalog. The connection form supplies the provider-specific input fields.