Skip to content
ClickRuntime

Connect Google Sheets to Supabase

Supabase holds the data your app runs on; Google Sheets is where the rest of the team reads and edits. Connecting them gives non-technical colleagues a working view of database records, and lets a sheet feed your app's knowledge base.
Add to ChatGPTAdd to Claude
Works inChatGPTClaudeClaude CodeCursorCodexVS CodeGemini CLIZedopencodeAny MCP client

Ideas

What you can do with Google Sheets and Supabase

Reports, logs and knowledge bases kept in step between Supabase and Google Sheets. These are ready-made starting points. Anything else you can describe works too.
The moment it happensAI

Answer support questions from Supabase and log each one in a sheet

Questions sent to your support link get an AI answer drawn from your Supabase knowledge base, and every question, answer and confidence score is logged in a sheet for review.

See how it works
Daily

List low-stock items from Supabase in a purchasing sheet

Each night, items in your Supabase inventory that are below their reorder level are written to your purchasing sheet, and you get an email to review and approve them.

See how it works
On a schedule

Keep a Supabase knowledge base in sync with your FAQ sheet

Each night, new or edited rows in your FAQ sheet are turned into search-ready entries in your Supabase documents table, so your bots always answer from the latest version.

See how it works
HourlyAI

Find people asking for tools like yours and list them in a sheet

Every hour, posts from people looking for a tool like yours are scored, stored in Supabase and added to a leads sheet for your team.

See how it works
On a schedule

List at-risk clients from Supabase in a sheet every morning

Every morning, clients who haven't visited in 14 days are written to your At Risk sheet and you get an email summary.

See how it works
The moment it happensAI

Sort incoming requests by urgency into Supabase and a team sheet

Each customer request is classified by urgency with AI, saved to Supabase and added to the sheet your team works from, with urgent ones posted to Slack.

See how it works Your own logic

Any other automation you can describe in words

Your own rules, schedule and AI steps with Google Sheets and Supabase, plus any other app. Describe it and your assistant builds it.

See how to build your own

Build your own

Build any Google Sheets and Supabase automation you can describe

The ideas above are ready-made starting points, not a fixed list. Describe what should happen between Google Sheets and Supabase in your own words, with your conditions, other apps or an AI step, and your assistant writes it, tests it and runs it on ClickRuntime.

  • Your own rules

    Conditions, thresholds, filters and exceptions, written the way you'd explain them to a colleague.

  • Any number of apps

    One automation can read from one app and update several others. Over 248 apps are ready, and anything with an API works too.

  • AI where it helps

    Summaries, classification, extraction and drafts use ClickRuntime's built-in AI, with no extra key.

  • On a schedule or on each event

    Runs as often as every 5 minutes, or the moment an app sends an event, and keeps track of what it already handled.

For example, ask your assistant

Only write sheet edits back to Supabase for rows where "approved" is yes, and log each change in a "history" tab.

Copy only rows updated since the last run, using an updated_at column, to keep runs fast.

Use cases

Why people connect Google Sheets and Supabase

How the two apps work together

  • A schedule or a check every few minutes reads Supabase tables with filters you choose.
  • The script writes rows to Google Sheets, adding or updating by ID.
  • Rows edited or added in the sheet can be written back to Supabase on the next check.

  • Ops teams editing data in a sheet

    Non-technical staff edit rows in a sheet and changes are written to Supabase. No admin panel needed.

  • Analysts reporting on app data

    Supabase tables are copied to Sheets for charts. Reports use live data.

  • Founders importing lists

    A sheet of products or users is inserted into Supabase. Bulk loading is easy.

  • Support teams reviewing logs

    Rows from logs tables are written to a sheet for review. Issues are easy to scan.

More apps

Google Sheets, Supabase and other apps in one automation

An automation isn't limited to two apps. Add the next step in another app and it runs as part of the same automation.

Daily table counts

Each morning, update my sheet with Supabase row counts by table and post any big changes to #eng.

Weekly report email

Every Monday, copy last week's orders from Supabase to my sheet and email me the totals.

Sync to Airtable too

Copy my Supabase products table to Google Sheets and Airtable each night.

Setup

Connect Google Sheets and Supabase once

Every idea on this page uses the same two connections, so you set them up once. If one is missing, your assistant tells you and links to the right place.

Google Sheets

Spreadsheets

  1. In the ClickRuntime dashboard, open Connections and choose Google Sheets.
  2. Sign in with your Google account and allow access.
  3. Pick the spreadsheets the automation may use. It can't see any other file in your Drive.

Supabase

Developer / Database & backend

  1. In your Supabase project, open Settings, then API Keys, and copy or create a secret key (it starts with sb_secret_).
  2. Note your project URL, which looks like https://<project-ref>.supabase.co.
  3. If an automation needs the Management API, go to Account, then Access Tokens, and generate a new token.
  4. In the ClickRuntime dashboard, open Connections & secrets and save the project URL and secret key (and the access token, if you made one).

FAQ

Questions about connecting Google Sheets and Supabase

Is the sheet a live copy of my table?
No, it's updated on each run or event. That keeps your database private while giving the team what they need.
Can people edit data in the sheet and change Supabase?
Only automations designed for it, such as the FAQ sync. Others write to the sheet only.
What Supabase key should I use?
The anon key with row-level security for read-only work, or the service role key for automations that write. Keep it as a secret in your ClickRuntime dashboard.
Does it work with large tables?
Yes. Queries filter on the server, so only the rows you need are sent to the sheet.
Can it upsert rows?
Yes. The script can insert or update based on a key column.
Does it handle many rows?
Yes. It can copy in pages and continue across runs.
Can it copy views?
Yes. Supabase views can be read like tables through the API.

Related pages

Keep exploring

Tell your assistant what Google Sheets and Supabase should do together

Free plan. No credit card.

Add to ChatGPTAdd to Claude