Salesforce reports are powerful, but getting that data into a spreadsheet where your team can slice it, chart it, and plan around it requires a Google Sheets Salesforce integration that most teams cobble together with CSV exports. Google's own Salesforce Connector add-on has over 2 million installs on the Workspace Marketplace, which tells you how common this need is.
The good news: you have four real options, ranging from free to $50 per month. The bad news: most guides skip the edition requirements, the sync limitations, and what happens when your data gets dirty in transit. This post covers all four methods, what each one costs, where each one breaks, and which one fits your use case.
If your goal is getting Salesforce account data onto a map for territory planning, you can skip the paid tools entirely. Export your report to Sheets (two clicks), open InstaMaps, and your accounts render on a filterable map in about 90 seconds. Free, no admin setup, no sync configuration.
- →Salesforce offers a free Google Sheets connector add-on that pulls reports and custom queries into spreadsheets.
- →Third-party tools like CRM Data Sync and G-Connector add two-way sync, scheduled refreshes, and SOQL support.
- →InstaMaps is free and turns any Salesforce export in Google Sheets into a filterable, layered map in under 5 minutes.
- →The Salesforce Connector requires Salesforce Enterprise Edition or above. Professional Edition users need a third-party workaround.
- →Two-way sync tools cost $15 to $50 per month and carry data risk: one wrong edit in a sheet overwrites your CRM record.
- →For territory visualization and QBR prep, the free one-way export plus InstaMaps covers 80% of what sales ops teams actually need.
- →If your team needs live bi-directional sync, use a dedicated tool. Do not try to hack it with Zapier for production data.
4 Google Sheets Salesforce Integration Methods Compared
Every method falls into one of four buckets: the official Salesforce Connector add-on, third-party bi-directional sync tools, manual export, or automation platforms. Here is how they stack up.
The official Salesforce Connector is free and built by Google. It pulls Salesforce reports and SOQL queries directly into Sheets. It also supports pushing edits back to Salesforce. The catch: it requires Salesforce Enterprise Edition or above, and the two-way sync has no conflict resolution. If two people edit the same cell, last write wins.
Third-party tools like G-Connector (free tier, then $15/month) and CRM Data Sync ($29 to $49/month) add scheduled refreshes, better conflict handling, and support for more objects. These are worth paying for if your team lives in Sheets and updates Salesforce records from there daily.
Manual export is what most teams default to: run a Salesforce report, export to CSV, import into Sheets. It works, but it breaks the moment someone needs fresh data and forgets to re-export. For mapping and visualization, though, this is all you need.
How to Set Up the Free Salesforce Connector
The Google Salesforce Connector is the fastest free path to getting live Salesforce data into a spreadsheet. Here is the setup.
Open Google Sheets, go to Extensions > Add-ons > Get add-ons, and search for 'Salesforce Connector'. Install it. You will authenticate with your Salesforce credentials (this requires API access, which means Enterprise Edition or above for most orgs).
Once connected, open any sheet and go to Extensions > Salesforce Connector > Open. Choose Import to pull in a report or run a custom SOQL query. Pick your destination tab and the data lands in your sheet. You can also use Insert/Update mode to push edits back.
Limitations to know about: no automatic scheduled refresh on the free connector (you hit Refresh manually), no mobile access, and edits pushed back to Salesforce bypass validation rules if you are not careful. For read-only use cases like territory analysis, these limitations do not matter.
From Sheets to Map: Visualizing Your Salesforce Data
Once your Salesforce data is in Google Sheets, the next question is what to do with it. For sales ops teams, the highest-value move is putting those accounts on a map. Territory coverage gaps, rep workload balance, and cluster opportunities all become obvious in seconds when you see them geographically.
InstaMaps handles this directly. Open the add-on in the sheet where your Salesforce data lives. It detects address columns automatically using AI. Hit Load Map and every account appears on a Google Map with auto-generated filters for any column in your data (industry, owner, stage, close date).
This works with any Salesforce export method: the official connector, a manual CSV export, or a third-party sync tool. As long as the data is in a Google Sheet with address columns, InstaMaps maps it. The `layer_` tab prefix lets you stack multiple data sets on one map, so you can overlay accounts by rep, by region, or by product line.
Common Problems and How to Fix Them
Salesforce Enterprise Edition requirement blocks about 40% of teams who try the official connector. If you are on Professional Edition, use manual export or a third-party tool that authenticates differently.
Dirty addresses are the silent killer. Salesforce lets reps type addresses freehand, which means your data is full of typos, missing zip codes, and abbreviated street names. Before mapping, sort your address columns and scan for blanks and inconsistencies. InstaMaps' AI detection handles most of this, but grossly malformed addresses will fail to geocode.
Two-way sync data loss happens when someone filters a sheet, edits visible rows, and syncs back. The rows hidden by the filter get overwritten or skipped depending on the tool. If you use two-way sync, lock down who can edit synced sheets and audit changes weekly.
Check your Salesforce edition before installing the connector (Setup > Company Information).
Clean address data before mapping: trim blanks, standardize abbreviations.
Restrict write-back permissions to one or two trusted users.
Test any sync tool on a sandbox Salesforce instance before connecting production.
At a Glance
| Feature | InstaMaps | Salesforce Connector / CRM Data Sync |
|---|---|---|
| Price | Free | Free to $49/month |
| Salesforce to Sheets | Export report (2 clicks) | Live sync / scheduled refresh |
| Sheets to Salesforce | Not supported (roadmap) | Yes (with conflict resolution) |
| Map visualization | Built-in, AI address detection | Not included |
| Setup time | Under 5 minutes | 10 to 30 minutes |
| Salesforce edition required | Any edition | Enterprise+ for official connector |
Map your Salesforce accounts in under 5 minutes — no admin setup.
Common Questions
Only for the official Salesforce Connector add-on. If you are on Professional Edition, export your Salesforce report directly to Sheets (File > Export in Salesforce) and use that. InstaMaps and other tools work with any edition because they read the spreadsheet, not the CRM directly.
The official Salesforce Connector supports this, and so do paid tools like CRM Data Sync and G-Connector. InstaMaps does not write back to Salesforce (that is on the roadmap). For most sales ops teams doing territory planning, one-way data flow is sufficient.
Open InstaMaps from Extensions > InstaMaps > Open. It auto-detects your address columns. Click Load Map and every account appears on a filterable Google Map. You can add layers for different reps or regions using the layer_ tab prefix. No geocoding API key needed.
Yes for reading. For write-back, be cautious. The connector has no field-level permission control, so any user with sheet access can edit any synced field and push it to Salesforce. Restrict write-back to a small group and test in sandbox first.
Export any Salesforce report to Google Sheets, open InstaMaps, and see every account on a filterable map in under 5 minutes. No sync configuration, no admin setup, no cost.
Install InstaMaps Free