Many organizations store their most important location data inside business systems such as CRM platforms, internal databases, or operational tools. Instead of manually updating your interactive map, you can automatically sync this business data directly to your map using Google Sheets and Map to Sheets.
This integration turns your map into a live view of your business data. Locations, descriptions, categories, and other attributes can update automatically whenever your system sends new information — no manual editing or custom development required.
Google Sheets acts as the bridge between your system and your map, allowing structured, automated map updates without manual data entry.
This guide focuses on connecting business applications like CRM systems (Salesforce, HubSpot, and others) to your map.
If your data is managed directly in spreadsheets or collected through forms, learn more about the different ways you can connect data to your map.
How the Integration Works
This is the typical automated data flow:
- Send data from your application to Google Sheets
- Process and format the data inside Google Sheets
- Send the formatted data to Mapme using Map to Sheets
- Publish the map data
This workflow can run fully automatically without human intervention.
Important: Your application (for example, your CRM) should remain the main source of truth. Changes made directly on the map or in Google Sheets will be overwritten the next time your system sends new data.
Implementation Guide
1. Create Your Map
Start by creating a new map or opening an existing one. If your map uses categories (such as “Hotels” or “Restaurants”), set them up in the Mapme Editor before connecting your data.
2. Install the Map to Sheets Add-On
Install it from the Google Workspace Marketplace and follow the setup guide.
3. Configure Your Application to Send Data to Google Sheets
This step happens inside the external system (CRM, form tool, automation platform, etc.).
Typical fields sent to the sheet include:
- Location name
- Address (street, city, ZIP, etc.)
- Description
- Type or category
- Unique record ID
- Media URLs (images or videos with public access)
Send this data to a sheet in Google Sheets (for example, a sheet named “Data”).
4. Configure Map to Sheets
Your spreadsheet will typically contain two sheets:
- Data – Raw data imported or synchronized from your external application (CRM, database, ERP, etc.).
- Map to Sheets (MTS) – Processed data that is sent to your Mapme map.
Setup
- Open the Map to Sheets sidebar.
- Click Use Case Configuration.
- Select Data Integration.
- Select the sheet containing your incoming data.
- Select the Map to Sheets (MTS) sheet.
- Choose a submission action.
- Click Save.
Automation
By default, changes to your data are not automatically sent to your map. This allows you to review and validate new, updated, or deleted records in Google Sheets before synchronizing them with Mapme.
When you are ready, click Send to Map to process all pending changes and synchronize them with your map.
After changes have been synchronized, they are removed from the Map to Sheets (MTS) sheet to maintain performance and keep the sheet manageable.
If you want synchronization to occur automatically whenever your external application updates the spreadsheet, enable Automation. Map to Sheets automatically detects changes made to the source sheet and processes new, updated, and deleted records.
Click the Automation button and choose one of the following options:
- Automatically send data to the map – Changes are automatically synchronized with the map, but remain unpublished so you can review them in the Mapme Editor before publishing.
- Automatically send data and publish map – Changes are automatically synchronized with the map and published immediately. No manual review or publishing is required.
Click Save to apply your selection.
Notes:
- We recommend testing your integration with Automation disabled first. Once you’ve confirmed everything is working as expected, you can enable automatic synchronization.
- In some cases, Google may suspend the automation trigger. If this happens, Map to Sheets will display a notification with a link that allows you to re-enable automation with a single click.
5. Process the Data with Formulas
Use ARRAYFORMULA functions in the MTS sheet to copy and transform your raw data. All formulas should be entered in row 3.
Make sure to populate the Id field with the unique identifier used by your business application for each record. Map to Sheets uses this value to match records and update existing locations instead of creating duplicates.
Here are some examples of commonly used formulas:
=ARRAYFORMULA(Data!A1:C)Copy values from multiple columns
=ARRAYFORMULA(Data!D1:D & " " & Data!E1:E & ", " & Data!F1:F)Concatenate address fields
=ARRAYFORMULA(IF(Data!C4:C="", "", 17))Set a fixed zoom level
=ARRAYFORMULA(IF(ISBLANK(Data!G1:G),,"embed;url\""&Data!G1:G))Embed media from a URL
You can also add logic, format HTML, or use functions like ENCODEURL.
6. Test Your Setup
Verify your formulas, push the data, and confirm that locations appear correctly on the map. Once everything works, switch to automated push.
Why Use This Integration?
- Keep your map synced with business systems
- Eliminate manual map updates
- Use Google Sheets for flexible data transformation
- Scale to thousands of locations
Processing Limits
Automatic Updates
When Automatic Update is enabled, there is no limit to the number of new or updated rows that can be processed.
Manual Updates
In manual mode, Map to Sheets can process up to 1,700 new or updated rows per request. If your dataset exceeds this limit, simply click Send to Map again until all rows have been processed.
Tip: For large datasets, you may need to repeat this step several times to complete the update.
Need Help?
Visit our Support Center or contact us.