MySQL
LiveConnect MySQL to Google Sheets — two-way sync, SQL queries, scheduled auto-refresh
Live~10 minutes
PostgreSQL → Google Sheets
Connect any Postgres instance to Google Sheets — RDS, Supabase, Neon, or self-hosted.
OAuth 2.0 · Read-only by default · No data stored
~10 minutesSetup time
Username + passwordAuthentication
15 minutesMin sync interval
Read + writeDirection
Capabilities
Everything in the PostgreSQL connector
8 built-in capabilities — from live queries to scheduled syncs and AI-powered data analysis.
Connect to any PostgreSQL instance (RDS, Supabase, Neon, Railway, self-hosted)
Run SQL queries from the Brooked sidebar
SSL and SSH tunnel connection support
Import query results into any sheet range
Scheduled syncs for live dashboards
Supports all PostgreSQL versions 10+
Technical details
Built for IT teams to approve in one read
Every connection is read-only by default. Credentials are encrypted at rest. Brooked is a verified Google Workspace app.
- Authentication
- Username + password · SSL · SSH tunnel
- Supported versions
- PostgreSQL 10+
- Compatible hosts
- RDS · Supabase · Neon · Railway · self-hosted
- Supported objects
- TABLE · VIEW · MATERIALIZED VIEW
- Write operations
- INSERT · UPDATE · UPSERT (ON CONFLICT) · DELETE
- Min sync interval
- 15 minutes
- Row limit
- 10M rows per import (Pro tier)
- Data residency
- Read-only by default
Setup guide
Connect in 3 steps
From install to your first live query in under 5 minutes. No engineering help required.
1
Install the extension
Add Brooked from the Google Workspace Marketplace.
2
Connect your database
Enter your host, port, database name, user, and password. Brooked encrypts all credentials at rest.
3
Run a query
Write SQL in the sidebar and import results into any sheet range.
Need help? Visit support →
Full step-by-step guide
How to Connect PostgreSQL to Google Sheets
The exact working JDBC string for Apps Script, psql/COPY exports, postgres_fdw federation, and no-code add-ons — plus the cloud-provider gotchas (RDS, Supabase, Neon, Cloud SQL), Google IP allowlisting, both directions, and an AI agent that writes the SQL.
Read the full guideUse cases
How teams use PostgreSQL + Brooked
From finance reporting to real-time operations dashboards — see what your team can build.
App data reporting
Query your production database to pull user signups, activity metrics, or usage data into a reporting Sheet.
Live in Google Sheets
PostgreSQL → Sheets · auto-refresh
Available functions
Query PostgreSQL from a cell
Five built-in sheet functions — from natural-language queries to raw SQL and AI-powered KPI cells. No coding required.
fx
=BRKD_QUERY("PostgreSQL", "tables with the most rows in the public schema")
Ask a natural-language question against any connected data source. Returns a table of results that spills into adjacent cells.
=BRKD_QUERY("PostgreSQL", "tables with the most rows in the public schema")
Also supported
More Database integrations
SQL Server
LiveConnect SQL Server to Google Sheets — two-way sync, T-SQL queries, auto-refresh
Supabase
LiveConnect Supabase to Google Sheets — query your Postgres database and sync data without code
Get your spreadsheet hours back
Brooked sets up in seconds. Your team is querying live data before lunch.
Get started free
