Import Supabase query results into Google Sheets, schedule auto-refresh, and write data back — connect directly using your project's Postgres connection string.
Supabase gives you a PostgreSQL database with a great developer experience. But when your product team, finance team, or founders want to explore that data, they're usually more comfortable in Google Sheets than in the Supabase SQL editor. Brooked connects directly to your Supabase Postgres database and lets anyone on your team query it from a sidebar inside Google Sheets — no SQL editor access required.
How Supabase connects to Brooked
Brooked connects to Supabase using the direct PostgreSQL connection string from your project settings. This is the standard Postgres connection — not the Supabase REST API or Realtime. You get full SQL access to all tables and views in your project.
Step 1 — Install Brooked
Install Brooked from the Google Workspace Marketplace. Free tier includes 100 imports per month — no credit card required.
Step 2 — Find your Supabase connection details
In your Supabase project, go to Settings → Database → Connection string. Choose the URI format. You'll find all the connection details you need:
- Host — your project's db.*.supabase.co hostname
- Port — 5432 (direct connection) or 6543 (connection pooler)
- Database — postgres (default)
- Username — postgres or a custom role you've created
- Password — your database password (set when creating the project)
Use the direct connection (port 5432) rather than the pooler for Brooked. Enable SSL mode — Supabase requires SSL on all connections.
Step 3 — Connect and run your first query
Open the Brooked sidebar and click Add data source → PostgreSQL (Supabase runs on Postgres). Enter the connection details and enable SSL. Click New import, write your SQL query, choose a destination range, and click Import.
Two-way sync — writing data back to Supabase
Brooked supports writing data from Google Sheets back to your Supabase tables using INSERT, UPDATE, UPSERT, or DELETE. Create a Supabase role with the appropriate write permissions for this use case. Note: Brooked bypasses Row Level Security (RLS) when using the postgres superuser — create a restricted role if you need RLS enforcement.
Using the AI agent with Supabase
Open the Chat tab and ask questions about your Supabase data in plain English. The agent inspects your schema and returns results into Sheets.
Brooked AI — SupabaseCommon use cases
- Product analytics — pull user signups, feature usage, and retention data into a Sheets dashboard
- Founder metrics — surface key business metrics from your Supabase database for weekly review
- Customer support — query user and subscription records for CS team without Supabase access
- Ad-hoc analysis — run one-off queries against your app database and share results in a sheet
- Ops reporting — schedule daily imports of key tables for operational dashboards
Troubleshooting common issues
Frequently asked questions
Can I connect Supabase to Google Sheets?
Yes. Supabase is built on PostgreSQL, so Brooked connects to it using standard Postgres credentials. Use your project's direct connection details from Settings → Database → Connection string.
Does Brooked work with Supabase Row Level Security?
When connecting as the postgres superuser, RLS is bypassed. To enforce RLS, create a dedicated Postgres role with the anon or authenticated role and connect as that user. Brooked will then be subject to your RLS policies.
Should I use the direct connection or connection pooler for Brooked?
Use the direct connection (port 5432) for Brooked. The connection pooler (port 6543, PgBouncer) is optimized for short-lived connections from application servers. Brooked holds persistent connections for queries, which works better with the direct endpoint.
Can I query Supabase auth.users from Google Sheets?
Yes — if you connect as the postgres superuser, you can query any schema including auth. SELECT id, email, created_at FROM auth.users ORDER BY created_at DESC LIMIT 1000; Use caution and apply appropriate access controls.
Is there a free Supabase connector for Google Sheets?
Yes. Brooked's free tier includes 100 Supabase imports per month with no credit card required. Pro is $29/user/month and adds unlimited imports, scheduled auto-refresh, and AI chat.
Connect Supabase to Google Sheets today.
Free tier — 100 imports per month, no credit card required. Or see the full Supabase integration details.
Install Brooked free →