tr Skip to content
Connect Google Sheets with another app

Google Sheets integration

Connect Google Sheets with 918+ other apps in FlowMattic. Pick a trigger, add Google Sheets steps, map the fields from earlier steps and run the workflow on your own server with no per-task fees.

6 triggers 19 actions Integration version 2.2.4 Category: Spreadsheets Unlimited workflows and runs

See what the two do together: triggers, actions and example workflows.

Popular with Google Sheets

Triggers and actions for Google Sheets

A trigger is the Google Sheets event that starts a workflow. An action is what FlowMattic does in Google Sheets from a step.

EventWhat it doesType
New Spreadsheet RowTrigger when a new row is added to the spreadsheetTrigger
New Or Updated Spreadsheet RowTrigger when a row is updated in the spreadsheetTrigger
Deleted Spreadsheet RowTrigger when a row is deleted from the spreadsheetTrigger
Update Cell DataTrigger when any cell is updated in the spreadsheetTrigger
Update Specific Cell DataTrigger when a specific cell is updated in the spreadsheetTrigger
Update Specific Column ValueTrigger when a specific column value is updated in the spreadsheetTrigger
Add New RowAdd a new row with mapped dataAction
Update RowUpdate existing row in specific spreadsheet with mapped dataAction
Delete RowDelete row by ID in specific spreadsheetAction
Clear Row DataClear data or row by ID in specific spreadsheetAction
Lookup Row DataSearch for data in specific spreadsheetAction
Get Cell DataGet data for particular cell in specific spreadsheetAction
Update Cell DataUpdate data for particular cell in specific spreadsheetAction
Get Row CountGet total number of rows in specific spreadsheetAction
Get Row DataGet rows data from the sheet based on specified rangeAction
Create Spreadsheet ColumnCreate a new column in specific spreadsheetAction
Create New SheetCreate a new sheet in specific spreadsheetAction
Import CSV or JSON to Existing SheetImport CSV or JSON data to existing sheet in specific spreadsheetAction
Copy SheetCopy a sheet to another or within the same spreadsheetAction
Get RowsRetrieve rows in JSON format for use with IteratorAction
Export sheet to CSVExport the selected sheet to CSV format and save to WordPress Media LibraryAction
Export Sheet to ExcelExport the spreadsheet to Excel (.xlsx) format and save to WordPress Media LibraryAction
Export Sheet to PDFExport the spreadsheet to PDF format and save to WordPress Media LibraryAction
Export Sheet to OpenDocumentExport the spreadsheet to OpenDocument (.ods) format and save to WordPress Media LibraryAction
Export Sheet to TSVExport the selected sheet to TSV format and save to WordPress Media LibraryAction

Three steps to a running Google Sheets workflow

The builder keeps the order you think in: connect the app, choose what starts the workflow, add what should happen.

  1. Connect

    Authorise Google Sheets once

    Add a Google Sheets connection under Connects and reuse it in every workflow. Credentials stay in your WordPress database.

  2. Trigger

    Pick what starts it

    Start from a Google Sheets event, or from a WordPress event, a form, a webhook, a schedule or any of the 918+ integrations, then capture a sample so later steps can map real fields.

  3. Act

    Add Google Sheets steps and logic

    Chain Google Sheets actions with Router, Filter, Iterator and Delay, test each step against captured data, then switch the workflow on.

Google Sheets workflows people build

Each example pairs Google Sheets with an app it is often used with. Build any of them on the canvas, or start from the workflow library.

Create products in Voxel for new rows in Google Sheets

Google Sheets to Voxel

Schedule your workflow to automatically email your Google Sheet as CSV to your email daily

Schedule to Google Sheets, then Email SMTP

When a webhook is received, update specific range of Rows in Google Sheet

Webhooks to Google Sheets, then Iterator, then Google Sheets

Send your Google Sheet as Excel to your accounts team on Slack at month end

Schedule to Google Sheets, then Slack

About Google Sheets

FlowMattic integration version 2.2.4

Create, edit or capture updates to Google Sheet right within your workflow and perform any complex automation workflow easily

Google Sheets integration changelog

What changed in each version of the integration.

v2.2.4 – 16 October, 2026
– Fix: New Or Updated Spreadsheet Row now fires when a single cell in a row is edited (it needed two or more changed cells), and its data includes every cell of the row (cell_A_value, cell_B_value and so on), as New Spreadsheet Row does

v2.2.3 – 7 April, 2026
– Improved: Access token refresh now tries direct Google REST API first, falls back to FlowMattic server endpoint
– Improved: Spreadsheet listing now includes Shared and Team Drive spreadsheets
– Improved: Search Rows action now returns success status instead of error when no rows are found
– Improved: Implemented a fix to prevent creating webhook renewal cron schedule duplicates

