Integrations / Content

Google Sheets

Read ranges, append and update rows, look up spreadsheet tabs, and create new spreadsheets in Google Sheets.

7 tools Connect with OAuth

Tools

google_sheets.get_spreadsheet

Get a spreadsheet's title, URL and tabs with their sizes. The spreadsheet ID is the long string in its URL after /d/, e.g. 1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms.

spreadsheet_id*

google_sheets.read_range

Read the cell values in a range, e.g. Sheet1!A1:D50 or a whole tab by its name.

spreadsheet_id*range*value_render_optionmajor_dimension

google_sheets.append_rows writes

Append rows after the last row of the table found in a range, e.g. Sheet1!A:D.

spreadsheet_id*range*values*value_input_optioninsert_data_option

google_sheets.update_range writes

Overwrite the cell values in a range, e.g. Sheet1!B2:C3.

spreadsheet_id*range*values*value_input_option

google_sheets.create_spreadsheet writes

Create a new spreadsheet in the connected account's Drive.

title*

google_sheets.api_get

Send a GET request to any Google Sheets API path under https://sheets.googleapis.com/v4 and return the response. For endpoints the named tools don't cover.

path*params

google_sheets.api_request writes

Send a POST, PUT, PATCH or DELETE request to any Google Sheets API path under https://sheets.googleapis.com/v4.

method*path*paramsbody

Tick Allow raw writes on the connection to add api_request, which can send POST, PUT, PATCH and DELETE requests to any Google Sheets API path.

Connect

  1. In the Google Cloud console, create or pick a project and enable the Google Sheets API under APIs & Services → Library.
  2. Under Google Auth Platform, fill in Branding, choose the Audience (Internal for a Google Workspace organization, or External with yourself as a test user), and under Data Access add the scope https://www.googleapis.com/auth/spreadsheets, which lets the connection read and write every spreadsheet the Google account can open.
  3. Under Google Auth Platform → Clients, create a Web application client and add the redirect URL shown on the connection page (https://<this app>/oauth/callback) as an authorized redirect URI.
  4. Paste the client ID and client secret on the connection, save, and use Connect to sign in with Google.
  5. While an External app's publishing status is Testing, only its test users can connect and Google expires their refresh tokens after 7 days, so publish the app for a lasting connection.

Press Connect on the connection to approve access at Google Sheets. Tokens renew automatically. How OAuth connections work

Credentials

OAuth client secret

Google Sheets API docs

Your next automation is one sentence away.

14-day free trial with $5 of built-in AI included. Cancel anytime.

Start free trial Talk to us