Import SQL Server query results into Google Sheets, schedule auto-refresh, and write data back — works with Azure SQL, Amazon RDS SQL Server, and self-hosted instances.
SQL Server powers the databases behind countless enterprise applications — ERP systems, CRMs, financial platforms, and custom internal tools. Getting data from SQL Server into Google Sheets for reporting typically means scheduled exports, SSRS reports, or asking a DBA for a CSV. Brooked lets you run T-SQL queries directly from a sidebar inside Google Sheets and import results on demand or on a schedule.
Supported SQL Server configurations
- Microsoft SQL Server 2016, 2017, 2019, and 2022
- Azure SQL Database and Azure SQL Managed Instance
- Amazon RDS for SQL Server
- Google Cloud SQL for SQL Server
- Self-hosted SQL Server (with network access configured)
Step 1 — Install Brooked
Install Brooked from the Google Workspace Marketplace. Free tier includes 100 imports per month — no credit card required.
Step 2 — Connect SQL Server
Open the Brooked sidebar and click Add data source → SQL Server. Enter:
- Host — your SQL Server hostname or IP address
- Port — default 1433
- Database name
- Username and password — SQL Server authentication (not Windows auth)
- SSL/TLS — recommended; required for Azure SQL and cloud-hosted instances
Brooked uses SQL Server authentication (username/password). Windows Authentication and Active Directory SSO are not currently supported. Create a dedicated SQL login with read-only access for Brooked.
Step 3 — Import data into Google Sheets
Click New import, select your SQL Server connection, and write your T-SQL query. Choose a destination sheet range and click Import. Enable Auto-refresh to keep the data current on a schedule.
Two-way sync — writing data back to SQL Server
Brooked supports writing data from Google Sheets back to SQL Server tables using INSERT, UPDATE, UPSERT (MERGE), or DELETE. Useful for workflows where ops or finance teams manage records in Sheets and need those changes reflected in the application database.
Using the AI agent with SQL Server
Open the Chat tab and ask questions about your SQL Server data in plain English. The agent inspects your schema, writes the T-SQL, and returns results into the sheet.
Brooked AI — SQL ServerCommon use cases
- ERP reporting — pull operational data from your ERP's SQL Server database into Sheets dashboards
- Sales analytics — import CRM or sales database records for pipeline and forecast reporting
- Finance reporting — query GL and transaction tables for automated financial dashboards
- Operational monitoring — surface key operational metrics from your app database for team review
- Data entry — let teams update records in Sheets and sync changes back to SQL Server
Troubleshooting common issues
Frequently asked questions
Can I connect SQL Server to Google Sheets without SSRS or a data pipeline?
Yes. Brooked is a Google Sheets add-on that connects directly to SQL Server. Write T-SQL in the sidebar, import results into any sheet range, and schedule auto-refresh — no SSRS, SSIS, or data engineering required.
Does Brooked work with Azure SQL Database?
Yes. Use your Azure SQL server address (e.g. myserver.database.windows.net), port 1433, and SQL authentication credentials. Enable SSL and trust the server certificate. Make sure your Azure SQL firewall allows Brooked's IP addresses.
Is Windows Authentication supported?
Not currently. Brooked uses SQL Server authentication (username/password). Create a dedicated SQL login for Brooked with the minimum required permissions: SELECT on the schemas you want to query.
Can I write data from Google Sheets back to SQL Server?
Yes — Brooked supports two-way sync with SQL Server using INSERT, UPDATE, UPSERT (MERGE), or DELETE. Most SQL Server connectors for Sheets are read-only; two-way sync is a Brooked-exclusive feature.
Does Brooked work with SQL Server on Amazon RDS?
Yes. Use your RDS endpoint as the host. Make sure the RDS instance's security group allows inbound traffic on port 1433 from Brooked's IP addresses. Use SQL Server authentication credentials.
Connect SQL Server to Google Sheets today.
Free tier — 100 imports per month, no credit card required. Or see the full SQL Server integration details.
Install Brooked free →