How to Map Your Salesforce Accounts (Free, No Admin Setup Required)

Most guides on how to map Salesforce accounts point you at Salesforce Maps ($75/user/month) or tell you to export a CSV and upload it to Google My Maps. Neither is a real answer. Salesforce Maps is priced for enterprise field teams, $9,000/year for 10 users before your existing Salesforce licenses. Google My Maps breaks above 200 accounts, has no dynamic filtering, and requires re-uploading your data every time anything changes in Salesforce.

There is a third option that most articles don't cover: a free Google Sheets add-on that maps your Salesforce accounts in under 5 minutes, with no admin access required, no CSV file, and AI-powered address detection. Here's the complete setup walkthrough.

What You Need Before You Start

Three things: a Google account, a Salesforce account with at least one report containing account addresses, and about 5 minutes. You don't need Salesforce admin access, any user who can export a report can do this.

The Salesforce report needs to include an address field, billing address, shipping address, or any custom address field. Full addresses work best (Street, City, State, Zip). City + State works for less precise mapping. Zip code alone works for regional views.

Step-by-Step: Map Your Salesforce Accounts

Follow these steps to get your first Salesforce account map up in under 5 minutes.

1. Install InstaMaps from Google Workspace Marketplace (search 'InstaMaps' in the Workspace Marketplace)

2. Open any Salesforce report that includes account address data

3. Export the report to Google Sheets: click 'Export' in the Salesforce report toolbar, then select 'Google Sheets'

4. In the Google Sheet, rename the tab containing your account data to start with 'layer_', for example: 'layer_Accounts' or 'layer_Q2Review'

5. Open the InstaMaps add-on: go to INSTAMAPS in the top menu bar of Google Sheets, then click 'Load Map'

6. Your accounts appear as map markers on Google Maps, one per row. AI detects your address columns automatically.

7. Use the filter panel to filter by owner, stage, industry, or any other column in your sheet

8. Zoom into a specific city or region to filter accounts by geographic viewport

Tips for Better Salesforce Account Maps

Report structure matters. Include the fields you want to filter by as columns in your Salesforce report, owner name, account stage, product line, industry. InstaMaps reads report columns as filter options, so the more relevant fields you include, the more useful the filter panel.

Color-code by territory. Create separate sheet tabs for each rep or region (layer_East, layer_West, layer_Sarah) and assign different tab colors in Google Sheets. Each tab's markers will match its tab color on the map, the fastest way to see coverage gaps visually.

Start with a filtered report. If you have 5,000 accounts in Salesforce, run the report with a filter first (this quarter's active accounts, or a specific region) so the initial map load is fast and readable.

What to Do When Accounts Don't Appear on the Map

If accounts are missing from your map, the cause is almost always the address field. InstaMaps geocodes account locations using Billing Address by default, if that field is empty or contains a PO Box, the account won't appear.

Run this Salesforce report before your next mapping session: Accounts where Billing Street equals blank, scoped to your active accounts. In most orgs, 15–30% of records have incomplete address data. To check which addresses will resolve before your mapping session, paste them into our free batch geocoder, it processes up to 100 at once and shows exactly which ones return valid coordinates. You don't need to fix them all, fix the highest-revenue accounts first and you'll have a useful map even with partial coverage.

1. Blank Billing Street, account won't appear on the map at all. Add a physical street address.

2. PO Box in Billing Street, geocodes to the wrong location or fails. Replace with a physical address.

3. City/State only, no street. InstaMaps will plot these at the city center. Accurate enough for regional views, misleading for local planning.

4. Accounts assigned to inactive owners, these will appear on the map but won't match any owner filter. Reassign or exclude from the report first.

5. Duplicate account records, both will appear as separate markers at the same location, inflating territory counts.

No Salesforce? Use Google Sheets Instead

Google Sheets is the primary interface for InstaMaps, not a fallback. Create a sheet tab with 'layer_' at the start of the name (for example: 'layer_Accounts' or 'layer_Prospects'). Add your account data with address columns. Open the InstaMaps add-on (INSTAMAPS menu, then 'Load Map') and it detects your address columns automatically, geocodes, and generates the map.

This approach works for teams that maintain their account list in Google Sheets, or that export from any CRM. HubSpot, Pipedrive, Zoho, and want to map it without Salesforce involvement.

Common Questions