--- title: "Google Sheets Integration" description: "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." url: https://flowrunner.ai/integrations/google-sheets date_modified: 2026-08-12T15:40:33-07:00 --- # Google Sheets [Productivity](https://flowrunner.ai/integrations/category/project-management-productivity) 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. [Verified](https://flowrunner.ai/integrations/verified "What does verified mean?") · 5 triggers · 34 actions · OAuth · available [Google Sheets website](https://www.google.com/sheets/about/) · [Platform Documentation](https://developers.google.com/sheets/api) · Capability data verified 2026-08-12 1. A new row lands in a tracking sheet and Sheets fires On New Row 2. Agent reads the row values against the mapped header columns 3. Agent checks the row for required fields before acting on it 4. Agent creates or updates the matching record in the downstream system 5. Agent writes a status back to the row so the sheet reflects the outcome 6. The owning team is notified that the row was processed 7. 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 11 - **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 10 - **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 Row by Index** Loads a single row by its 1-based index. Returns plain values by default, or a per-cell breakdown with background and text color, a merged-cell flag, and the row's A1 column edges. Used when a flow has to reason about how a row is formatted, not only what it says. - **Get Cells by Range** Loads a rectangular block of cells and returns each one with its content, colors, merged-cell flag, and A1 edges. Used to read a column across many rows in one call, and to pick up the color coding people use as status when nobody built a status column. - **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. ### Sheets and Documents 10 - **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. - **Get Reference** Builds a reusable pointer to a spreadsheet and optionally a sheet inside it, returning the selected document and sheet IDs. Used to choose the target once and pass it into every other action, instead of restating IDs at each step. - **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. ### Import and Export 3 - **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 5 - **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. ## Frequently Asked Questions ### What can FlowRunner do with Google Sheets? FlowRunner agents can run Add Document, Rename Document, and Delete Document in Google Sheets, plus 31 more actions. ### Does connecting Google Sheets to FlowRunner require OAuth? Yes. Google Sheets connects to FlowRunner with OAuth 2.0, so agents authenticate without handling raw credentials. ### Can Google Sheets trigger a FlowRunner workflow automatically? Yes. Google Sheets supports 5 triggers that can start a FlowRunner workflow automatically. **Work at Google Sheets?** This integration exposes Google Sheets to AI agents on every FlowRunner plan, including through MCP, at no cost to you. [See what FlowRunner offers integration partners](https://flowrunner.ai/integrations/partners), including how to keep this page current. --- Markdown version of https://flowrunner.ai/integrations/google-sheets. Site index: https://flowrunner.ai/llms.txt