Skip to content
Google Sheets logo

Google Sheets integration

Productivity & Collaboration · 13 actions · OAuth auth

Read, write, and manage Google Sheets spreadsheets and worksheets.

Put Google Sheets to workView Google Sheets integration docs

The ModuleX Google Sheets integration lets a ModuleX agent operate Google Sheets on your behalf, running update, remove and list actions across spreadsheets, spreadsheet infos and worksheets, directly from a plain-English request, using your organization's own Google Sheets credentials. No pre-built workflow is required: the agent picks the right Google Sheets action for the task.

Google Sheets is a productivity & collaboration platform. ModuleX adds the agent layer: ask for an outcome and it selects and runs the right Google Sheets action. Or, when you want a repeatable process, the composer assembles a Google Sheets workflow for you, streaming the nodes onto the canvas as it builds.

Drive Google Sheets in plain English

Type what you want. A ModuleX agent picks the right Google Sheets action, or chains several, and runs it. No workflow to build.

  • “Add a new worksheet (tab) to an existing spreadsheet”
    resolves toadd_worksheet
  • “Find the worksheet I describe and remove it”
    resolves tolist_worksheetsdelete_worksheet
  • “Overwrite the contents of a specific row with a new list of values (positional, matching column order)”
    resolves toupdate_row
  • “Show me the spreadsheet infos that match what I describe”
    resolves toget_spreadsheet_info

What you can automate with Google Sheets

  • Find the right worksheet and remove it in one promptlist_worksheetsdelete_worksheet
  • Look up a spreadsheet info on demandget_spreadsheet_info
  • Find the rows that match what you describefind_rows
  • Update a cell the moment something changesupdate_cell

Google Sheets integration at a glance

VendorGoogle Sheets
CategoryProductivity & Collaboration
Actions available13
AuthenticationOAuth
Uses your own credentialsYes
Works with the assistantYes
Works in the composerYes
Multi-step / tool-chainingYes
Technical referenceView docs
Integration version1.0.0
Last updatedJul 2026

All 13 Google Sheets actions

Spreadsheets1
new_spreadsheet
Create a new Google Spreadsheet with an optional worksheet name and column headers. Returns the spreadsheet ID and URL.
Spreadsheet Infos1
get_spreadsheet_info
Get the structure of a Google Spreadsheet: worksheet names, column headers (first row of each sheet), and row counts. Call this first before reading or writing data.
Worksheets3
list_worksheets
Get a list of all worksheets (tabs) in a spreadsheet.
add_worksheet
Add a new worksheet (tab) to an existing spreadsheet. Optionally set column headers.
delete_worksheet
Delete a specific worksheet (tab) from a spreadsheet.
Rows5
read_rows
Read rows from a Google Sheets worksheet. Returns data as objects (keys = column headers from row 1) by default, or as raw arrays. Optionally specify an A1 range to read a subset.
find_rows
Search for rows matching a value in a specific column. Returns matching rows as objects with their row numbers.
add_rows
Append one or more rows to a Google Sheets worksheet. Pass rows as a JSON array — either arrays of positional values (e.g. [["Alice", "alice@example.com"]]) or objects with column header keys (e.g. [{"Name": "Alice", "Email": "alice@example.com"}]). Use get_spreadsheet_info first to discover header names.
update_row
Overwrite the contents of a specific row with a new list of values (positional, matching column order).
delete_rows
Permanently delete a range of rows from a worksheet. Rows below the deleted range shift up to fill the gap.
Values in Ranges1
get_values_in_range
Get all values from a range of cells using A1 notation. Returns a list of rows where each row is a list of cell values.
Cells1
update_cell
Update a single cell in a worksheet by A1 notation. The new value is parsed as if typed in the UI (USER_ENTERED).
Clear Rows1
clear_rows
Clear the contents of a row or range of rows. The rows still exist but become blank.

See full parameters and response schemas in the Google Sheets integration docs

Two ways to use Google Sheets in ModuleX

Ask the assistantType what you want done and a ModuleX agent picks the right Google Sheets action and runs it. No workflow to build.
Compose a workflowNeed it to happen every time? Describe the process and the composer wires Google Sheets into a repeatable workflow you can run on a schedule, from chat, or as an API.

Connecting Google Sheets

OAuthGoogle Sheets uses OAuth. You connect your Google Sheets account once; ModuleX stores the access token encrypted and scoped to your organization, so your team shares a single secure connection.

Step-by-step setup in the Google Sheets docs

Works with Google Sheets

Agents often chain Google Sheets with these. Connect them once and one agent can use all of them in a single task.

Notion19 actionsGoogle Slides15 actionsObsidian15 actionsDocuSign12 actionsTypeform12 actionsGoogle Docs10 actions

Recipes that use Google Sheets

Categorise card spend without the month-end scrambleA categorised transaction list plus a short list of the entries that genuinely need a human. Built for a finance lead reconciling a month of transactions from memory.5 steps · monthlyImport a contact list into your CRM without the cleanupContacts in the CRM with the fields mapped, and a list of the rows that needed a human decision. Built for whoever inherits the spreadsheet after a conference.5 steps · on demandKeep a personal spending tracker currentA tracker that stays current, with unfamiliar entries surfaced rather than guessed. Built for anyone whose budget sheet is accurate for the first week of the month.4 steps · on demandAssemble the month-end close digestA month-end digest in a consistent shape, assembled from the systems of record. Built for a finance team that rebuilds the same summary every month by hand.4 steps · monthlyReconcile payouts against your ledgerA reconciliation summary that names the specific rows to look at, not just a total that is off. Built for whoever matches the payment processor to the accounting sheet each week.4 steps · on demandKeep a personal application pipeline in orderA tracker whose stages match what actually happened in the inbox. Built for anyone tracking a search across a spreadsheet, an inbox, and memory.5 steps · on demand

Google Sheets + ModuleX FAQ

  • A ModuleX agent can run any of Google Sheets's 13 actions, across spreadsheets, spreadsheet infos, worksheets and rows, from a plain-English request, using your organization's own Google Sheets credentials.

Put Google Sheets to work in ModuleX.

Put Google Sheets to workView technical docs

Connect Google Sheets once with your own credentials and let your agent run all 13 actions on demand.

Last updated: Jul 2026Browse all 179 integrations