v2.2.2 – 12 March, 2026
– Improved: Access token refresh for old connects will be processed through the REST API based endpoint
– Improved: Added Compatibility with the Team Drive Google Sheets fetch to display in sheets dropdown

v2.2.1 – 30 Jan. 2026
– Fix: Settings were not getting preserved when workflow editor is refreshed
– Fix: Issue with fields not loading correctly sometimes when changing the Sheet ID

v2.2.0 – 20 Dec. 2025
– New: Action – Get Rows: Retrieve rows in JSON format for use with Iterator to loop through individual row data
– New: Action – Export Sheet to CSV: Export the selected sheet to CSV format and save to WordPress Media Library
– New: Action – Export Sheet to Excel: Export the spreadsheet to Excel (.xlsx) format and save to WordPress Media Library
– New: Action – Export Sheet to PDF: Export the spreadsheet to PDF format and save to WordPress Media Library
– New: Action – Export Sheet to OpenDocument: Export the spreadsheet to OpenDocument (.ods) format and save to WordPress Media Library
– New: Action – Export Sheet to TSV: Export the selected sheet to TSV format and save to WordPress Media Library

v2.1.0 – 21 Nov. 2025
– New: Introducing a new API endpoint for Google Sheet authentication in Connects using the REST API on your site to avoid the external endpoint blocking request
– Fix: PHP warning on new row action if the Google Sheet is not selected

v2.0.8 – 9 Sept. 2025
– Improved: Data sent to Google sheet now gets added as raw data to avoid the Google Sheet default formatting
– Fix: New Rows getting prepended instead of appended to the Sheet

v2.0.7 – 7 Sept. 2025
– Improved: Added refresh sheet button for the Select Sheet field to update the column mapping in real time

v2.0.6 – 28 August, 2025
– Improved: Column with no header will now displayed in the mapping with Column + Letter.
– Improved: Default seleted sheet now shows as empty to avoid sheet data mapping
– Improved: Added loading indicator for the Sheet mapping data to avoid confusion as data not loading when sheet selected
– Fix: First row data was getting overridden when new row added with first column heading empty

v2.0.4 – 2 April, 2025
– Improved: Updated the Google Sheet authentication method in Connects to Custom

v2.0.3 – 31 Dec. 2024
– Fix: Compatibility with FlowMattic v5 builder

v2.0.2 – 6 August, 2024
– Fix: Webhook cron renewal causing issue if the cron job is not working fine in WordPress
– Fix: Set default authentication type for the new Connect vs traditional method in workflow
– Fix: Actions not working if the Spreadsheet or the worksheet has Emoji or special characters in name

v2.0.1 – 26 Jun, 2024
– Fix: Update Cell data action causing conflict if the data has comma separated content

v2.0 – 12 June, 2024
# New
– Implemented FlowMattic Connect to use centralized connections
– Trigger: New Spreadsheet Row
– Trigger: New Or Updated Spreadsheet Row
– Trigger: Deleted Spreadsheet Row
– Trigger: Update Cell Data
– Trigger: Update Specific Cell Data
– Trigger: Update Specific Column Value
– Action: Get Row Count
– Action: Create Spreadsheet Column
– Action: Create New Sheet
– Action: Import CSV or JSON to Existing Sheet
– Action: Get Row Data
– Action: Copy Sheet

# Improvements
– All the existing actions are improved to work fine with existing setup and new setup

# Fixes
– New row action insert from 3rd row
– Sheet data was not available above 10,000 rows
– Sometimes the cell update was happening on cell A due to provided range is incorrect
– Add row action does not allow to have empty column fields
– Add row action causing error if the sheet name has special characters or quotes

v1.1.1 – 19 Jan. 2023
– Fix: Escape single and double quotes correctly when add or update data to Google sheet

v1.1.0 – 15 Nov. 2022
– New action – Update Row
– New action – Delete Row
– New action – Clear Row Data
– New action – Lookup Row Data
– New action – Get Cell Data
– New action – Update Cell Data

v1.0
– Initial release

Start automating Google Sheets today

Try the Google Sheets integration on a live demo site, or install FlowMattic on your own and keep every run on your server.

30-day money-back guarantee Unlimited workflows and runs Self-hosted

Customers who run it every day

Rated 4.8 out of 5 by customers
Read more reviews

No additional usage fees over and above the annual fee ... AND Technical Support is great... they get back to you quite quickly and go above and beyond what is expected...

Verified User in Consumer Goods

Crafting bridges between my favorite apps, FlowMattic has truly impressed me with its ability to seamlessly automate workflows. This has noticeably accelerated the efficiency of my business processes, making everything run more smoothly and productively.