Connect Caspio and Google Sheets

Caspio apps hold your data in tables, and not everyone who needs that data should log in to them. FlowMattic copies new Caspio records into Google Sheets and follows each update and deletion, so a read-only copy of a table stays current for reporting, sharing with a client or building a quick chart.

Try FlowMattic free See example workflows

9 triggers 19 actions 6 example workflows 2 ready-made templates Unlimited runs

Try a pairing

When this happens in Caspio3 triggers

Do this in Google Sheets19 actions

1. TriggerNew Record

2. ActionAdd New Row

When Caspio fires New Record, FlowMattic runs Add New Row in Google Sheets with the data from that event.

You build this in the FlowMattic workflow builder on your own site. See the setup steps

Caspio and Google Sheets workflows you can build

Each one uses only triggers and actions the two integrations ship today, plus FlowMattic's own tools. Where the library has a ready-made template, import it instead of building from scratch.

Ready-made template

Add each new Caspio record to a Google Sheet

Whenever a record is added to the chosen table, through a form, a DataPage or an import, it becomes a row with the same fields in the sheet.

New RecordAdd New Row

View the template

Apply Caspio edits to the matching sheet row

When a record changes, find its row by the record's key field and overwrite the columns, so the sheet copy shows the same values as the Caspio table.

Updated RecordLookup Row DataUpdate Row

Remove rows when their Caspio record is deleted

Deleted Record finds the row by key and deletes it, so a client looking at the shared sheet never sees entries that no longer exist in the app.

Deleted RecordLookup Row DataDelete Row

Archive deleted records instead of losing them

For audit trails, write each deleted record to an archive tab with the deletion date. The Caspio table stays tidy and the history is still there.

Deleted RecordDate/Time FormatterAdd New Row

Add or update, whichever the row needs

Records created before the workflow existed have no row yet. After the lookup, a Router updates rows that exist and adds the ones that are missing, so the sheet fills in as records change.

Updated RecordLookup Row DataRouterUpdate RowAdd New Row

Share only approved records with a partner

A Filter passes records whose status field is approved, so the partner's sheet holds the finished entries and never the drafts still being worked on in Caspio.

New RecordFilterAdd New Row

Set up: new Caspio records as rows

At the end, each record added to your chosen Caspio table appears as a new row in Google Sheets.

Match the columns
Give the sheet a header row that matches the table fields you want, and include the table's unique ID field so later workflows can find rows.
Connect Caspio
Add your Caspio account under Connects, then create a workflow with Caspio and New Record and choose the table.
Add a test record
Submit one record to that table so FlowMattic captures its fields.
Write the row
Connect Google Sheets, add Add New Row, map each field to its column, test and switch the workflow on.

Import the ready-made template Beginner, about 5 min to set up

From Caspio	To Google Sheets
Record ID	ID
Name	Name
Email	Email
Status	Status
Date created	Created

Triggers and actions in this pair

A trigger starts a workflow. An action is something FlowMattic does in the app as a step.

Good to know

The fields come from your own Caspio table, so the mapping above is an example. Always map the table's unique ID field; the update and delete workflows look rows up by it.
Each trigger watches the table you choose. To mirror several tables, build one set of workflows per table, each writing to its own tab.
The copy runs one way, from Caspio to Sheets. Editing a row in the sheet does not change the Caspio record.

Caspio

Integration page

Triggers (3)

New RecordTriggers when a new record is added to the chosen table.
Updated RecordTriggers when a record is updated to the chosen table.
Deleted RecordTriggers when a record is deleted from the chosen table.

Google Sheets

Integration page

Triggers (6)

New Spreadsheet RowTrigger when a new row is added to the spreadsheet
New Or Updated Spreadsheet RowTrigger when a row is updated in the spreadsheet
Deleted Spreadsheet RowTrigger when a row is deleted from the spreadsheet
Update Cell DataTrigger when any cell is updated in the spreadsheet
Update Specific Cell DataTrigger when a specific cell is updated in the spreadsheet
Update Specific Column ValueTrigger when a specific column value is updated in the spreadsheet

Actions (19)

Add New RowAdd a new row with mapped data
Update RowUpdate existing row in specific spreadsheet with mapped data
Delete RowDelete row by ID in specific spreadsheet
Clear Row DataClear data or row by ID in specific spreadsheet
Lookup Row DataSearch for data in specific spreadsheet
Get Cell DataGet data for particular cell in specific spreadsheet
Update Cell DataUpdate data for particular cell in specific spreadsheet
Get Row CountGet total number of rows in specific spreadsheet
Get Row DataGet rows data from the sheet based on specified range
Create Spreadsheet ColumnCreate a new column in specific spreadsheet
Create New SheetCreate a new sheet in specific spreadsheet
Import CSV or JSON to Existing SheetImport CSV or JSON data to existing sheet in specific spreadsheet
Copy SheetCopy a sheet to another or within the same spreadsheet
Get RowsRetrieve rows in JSON format for use with Iterator
Export sheet to CSVExport the selected sheet to CSV format and save to WordPress Media Library
Export Sheet to ExcelExport the spreadsheet to Excel (.xlsx) format and save to WordPress Media Library
Export Sheet to PDFExport the spreadsheet to PDF format and save to WordPress Media Library
Export Sheet to OpenDocumentExport the spreadsheet to OpenDocument (.ods) format and save to WordPress Media Library
Export Sheet to TSVExport the selected sheet to TSV format and save to WordPress Media Library

Why run this pair with FlowMattic

Caspio and Google Sheets connect through FlowMattic on your own site, with no separate automation account in the middle and no charge per run.

Share data without more app users

Clients and colleagues read a Google Sheet, so you do not need a Caspio login or a new DataPage for every person who wants to look.

Records pass through your own server

FlowMattic runs on your WordPress site, so table data goes from Caspio to Google without another automation account holding it.

Busy tables, flat cost

Runs are unlimited, so a table that changes all day can be mirrored without paying per update.

Common questions

Can Google Sheets stay in sync with a Caspio table?

Yes, in one direction. New Record adds rows, Updated Record changes the matching row and Deleted Record removes or archives it. Use the record's unique ID to match rows in both workflows.

What about records that were in Caspio before I started?

They are not copied when you switch the workflow on. Export them from Caspio once and paste them into the sheet, or use the add-or-update example so each one appears the next time it changes.

Can I choose which fields go into the sheet?

Yes. Map only the columns you want in Add New Row. Fields you leave out stay in Caspio.

Will a deleted record delete the sheet row too?

Only if you build that workflow. Deleted Record with Lookup Row Data and Delete Row removes it; Add New Row on an archive tab keeps a copy instead.

Did not find your answer? You can browse the help center or ask us directly.

Start automating Caspio and Google Sheets

Install FlowMattic, connect both accounts and import a template. Every run stays on your own server.

Try FlowMattic free See pricing

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

Reviewed 27 Oct 2026. The example workflows are written with AI from the real triggers and actions of both integrations and checked against them. Caspio integration 1.0.0, Google Sheets integration 2.2.4.