Google Sheets

Read, write, and manage Google Sheets data with FlowRunner agents. Agents append and update rows, export sheets to files, import CSV, and trigger flows on new or updated rows.

5 triggers 34 actions available

A new row lands in a tracking sheet and Sheets fires On New Row

Agent reads the row values against the mapped header columns

Agent checks the row for required fields before acting on it

Agent creates or updates the matching record in the downstream system

Agent writes a status back to the row so the sheet reflects the outcome

The owning team is notified that the row was processed

Rows that fail validation are routed to a person to correct before reprocessing

What This Integration Enables

Agents cover the full spreadsheet surface. They add single or multiple rows, update rows and cells by coordinate or A1 reference, clear cells and ranges, and format rows. They read with get cell, get rows, get last row, find row, and find rows, and they manage structure with add, delete, copy, and rename for both sheets and documents. Header actions load and set the header row for clean column mapping. Export actions produce Excel, CSV, or PDF files and return a URL, and import brings CSV data in. Five triggers fire on new documents, new sheets, new rows, updated rows, and document changes. The connector covers the data and structure of the spreadsheet; the surrounding flow decides what each row means.

Without FlowRunner

Spreadsheets kept by hand Someone exports from other systems and pastes the data into a sheet each week

Rows do not trigger anything A new row sits until a person notices it and acts

Reports are manual exports Each report is produced by opening the sheet and downloading a file

With FlowRunner

Sheets stay current in the flow Records are read and written as operational events fire

Rows start the work A new or updated row triggers the right downstream automation

Reports export on schedule Sheets are exported to a file and delivered without anyone opening them

Use Case Scenarios

Form Submission to Connected Systems

A form submission needs to land in a tracking sheet and propagate. The agent calls Add Row to log the response, then reads the new row and creates a matching contact in the CRM and posts a note to the sales channel. One submission becomes a logged row, a CRM record, and a notification in a single flow, with the sheet as the shared record of truth.

Scheduled Report Export

On a schedule, the agent calls Export Sheet to generate an Excel file of the current data and passes the returned URL to an email step as the daily report attachment. The team receives the report without anyone opening the spreadsheet or downloading a file by hand.

Row Validation with a Human Fix

A new row triggers downstream processing. The agent validates the row against required fields and the mapped header. Rows that pass are processed and marked complete. Rows that fail, a missing amount or an unrecognized status, are not pushed downstream; the agent flags the row and routes it to the owner to correct before it is reprocessed.

Human-in-Loop Highlight

A spreadsheet collects messy data, and the agent does not push bad rows into systems of record. When a new or updated row fails validation, the agent holds it instead of processing it, marks it in the sheet, and routes it to the data owner via Slack: "Row [N] in '[sheet name]' is missing a required value in the [column] column. Correct the row and I will reprocess it, or tell me to skip it." The owner fixes or skips the row, and the agent reprocesses only what was approved. Clean rows flow through automatically; the malformed ones get a human in the loop before they reach a connected system.

Agent processes routinely

Detects exception requiring judgment

Clear match Continues automatically

Ambiguous Routes to human via Slack

Human decides

Agent resumes with decision

Agent Capabilities

34 actions

Writing Rows and Cells

Add Row Appends a single row to a sheet. Used to log a form submission, event, or record as it arrives.
Add Rows Appends multiple rows to a sheet. Used for batch writes from a list or import.
Update Row Updates the values in a row. Used to write a status or result back to an existing record.
Update Rows Updates the values in multiple rows. Used for batch updates across matching records.
Update Cell Writes a value to a cell by coordinates. Used to set a single field, such as a processing status.
Update Cell by A1 Writes a value to a cell by A1 reference. Used when a flow addresses cells by their A1 notation.
Clear Cell Clears the contents of a cell by coordinates. Used to reset a field as part of a flow.
Clear Cell by A1 Clears the contents of a cell by A1 reference. Used for A1-addressed resets.
Clear Row Clears the contents of a row. Used to wipe a record without removing the row.
Clear Rows or Cells Area Clears a range of rows or cells. Used to reset a block of data.
Format Row Applies formatting to a row. Used to mark rows visually, such as flagging exceptions.

Reading Data

Get Cell Reads a cell value by coordinates. Used to pull a single field for a decision.
Get Cell by A1 Reads a cell value by A1 reference. Used for A1-addressed reads.
Get Rows Reads a range of rows. Used to load data for processing.
Get Last Row Returns the last populated row in a sheet. Used to find where new data should append.
Find Row Finds the first row matching criteria. Used to locate a specific record.
Find Rows Finds all rows matching criteria. Used to gather a set of matching records.
Load Header Row Reads the header row for column mapping. Used so a flow can address columns by name.
Set Header Row Defines the header row for a sheet. Used to establish the column map for a new sheet.
Get Sheet Columns Lists the columns in a sheet. Used to confirm structure before reading or writing.

Sheets and Documents

Add Sheet Adds a new sheet to a document. Used to create tabs on demand.
Find Sheet Locates a sheet by name within a document. Used to target the right tab.
Rename Sheet Renames a sheet within a document. Used to keep tabs organized.
Delete Sheet Deletes a sheet from a document. Used in cleanup flows.
Copy Sheet to Document Copies a sheet into another document. Used to distribute or template data.
Get Sheets List Lists the sheets in a document. Used to enumerate tabs for processing.
Add Document Creates a new spreadsheet document. Used to stand up a report or tracker on demand.
Rename Document Renames a spreadsheet document. Used to keep documents organized.
Delete Document Deletes a spreadsheet document. Used in cleanup flows.
Get Spreadsheets Lists available spreadsheet documents. Used to locate the right document.
Get Drives Lists available shared drives. Used to navigate to documents across drives.

Import and Export

Import from CSV Imports CSV data into a sheet. Used to load bulk data into the spreadsheet.
Export Document Exports a whole document as Excel, CSV, or PDF and returns the file URL. Used to produce a full report file.
Export Sheet Exports a single sheet as a file and returns its URL. Used to deliver a specific tab as a report attachment.

Triggers

5 triggers

Event Triggers

On New Row Fires when a new row is added to a watched sheet. Initiates flows that process incoming records, such as form submissions or imports.
On New or Updated Row Fires when a row is added or an existing row is updated. Initiates flows that react to any change in the data, not just new entries.
On Document Changed Fires when a watched spreadsheet document changes. Initiates flows that respond to broad edits across a document.
On New Sheet Fires when a new sheet is added to a document. Initiates flows that set up or process a new tab.
On New Document Fires when a new spreadsheet document is created. Initiates flows that register or template a new document.

Start building with Google Sheets

$100 in credits. No card required. Connect in minutes.

Start Building Free Talk to us