Google Sheets integration

Quick start

Call Google Sheets from your generated app's worker code via the OverSkill composio client. The toolkit slug below maps to Google Sheets's public Composio identifier — your app references it by name and OverSkill handles the OAuth round-trip.

// In your generated app's worker handler:
const composio = composioClient(env);

const result = await composio.execute(
  "GOOGLESHEETS_ACTION_NAME",
  { /* action parameters — see Actions section below */ }
);

return new Response(JSON.stringify(result), {
  headers: { "Content-Type": "application/json" }
});

Replace ACTION_NAME with one of the slugs listed in the Actions section below. The composio client handles auth + rate limits automatically — no API key is exposed to user code.

Setup

OverSkill hosts the OAuth application for Google Sheets. End-users click Connect on the integration card in your app, complete the OAuth flow with Google Sheets, and OverSkill stores the access token scoped to their account. No client_id / client_secret configuration needed on your side.

Supported auth schemes: OAUTH2.

Available actions

48 actions exposed via the Google Sheets integration. Each maps to a callable slug — pass it to composio.execute(...) in your worker code.

• GOOGLESHEETS_ADD_SHEET
• GOOGLESHEETS_AGGREGATE_COLUMN_DATA
• GOOGLESHEETS_APPEND_DIMENSION
• GOOGLESHEETS_AUTO_RESIZE_DIMENSIONS
• GOOGLESHEETS_BATCH_CLEAR_VALUES_BY_DATA_FILTER
• GOOGLESHEETS_BATCH_GET
• GOOGLESHEETS_BATCH_UPDATE
• GOOGLESHEETS_BATCH_UPDATE_VALUES_BY_DATA_FILTER
• GOOGLESHEETS_CLEAR_BASIC_FILTER
• GOOGLESHEETS_CLEAR_VALUES
• GOOGLESHEETS_CREATE_CHART
• GOOGLESHEETS_CREATE_GOOGLE_SHEET1