Import PostgreSQL query results into Google Sheets, schedule auto-refresh, and write data back — works with RDS, Supabase, Neon, Railway, and self-hosted Postgres.
PostgreSQL is the database behind a huge share of production applications. Getting data out of it and into Google Sheets — without building an ETL job or manually exporting CSVs — is something teams need constantly for reporting, ops dashboards, and ad-hoc analysis. Brooked connects directly to any PostgreSQL instance and lets you run SQL queries from a sidebar inside Google Sheets, then import the results into any sheet range.
Supported PostgreSQL hosts
Brooked works with any PostgreSQL 10+ instance, including:
- Amazon RDS for PostgreSQL and Aurora PostgreSQL
- Supabase (direct connection)
- Neon
- Railway
- Google Cloud SQL for PostgreSQL
- Azure Database for PostgreSQL
- Self-hosted PostgreSQL (with SSL or SSH tunnel)
Step 1 — Install Brooked
Install Brooked from the Google Workspace Marketplace. The free tier includes 100 imports per month — no credit card required.
Step 2 — Connect your PostgreSQL database
Open the Brooked sidebar and click Add data source → PostgreSQL. Enter your connection details:
- Host — your database hostname or IP address
- Port — default 5432
- Database name
- Username and password
- SSL mode — required for most cloud-hosted databases
Credentials are encrypted at rest. Brooked recommends creating a dedicated read-only database user for reporting imports, and a separate read-write user if you need two-way sync.
Step 3 — Run a query and import results
Click New import, select your PostgreSQL connection, and write your SQL query. Choose a destination range in your sheet and click Import. Enable Auto-refresh to keep it synced on a schedule — hourly, daily, or weekly.
Two-way sync — writing data back to PostgreSQL
Brooked supports writing data from Google Sheets back to your PostgreSQL tables. Choose a sheet range and a target table, then pick an operation: INSERT, UPDATE, UPSERT (using ON CONFLICT DO UPDATE), or DELETE. This is useful for workflows where team members update records in Sheets and need those changes reflected in the database.
Using the AI agent with PostgreSQL
Open the Chat tab and ask questions about your Postgres data in plain English — the agent queries your live database and writes results into Sheets. No SQL expertise required.
Brooked AI — PostgreSQLCommon use cases
- App analytics — pull user signups, retention, and activity metrics into a reporting sheet
- Operations dashboards — surface operational records for the team without building a BI tool
- Ad-hoc analysis — run exploratory SQL and work with results in Sheets without a SQL IDE
- Data entry workflows — let team members update records in Sheets and sync changes back to the database
- Automated reporting — schedule daily imports of key tables for stakeholder dashboards
Troubleshooting common issues
Frequently asked questions
Can I connect Google Sheets to PostgreSQL without coding?
Yes. Brooked is a no-code Google Sheets add-on that connects to PostgreSQL via a sidebar. Enter your connection details, write or paste a SQL query, and import results into your sheet — no ETL pipeline or data engineering required.
Does Brooked work with Amazon RDS PostgreSQL?
Yes. Enter your RDS endpoint as the host. Make sure the RDS instance's security group allows inbound traffic on port 5432 from Brooked's IP addresses, and enable SSL in the connection settings.
Can I write data from Google Sheets back to PostgreSQL?
Yes — Brooked supports two-way sync with PostgreSQL. Choose INSERT, UPDATE, UPSERT, or DELETE and Brooked will apply the changes from your sheet range to the target table.
What PostgreSQL version does Brooked support?
Brooked supports PostgreSQL 10 and later. This covers all major cloud-hosted versions on RDS, Supabase, Neon, and Azure, as well as modern self-hosted installations.
Is there a free PostgreSQL connector for Google Sheets?
Yes. Brooked's free tier includes 100 PostgreSQL imports per month with no credit card required. The Pro plan at $29/user/month adds unlimited imports, hourly auto-refresh, and AI chat.
Connect PostgreSQL to Google Sheets in minutes.
Free tier available — 100 imports per month, no credit card required. Or see the full PostgreSQL integration details.
Install Brooked free →