Google Sheets

What you can do

Connect this agent connector to let your agent:

• Values clear, append — Clear all values in a specified range of a Google Sheets spreadsheet
• Update update — Update cell values in a specific range of a Google Sheet
• Get get — Returns only the cell values from a specific range in a Google Sheet — no metadata, no formatting, just the data
• Read read — Returns everything about a spreadsheet — including spreadsheet metadata, sheet properties, cell values, formatting, themes, and pixel sizes
• Create create — Create a new Google Sheets spreadsheet with an optional title and initial sheet configuration

Authentication

This connector uses OAuth 2.0. Scalekit acts as the OAuth client: it redirects your user to Google Sheets, obtains an access token, and automatically refreshes it before it expires. Your agent code never handles tokens directly — you only pass a connectionName and a user identifier.

You supply your Google Sheets Connected App credentials (Client ID + Secret) once per environment in the Scalekit dashboard.

Set up the connector

Register your Scalekit environment with the Google Sheets connector so Scalekit handles the authentication flow and token lifecycle for you. The connection name you create will be used to identify and invoke the connection programmatically. Then complete the configuration in your application as follows:

Caution

Google applications using scopes that permit access to certain user data must complete a verification process.

1. Set up auth redirects

   • In Scalekit dashboard, go to Agent Auth → Create Connection. Find Google Sheets and click Create. Click Use your own credentials and copy the redirect URI. It looks like https://<SCALEKIT_ENVIRONMENT_URL>/sso/v1/oauth/<CONNECTION_ID>/callback.

     

   • Navigate to Google Cloud Console → APIs & Services → Credentials. Select + Create Credentials, then OAuth client ID. Choose Web application from the Application type menu.

     

   • Under Authorized redirect URIs, click + Add URI, paste the redirect URI, and click Create.

     

2. Enable the Google Sheets API

   • In Google Cloud Console, go to APIs & Services → Library. Search for “Google Sheets API” and click Enable.

3. Get client credentials

   • Google provides your Client ID and Client Secret after you create the OAuth client ID in step 1.

4. Add credentials in Scalekit

   • In Scalekit dashboard, go to Agent Auth → Connections and open the connection you created.

   • Enter your credentials:

     • Client ID (from above)
     • Client Secret (from above)
     • Permissions (scopes — see Google API Scopes reference)

     

   • Click Save.

Code examples

Connect a user’s Google Sheets account and make API calls on their behalf — Scalekit handles OAuth and token management automatically.

You can interact with Google Sheets in two ways — via direct proxy API calls or via Scalekit optimized tool calls. Scroll down to see the list of available Scalekit tools.

Proxy API Calls

Node.js

import { ScalekitClient } from '@scalekit-sdk/node';
import 'dotenv/config';

const connectionName = 'google_sheets'; // get your connection name from connection configurations
const identifier = 'user_123';          // your unique user identifier

// Get your credentials from app.scalekit.com → Developers → Settings → API Credentials
const scalekit = new ScalekitClient(
  process.env.SCALEKIT_ENV_URL,
  process.env.SCALEKIT_CLIENT_ID,
  process.env.SCALEKIT_CLIENT_SECRET
);
const actions = scalekit.actions;

// Authenticate the user
const { link } = await actions.getAuthorizationLink({
  connectionName,
  identifier,
});
console.log('🔗 Authorize Google Sheets:', link); // present this link to your user for authorization, or click it yourself for testing
process.stdout.write('Press Enter after authorizing...');
await new Promise(r => process.stdin.once('data', r));

// Make a request via Scalekit proxy
const result = await actions.request({
  connectionName,
  identifier,
  path: '/v4/spreadsheets',
  method: 'GET',
});
console.log(result);

Python

import scalekit.client, os
from dotenv import load_dotenv
load_dotenv()

connection_name = "google_sheets"  # get your connection name from connection configurations
identifier = "user_123"            # your unique user identifier

# Get your credentials from app.scalekit.com → Developers → Settings → API Credentials
scalekit_client = scalekit.client.ScalekitClient(
    client_id=os.getenv("SCALEKIT_CLIENT_ID"),
    client_secret=os.getenv("SCALEKIT_CLIENT_SECRET"),
    env_url=os.getenv("SCALEKIT_ENV_URL"),
)
actions = scalekit_client.actions

# Authenticate the user
link_response = actions.get_authorization_link(
    connection_name=connection_name,
    identifier=identifier
)
# present this link to your user for authorization, or click it yourself for testing
print("🔗 Authorize Google Sheets:", link_response.link)
input("Press Enter after authorizing...")

# Make a request via Scalekit proxy
result = actions.request(
    connection_name=connection_name,
    identifier=identifier,
    path="/v4/spreadsheets",
    method="GET"
)
print(result)

Scalekit Tools

googlesheets_create_spreadsheet

Create a new Google Sheets spreadsheet with an optional title and initial sheet configuration. Returns the new spreadsheet ID and metadata.

Name	Type	Required	Description
locale	string	No	Locale of the spreadsheet
schema_version	string	No	Optional schema version to use for tool execution
sheets	array<object>	No	Initial sheets to include in the spreadsheet
time_zone	string	No	Time zone for the spreadsheet
title	string	No	Title of the new spreadsheet
tool_version	string	No	Optional tool version to use for execution

googlesheets_get_values

Returns only the cell values from a specific range in a Google Sheet — no metadata, no formatting, just the data. For full spreadsheet metadata and formatting, use googlesheets_read_spreadsheet instead.

