Skip to content
ClickRuntime

Connect Gmail to Supabase

Supabase is the database behind many small apps and internal tools, and Gmail is how those apps talk to people. Connecting them turns database records into emails, like renewal reminders and approvals, and turns emails into rows, like tasks, leads and candidates.
Add to ChatGPTAdd to Claude
Works inChatGPTClaudeClaude CodeCursorCodexVS CodeGemini CLIZedopencodeAny MCP client

Ideas

What you can do with Gmail and Supabase

Emails from database records, and database rows from emails, between Gmail and Supabase. These are ready-made starting points. Anything else you can describe works too.
The moment it happens

Update stock in Supabase and email a reorder for approval

Each stock movement updates your Supabase inventory table, and when an item falls below its reorder level the manager gets an email with Approve and Reject links.

See how it works
HourlyAI

Find Reddit posts from likely customers and email the best ones

Every hour, Reddit posts about the problem your product solves are scored, saved in Supabase, and the promising ones are emailed to you.

See how it works
Every 5 minutesAI

Draft support replies in Gmail from your Supabase knowledge base

New support emails get a draft reply in Gmail based on answers stored in your Supabase knowledge table, and replies you send are saved back as new knowledge.

See how it works
Every 15 minutesAI

Turn action items in your email into Supabase tasks

Every 15 minutes, tasks mentioned in your new emails, with owners and due dates, are added as rows in your Supabase tasks table.

See how it works
Every 10 minutesAI

Reply to quote requests with prices from your Supabase products

Quote requests in your inbox get a reply priced from your Supabase product table, and every quote is logged.

See how it works
Daily

Email renewal reminders from your Supabase subscriptions

Every morning, customers whose subscription renews within 7 days get a reminder email, and you get a list of the at-risk ones.

See how it works
The moment it happens

Save form leads to Supabase and reply to them by email

Each new lead from your form is checked, scored and saved to Supabase, gets a reply from your Gmail, and you hear about the high-value ones.

See how it works
Every 15 minutesAI

Screen emailed CVs into a Supabase candidates table

CVs sent to your hiring inbox are read, summarised and scored against the role, and each candidate is added to your Supabase table.

See how it works Your own logic

Any other automation you can describe in words

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

See how to build your own

Build your own

Build any Gmail and Supabase automation you can describe

The ideas above are ready-made starting points, not a fixed list. Describe what should happen between Gmail 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

Send a welcome email only to users whose email is verified and who signed up over an hour ago, and mark a "welcomed" column.

Email me if any Supabase table grows by over 1,000 rows in an hour.

Use cases

Why people connect Gmail and Supabase

How the two apps work together

  • A check every few minutes reads Gmail for matching emails, or a Supabase database webhook sends new rows to your trigger link.
  • The script inserts or updates rows in Supabase through its API.
  • It sends emails or drafts from Gmail based on rows and queries.

  • Developers storing inbound emails

    Emails to a support address are saved as rows in a Supabase table. They can be queried and shown in an app.

  • Founders emailing users from their database

    New rows in a users table trigger a welcome email from Gmail. Personal emails go out without an email service.

  • Support teams answering from a knowledge base

    Questions in Gmail are answered using articles stored in Supabase. Drafts are accurate.

  • Ops teams getting daily reports

    A morning email shows signups, orders or errors from Supabase tables. Numbers come to you.

More apps

Gmail, 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.

Signups to Slack and email

When a new user row is added in Supabase, send a welcome email from Gmail and post the signup to #growth.

Weekly export

Each Monday, export last week's Supabase signups to my Google Sheet and email me the total.

Payment confirmation

When Stripe records a payment, update the user row in Supabase and email a receipt from Gmail.

Setup

Connect Gmail 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.

Gmail

Email

  1. At console.cloud.google.com, create a project and enable the Gmail API under APIs & Services → Library.
  2. Set up the OAuth consent screen. On Google Workspace choose Internal. On a personal Gmail account choose External, then under Audience click Publish app so it is In production, not Testing.
  3. Under Data Access, add the scopes you need, such as https://www.googleapis.com/auth/gmail.modify, or gmail.send if you only want to send.
  4. Under Clients, create an OAuth client of type Web application with the redirect URI https://clickruntime.com/oauth/callback.
  5. In the ClickRuntime dashboard, open Connections, choose Gmail and enter the client ID and secret. On a personal account Google shows an unverified-app screen: click Advanced, then go to your app.

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 Gmail and Supabase

How does ClickRuntime connect to Supabase?
Through your project's REST API using its URL and a key you save as a secret. Use the service role key only if row-level security would block the automation.
Will it change my database schema?
No. It reads and writes rows in tables you already have. Tell your AI assistant the table and column names.
Does it send emails from Supabase's email service?
No. Emails go from your Gmail address, so replies come back to your inbox.
Can it avoid emailing someone twice?
Yes. Most of these automations record a sent date or message id in the row and skip anything already handled.
Can it read Supabase storage files?
Yes. Files in Supabase Storage can be downloaded and attached to emails.
Does it respect row level security?
With the anon key, yes. With the service role key it bypasses it, so use that carefully.
Can it run SQL?
It can call Postgres functions through the Supabase API or query tables with filters.

Related pages

Keep exploring

Tell your assistant what Gmail and Supabase should do together

Free plan. No credit card.

Add to ChatGPTAdd to Claude