Google Sheets

Also an agent tool

productivity

Google Sheets integration (Sheets API v4 read/write + Drive API v3 spreadsheet lifecycle). Polling triggers — Sheets has no native webhook.

Provider API docs ↗

15 actions · 1 triggers

The Google Sheets integration lets you connect Google Sheets to your automations with 15 actions and 1 triggers — and every action is also a tool an AI agent can call. Examples: Get Spreadsheet, Create Spreadsheet, Get Values, Batch Get Values, Update Values. No blank-canvas wiring — connect it and use it in your workflows.

Every action below is also a tool an AI agent can call — the same pack powers your workflows and your agents.

Triggers 1

Events in Google Sheets that can start a workflow.

polling

New or updated spreadsheet

Fires when a spreadsheet visible to this connection is created or modified. Set q=mimeType='application/vnd.google-apps.spreadsheet' and orderBy=modifiedTime desc.

Actions 15

What Zervanor can do in Google Sheets.

Spreadsheets11

GET

Get Spreadsheet

Get spreadsheet metadata, sheet list, and optionally cell data (Sheets API: spreadsheets.get).

POST

Create Spreadsheet

Create a new spreadsheet, optionally with properties and sheets (Sheets API: spreadsheets.create). Response carries spreadsheetId.

GET

Get Values

Read a single A1 range of values (Sheets API: spreadsheets.values.get).

GET

Batch Get Values

Read multiple A1 ranges in one call (Sheets API: spreadsheets.values.batchGet). Pass ranges as a repeated query parameter.

PUT

Update Values

Overwrite a single A1 range with provided values (Sheets API: spreadsheets.values.update).

POST

Batch Update Values

Overwrite multiple ranges in one call (Sheets API: spreadsheets.values.batchUpdate).

POST

Append Values

Append rows after the last row of a table/range (Sheets API: spreadsheets.values.append).

POST

Clear Values

Clear values from a single range, keeping formatting (Sheets API: spreadsheets.values.clear).

POST

Batch Clear Values

Clear multiple ranges in one call (Sheets API: spreadsheets.values.batchClear).

POST

Batch Update (Structural)

Apply one or more structural/formatting Requests atomically (Sheets API: spreadsheets.batchUpdate). Body is the raw { requests: [...] } union payload — see api-reference.md for the ~70 request kinds.

POST

Copy Sheet To Spreadsheet

Copy a single sheet (tab) into another spreadsheet (Sheets API: spreadsheets.sheets.copyTo).

Files4

GET

List Spreadsheets

List/search spreadsheet files (Drive API: files.list). Filter spreadsheets with q=mimeType='application/vnd.google-apps.spreadsheet'. Polling source for the new/updated-spreadsheet trigger.

GET

Get File Metadata

Get a spreadsheet file's Drive metadata: name, parents, modifiedTime, owners (Drive API: files.get).

POST

Copy Spreadsheet File

Duplicate a spreadsheet file at the file level (Drive API: files.copy).

DELETE

Delete Spreadsheet File

Permanently delete a spreadsheet file, skipping trash (Drive API: files.delete). Cleanup target for the write test.

Automations using Google Sheets

Build your own automation with Google Sheets in the visual builder.

Automations with Google Sheets

Automation

Shopify → Google Sheets

Every Shopify order appends itself as a row — the order log your finance and ops people keep rebuilding by export, kept current automatically.

Automation

Stripe → Google Sheets

Each successful payment lands as a spreadsheet row — a revenue ledger your team can pivot on, without a nightly export.

Automation

WooCommerce → Google Sheets

Every WooCommerce order appends a row — the reporting sheet your accountant asks for, always current.

Frequently asked questions

What can I automate with Google Sheets?

15 actions are available — for example: Get Spreadsheet, Create Spreadsheet, Get Values, Batch Get Values, Update Values, and more.

Which Google Sheets events can start a workflow?

1 triggers — for example: New or updated spreadsheet.

Can Google Sheets be used as an AI agent tool?

Yes. Every Google Sheets action automatically becomes a tool an AI agent can call — the same pack powers both your workflows and your agents.

How is the Google Sheets integration modelled?

Google Sheets is modelled as a versioned connector pack, and the steps that need reasoning fall to first-party agents hosted in the same runtime as the workflows.