Name	Type	Required	Description
major_dimension	string	No	Whether values are returned by rows or columns
range	string	Yes	Cell range to read in A1 notation
schema_version	string	No	Optional schema version to use for tool execution
spreadsheet_id	string	Yes	The ID of the Google Sheet
tool_version	string	No	Optional tool version to use for execution
value_render_option	string	No	How values should be rendered in the response

googlesheets_read_spreadsheet

Returns everything about a spreadsheet — including spreadsheet metadata, sheet properties, cell values, formatting, themes, and pixel sizes. If you only need cell values, use googlesheets_get_values instead.

Name	Type	Required	Description
include_grid_data	boolean	No	Include cell data in the response
ranges	string	No	Cell range to read in A1 notation
schema_version	string	No	Optional schema version to use for tool execution
spreadsheet_id	string	Yes	The ID of the Google Sheet to read
tool_version	string	No	Optional tool version to use for execution

googlesheets_update_values

Update cell values in a specific range of a Google Sheet. Supports writing single cells or multiple rows and columns at once.

Name	Type	Required	Description
include_values_in_response	boolean	No	Return the updated cell values in the response
range	string	Yes	Cell range to update in A1 notation
schema_version	string	No	Optional schema version to use for tool execution
spreadsheet_id	string	Yes	The ID of the Google Sheet to update
tool_version	string	No	Optional tool version to use for execution
value_input_option	string	No	How input values should be interpreted
values	array<array>	Yes	2D array of values to write to the range

Tool list

googlesheets_append_values Append rows of data to a Google Sheets spreadsheet. Data is added after the last row with existing content in the specified range. 5 params ▾

Append rows of data to a Google Sheets spreadsheet. Data is added after the last row with existing content in the specified range.

Name Type Required Description

range string required The A1 notation range to append data to (e.g. Sheet1!A1)

spreadsheet_id string required The ID of the spreadsheet to append data to

values array required 2D array of values to append. Each inner array is a row.

insert_data_option string optional How the input data should be inserted. Options: INSERT_ROWS (inserts new rows), OVERWRITE (overwrites existing data). Default: OVERWRITE

value_input_option string optional How input data should be interpreted. Options: RAW (literal values), USER_ENTERED (as if typed in UI, parses formulas/dates). Default: USER_ENTERED

googlesheets_clear_values Clear all values in a specified range of a Google Sheets spreadsheet. Formatting is preserved; only the cell values are cleared. 2 params ▾

Clear all values in a specified range of a Google Sheets spreadsheet. Formatting is preserved; only the cell values are cleared.

Name Type Required Description

range string required The A1 notation range to clear (e.g. Sheet1!A1:D10)

spreadsheet_id string required The ID of the spreadsheet to clear values in

googlesheets_create_spreadsheet Create a new Google Sheets spreadsheet with an optional title and initial sheet configuration. Returns the new spreadsheet ID and metadata. 6 params ▾

Create a new Google Sheets spreadsheet with an optional title and initial sheet configuration. Returns the new spreadsheet ID and metadata.

Name Type Required Description

locale string optional Locale of the spreadsheet

schema_version string optional Optional schema version to use for tool execution

sheets array optional Initial sheets to include in the spreadsheet

time_zone string optional Time zone for the spreadsheet

title string optional Title of the new spreadsheet

tool_version string optional Optional tool version to use for execution

googlesheets_get_values Returns only the cell values from a specific range in a Google Sheet — no metadata, no formatting, just the data. For full spreadsheet metadata and formatting, use googlesheets_read_spreadsheet instead. 6 params ▾

Returns only the cell values from a specific range in a Google Sheet — no metadata, no formatting, just the data. For full spreadsheet metadata and formatting, use googlesheets_read_spreadsheet instead.

Name Type Required Description

range string required Cell range to read in A1 notation

spreadsheet_id string required The ID of the Google Sheet

major_dimension string optional Whether values are returned by rows or columns

schema_version string optional Optional schema version to use for tool execution

tool_version string optional Optional tool version to use for execution

value_render_option string optional How values should be rendered in the response

googlesheets_read_spreadsheet Returns everything about a spreadsheet — including spreadsheet metadata, sheet properties, cell values, formatting, themes, and pixel sizes. If you only need cell values, use googlesheets_get_values instead. 5 params ▾

Returns everything about a spreadsheet — including spreadsheet metadata, sheet properties, cell values, formatting, themes, and pixel sizes. If you only need cell values, use googlesheets_get_values instead.

Name Type Required Description

spreadsheet_id string required The ID of the Google Sheet to read

include_grid_data boolean optional Include cell data in the response

ranges string optional Cell range to read in A1 notation

schema_version string optional Optional schema version to use for tool execution

tool_version string optional Optional tool version to use for execution

googlesheets_update_values Update cell values in a specific range of a Google Sheet. Supports writing single cells or multiple rows and columns at once. 7 params ▾

Update cell values in a specific range of a Google Sheet. Supports writing single cells or multiple rows and columns at once.

Name Type Required Description

range string required Cell range to update in A1 notation

spreadsheet_id string required The ID of the Google Sheet to update

values array required 2D array of values to write to the range

include_values_in_response boolean optional Return the updated cell values in the response

schema_version string optional Optional schema version to use for tool execution

tool_version string optional Optional tool version to use for execution

value_input_option string optional How input values should be interpreted