tr Skip to content
Black Friday FlowMattic for life, 12 payments of $33.25 Or $399 once. Nothing added for splitting Ends in --Days --Hrs --Min --Sec See the deal

Connect Supabase and Google Sheets

Supabase holds your app's data in Postgres, but managers and support staff are more at home in a spreadsheet. FlowMattic moves rows between a Supabase table and Google Sheets from your WordPress site, in either direction, so non-developers can read reports or add records without database access.

9 triggers 33 actions 6 example workflows 3 ready-made templates Unlimited runs

Try a pairing

When this happens in Supabase3 triggers

Do this in Google Sheets19 actions

1. TriggerRow Inserted
2. ActionAdd New Row

When Supabase fires Row Inserted, 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

Supabase 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.

Supabase app icon Google Sheets app icon

Copy each new Supabase row into a sheet

Sign-ups, orders or feedback inserted by your app appear as sheet rows, so the operations team sees new records without a database login.

Row InsertedAdd New Row

Supabase app icon Google Sheets app icon Ready-made template

Append a history row whenever a record changes

Each update is written as a fresh row with the new values and the time, giving a change log that shows how a record moved through its statuses.

Row UpdatedDate/Time FormatterAdd New Row

View the template
Supabase app icon Google Sheets app icon Ready-made template

Take a nightly snapshot of a table

A Schedule selects the rows you care about each night, and an Iterator adds them to a dated tab, which gives you a point-in-time record for reporting.

ScheduleSelect RowsIteratorAdd New Row

View the template
Supabase app icon Google Sheets app icon

Send sheet edits back to the database with upsert

When someone edits a price list or settings sheet, Upsert Row inserts or updates the matching record by its key, so the app uses the values the team approved.

New Or Updated Spreadsheet RowUpsert Row

Supabase app icon Google Sheets app icon

Remove a row from the sheet when it is deleted in Supabase

Lookup Row Data finds the record's row by ID and Delete Row removes it, so the mirror sheet does not keep records your app has already removed.

Row DeletedLookup Row DataDelete Row

Supabase app icon Google Sheets app icon

Load a whole tab into a table in one request

For a migration or a seeded lookup table, Get Row Data reads the tab, a Data Transformer shapes it as a JSON array and Bulk Insert Rows writes everything at once.

ScheduleGet Row DataData TransformerBulk Insert Rows

More ready-made templates with both apps

Set up: new rows into a sheet

After these steps, each row inserted into your chosen Supabase table also appears as a row in Google Sheets.

  1. Match the columns

    Create a sheet whose headers match the table columns you want to see, such as id, created_at, email and status.

  2. Connect both apps

    Add your Supabase project and your Google Sheets account under Connects in FlowMattic.

  3. Watch the table

    Start with the Supabase Row Inserted trigger, select the table and insert a test row to capture its fields.

  4. Add the sheet row

    Add Google Sheets Add New Row, map each column, test and switch the workflow on.

Copy each new Supabase row into a sheet
  1. Supabase app icon 1. Trigger in Supabase Row Inserted
  2. Google Sheets app icon 2. Action in Google Sheets Add New Row

    Fields mapped from the earlier steps (a typical setup)

    From SupabaseTo Google Sheets
    idid
    created_atcreated_at
    emailemail
    statusstatus
Built on the FlowMattic canvas. Test each step with real data, then switch the workflow on.

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

  • Each Supabase trigger watches the table you select, so build one workflow per table you want in the sheet.
  • Upsert Row decides between insert and update with a conflict target, so pick a unique column such as id or email.
  • If one workflow copies Supabase to the sheet and another copies the sheet back, a change can bounce between them. Use a Filter on a source column to stop it.
  • The column names in the mapping are examples from a typical table; yours will match your own schema.

Triggers (3)

  • Row InsertedTriggers when a new row is inserted into the selected table.
  • Row UpdatedTriggers when any column in the selected table is updated.
  • Row DeletedTriggers when a row is deleted from the selected table.

Actions (14)

  • Insert RowInsert a new row into a Supabase table.
  • Update RowUpdate existing row values in a Supabase table.
  • Upsert RowInsert or update a row based on a conflict target.
  • Delete RowDelete rows from a Supabase table.
  • Select RowsRetrieve rows from a Supabase table using filters.
  • Get Row by IDRetrieve a single row from a Supabase table by its identifier.
  • Call Database FunctionRun a Postgres function in your project and use what it returns.
  • Count RowsCount the rows in a table, optionally matching a filter.
  • Bulk Insert RowsInsert many rows in a single request from a JSON array.
  • Upload File to StorageUpload a file from a URL into a Supabase Storage bucket.
  • Get Public File URLBuild the public URL for a file in a public bucket.
  • Create Signed File URLCreate a temporary link to a file in a private bucket.
  • List FilesList the files stored in a bucket folder.
  • Delete FileDelete a file from a Supabase Storage bucket.
Google Sheets app icon

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

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

Reports without database access

Staff read and filter app data in Google Sheets, so you do not have to hand out Supabase logins or write a dashboard.

High row counts, same plan

FlowMattic runs are unlimited, so a busy table inserting rows all day costs the same as a quiet one.

Data moves through your server

Workflows run on your WordPress site, so rows pass between Supabase and Google without a third automation service holding them.

Common questions

Can I sync a Supabase table to Google Sheets?

Yes. Use Row Inserted, Row Updated and Row Deleted to add, update and remove rows in the sheet, or a Schedule with Select Rows for a periodic copy.

Can staff add records to Supabase from a sheet?

Yes. New Spreadsheet Row with Insert Row adds a record per row, and Upsert Row handles rows that may already exist.

Can I count rows for a daily report?

Yes. Count Rows can count a table, with an optional filter, and Add New Row writes the figure with the date to a reporting tab on a Schedule.

Can files from a sheet go into Supabase Storage?

Yes. If a column holds a file URL, Upload File to Storage copies it into a bucket, and Get Public File URL or Create Signed File URL gives you a link to write back.

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

Start automating Supabase and Google Sheets

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

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

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