How to Connect Snowflake to Google Sheets

Snowflake holds your most important data. Google Sheets is where your team actually works with it. Connecting the two without a brittle export pipeline has historically required an ETL tool, a data engineer, or a lot of patience. Brooked removes all of that — connect once and import Snowflake data into any sheet on demand or on a schedule.

What you'll be able to do

• Run SQL queries against Snowflake from a sidebar inside Google Sheets
• Import query results into any sheet range in seconds
• Schedule hourly, daily, or weekly auto-refreshes so your Snowflake data stays current
• Write data back to Snowflake from Sheets — INSERT, UPDATE, UPSERT, or DELETE
• Ask questions about your Snowflake data in plain English using the AI agent

Prerequisites

• A Snowflake account with at least one virtual warehouse and a role with SELECT access
• A Google account with Google Sheets
• Brooked installed from the Google Workspace Marketplace (free)

Step 1 — Install Brooked

Open Google Sheets, go to Extensions → Add-ons → Get add-ons, and search for Brooked. Install it and grant the requested permissions. Alternatively, install directly from the Google Workspace Marketplace. The free tier includes 100 imports per month — no credit card required.

Step 2 — Connect your Snowflake account

Open the Brooked sidebar via Extensions → Brooked → Open. Click Add data source → Snowflake. You'll need:

• Your Snowflake account identifier (e.g. myorg-myaccount or xy12345.us-east-1)
• A warehouse name
• Your role (e.g. ANALYST, SYSADMIN)

Brooked authenticates via OAuth 2.0 — no passwords are stored. You'll be redirected to Snowflake's login page to authorize the connection.

Step 3 — Run your first import

With the connection active, click New import, select Snowflake as the source, and write your SQL query in the editor. Choose a destination range in your sheet (e.g. Sheet1!A1) and click Import. Results appear in seconds.

To schedule automatic refreshes, toggle Auto-refresh on the import and choose a cadence — hourly, daily, or weekly. Brooked will re-run the query and update your sheet on schedule without any manual action.

Two-way sync — writing data back to Snowflake

Brooked supports writing data from Google Sheets back into Snowflake tables. Select a sheet range, choose a target Snowflake table, and pick an operation: INSERT, UPDATE, UPSERT, or DELETE. This makes Brooked useful not just for reporting but for workflows where your team edits data in Sheets and needs those changes reflected in the warehouse.

Using the AI agent with Snowflake

Open the Chat tab in the Brooked sidebar and ask questions in plain English — the agent inspects your Snowflake schema, writes the SQL, and returns results directly into Sheets. No SQL knowledge required.

Brooked AI — Snowflake

Live

Ask anything about your Snowflake data…

The agent keeps session context throughout your conversation. Save any result as a named import and schedule it to turn one-off queries into live, auto-refreshing reports.

Common use cases

• Finance reporting — pull P&L and margin data from Snowflake into a live dashboard that refreshes every morning
• Operations analytics — import operational KPIs for stakeholder review without granting Snowflake access
• Sales pipeline — sync deal and revenue data on a schedule for weekly forecast sheets
• Ad-hoc analysis — run exploratory SQL, work with results in Sheets, share findings immediately
• Data entry — let operations teams update lookup tables in Sheets and sync changes back to Snowflake

Troubleshooting common issues

Frequently asked questions