Every realistic way to get Salesforce data into Google Sheets in 2026 — manual report exports, Data Loader, Zapier, Apps Script with SOQL, and a no-code connector — plus the API-edition gotcha that blocks most setups.
Revenue and finance teams constantly need Salesforce data in a spreadsheet — pipeline for the forecast, closed-won for bookings, owners for territory views. The default workflow is exporting a report to CSV and pasting it in, which goes stale the moment you do it. This guide covers every realistic way to connect Salesforce to Google Sheets in 2026 — manual exports, Data Loader, Zapier, Apps Script with SOQL, and a no-code connector like Brooked — and the one edition gotcha that blocks most setups.
First, check your Salesforce edition — it decides everything
Every method except the manual CSV export goes through the Salesforce API, and the API is only enabled on Enterprise, Unlimited, and Developer editions. Professional Edition requires the API access add-on. If your org can't enable API access, no connector or script will work and you're left with manual exports — so confirm this before you spend time on setup.
Salesforce to Google Sheets: 5 methods compared
| Method | Cost | Setup | Refresh | Best for |
|---|---|---|---|---|
| Manual report export (CSV) | Free | Per export | Manual | Quick one-off snapshots |
| Salesforce Data Loader | Free | Technical setup | Manual / scripted | Bulk one-time pulls |
| Zapier / Make | From $20/mo | ~1 hour | Trigger-based | Row-by-row automations |
| Apps Script + SOQL | Free | Developer time | Scheduled (you maintain it) | Custom in-house pulls |
| Brooked | $29/user/mo | ~3 minutes | 15-min / hourly / daily | Live pipeline & forecast reporting |
Connect Salesforce to Google Sheets with Brooked
Install Brooked from the Google Workspace Marketplace, then authorize Salesforce over OAuth to grant read access to your org. From the sidebar, pick a standard object (Accounts, Opportunities, Contacts, Leads), point at a saved report, or write SOQL for anything custom — the results land in your sheet. Set the import to refresh every 15 minutes, hourly, daily, or weekly so your pipeline and forecast tabs stay live, and ask the AI Analyst questions like "weighted pipeline by stage this quarter" in plain English.
The connection is read-only — Brooked imports Salesforce data for reporting, it doesn't write edits back to records. Tying pipeline to revenue? Pull QuickBooks and HubSpot into the same workbook, or see how Brooked stacks up in Brooked vs Coefficient.
Frequently asked questions
Is there a native Salesforce connector for Google Sheets?
Not a first-party live one. Salesforce lets you export a report to CSV or Excel manually, and the legacy Data Loader handles bulk pulls, but neither keeps a Sheet live. For scheduled, refreshable data you need a connector or an Apps Script that calls the Salesforce REST API. Brooked is a Google Workspace add-on that connects Salesforce directly to Sheets — pick an object or report, import, and schedule auto-refresh.
Which Salesforce editions work with the connection?
Brooked connects through the Salesforce API, which is enabled on Enterprise, Unlimited, and Developer editions. Professional Edition needs the API access add-on. If your org can't enable API access, the manual report export is the only path — this is the single most common thing that blocks setup, so check it first.
Can I pull a Salesforce report into Sheets, or only objects?
Both. Select a standard object (Accounts, Opportunities, Contacts, Leads) and Brooked imports it, or point it at a saved report. For anything custom, write SOQL directly and Brooked runs it against your org.
Can Brooked write data from Google Sheets back to Salesforce?
No — the Salesforce connection is read-only. Brooked imports Salesforce data into Sheets for reporting and analysis; it does not push edits back to Salesforce records. (Two-way write-back is available on Brooked's database and warehouse connectors, not on CRM sources.)
How do I schedule automatic Salesforce refreshes in Google Sheets?
On Brooked Pro, toggle Auto-refresh on any saved Salesforce import and choose every 15 minutes, hourly, daily, or weekly. The sheet updates on schedule with no manual re-run — useful for live pipeline and forecast reports.
How does Brooked compare to Coefficient or Supermetrics for Salesforce?
Coefficient and Supermetrics both connect Salesforce but are priced higher and aimed at broader GTM/marketing reporting. Brooked Pro is $29/user/month, lives natively in Google Sheets, and pairs Salesforce data with an AI Analyst — see the Brooked vs Coefficient comparison for the full breakdown.
Ready to connect Salesforce to Google Sheets?
Install Brooked free — 100 imports per month, no credit card required. Or see the full Salesforce integration details.
Install for Google Sheets
