Map to Sheets: Connect Your Map to Google Sheets

Map to Sheets is a Google Sheets add-on that lets you manage your interactive map data directly from Google Sheets. Your spreadsheet becomes a live data source for your map – ideal for bulk editing, crowdsourcing, CRM syncing, and structured data workflows.

Want to learn about the benefits first? Read Why Connect Your Interactive Map with Google Sheets to understand how this integration can streamline your workflow.

Availability: Map to Sheets is available on the Expert and Enterprise plans.

What You Can Do with Map to Sheets

• Bulk edit map locations in Google Sheets
• Send Google Form or JotForm submissions to your map
• Sync CRM data (Salesforce, HubSpot, and more)
• Use Google Sheets formulas to structure and enrich map content

Learn more about the different ways you can connect data to your map.

Install the Map to Sheets Google Sheets Add-on

You can install Map to Sheets from the Google Workspace Marketplace.

Or install it directly inside Google Sheets:

1. Open a Google Sheet
2. Go to Extensions → Add-ons → Get add-ons
3. Search for Map to Sheets
4. Click Install

During installation, you will be prompted to grant the permissions required for syncing map data.

To open the add-on, click the Map to Sheets icon in the right-side panel. If the panel is hidden, expand it using the arrow in the bottom-right corner.

Initial Setup (One-Time per Map)

1. Click Initial Setup in the add-on
2. Enter your API Key:
   • In the Mapme Editor, go to Account → API Access Token
   • Click Create to generate a key
3. Click Create to generate the map data template
4. We recommend you rename the sheets so you can easily identify it, for example “MTS” (initial of Map To Sheets”)

Set Your Map ID

Enter your Map ID in cell B1 of the Map to Sheets spreadsheet.

1. In the Mapme Editor, open the About page
2. Click Copy next to your Map ID
3. Paste it into cell B1

Map to Sheets is now connected to your map.

To manage multiple maps, create a separate sheet for each map and repeat the setup.

Use Case Configuration

Next, choose how you want to use Map to Sheets. There are four supported workflows:

1. Direct Editing (Default) – Manage map locations directly in Google Sheets
2. Form Submissions – Send Google Forms or JotForm responses to your map
3. Data Integrations – Sync CRM and third-party data automatically
4. Data Management – Use helper sheets and formulas

Click Use Case Configuration in the add-on and select the workflow that matches your needs. The available settings will change based on your selection.

1. Direct Editing Mode

This is the most common workflow. You edit data in Google Sheets or the Mapme Editor, and the SYNC button keeps both in sync.

• Click SYNC to pull existing map data into Google Sheets
• Edit or add rows in Sheets
• Click SYNC again to push changes to the map

Large maps may take up to a minute to sync.

When your updates are ready to go live, click PUBLISH in the Mapme Editor.

Important: Always click SYNC before editing in Sheets if changes were made in the Editor.

Priority Source

If a location is edited in both places, Google Sheets overrides the Mapme Editor version.

Delete Locations

Check the box in the Delete column and click SYNC.

Status Field

• new – New row added in Sheets
• modified – Edited but not yet synced
• draft – Synced but not published
• published – Live on the map
• error – See message in the add-on panel

2. Form Submissions

This workflow is designed for crowdsourcing map data. Form responses are sent to Google Sheets, processed automatically, and then pushed to your map.

Works with Google Forms, JotForm, and other tools that can send responses to Google Sheets.

See the full guide for the Form Submissions use case.

3. Connect Business Applications to Your Map

This workflow automatically integrate data from third-party platforms to your map. A common example is displaying CRM locations on a map and keeping them updated in real time.

Works with any tool that can send data to Google Sheets, including Salesforce, HubSpot, and automation tools like Zapier.

See the dedicated guide for the Data Integration workflow.

4. Data Management with Helper Sheets

Use a separate helper sheet to manage raw data, then use Google Sheets formulas to populate the Map to Sheets sheet.

Example: Use CONCATENATE to build formatted HTML content for location descriptions.

Click Send to Map when ready. This workflow is one-way (Sheets → Map).

Add Media to Map Locations

Use the media column to add:

1. Videos – YouTube, Vimeo
2. Embeds – Images, 3D tours, documents, and hosted content

Examples:

• YouTube: video;url\https://www.youtube.com/watch?v=yP2w5kPZaEg
• Matterport: embed;url\https://my.matterport.com/show/?m=sP1Dd8Saghb&play=1

Note: Direct file uploads are not supported.

Address, Latitude, and Longitude

The most common setup is using the Address field. Mapme automatically geocodes the address and fills in the Latitude and Longitude fields.

Using Coordinates as Address

If the Address field contains coordinates (for example 32.0853,34.7818), leave the Latitude and Longitude columns empty. The system will detect the format, place the marker correctly, and auto-fill the coordinate fields.

Frequently Asked Questions – Map to Google Sheets

How do I connect Google Sheets to my interactive map?

Install the Map to Sheets add-on from the Google Workspace Marketplace, open it inside Google Sheets, run the Initial Setup, enter your API key, and add your Map ID in cell B1. Your spreadsheet will then sync directly with your map.

Can I update map locations from Google Sheets?

Yes. In Direct Editing mode, you can add, edit, or delete locations in Google Sheets. Clicking SYNC sends your updates to the map. This makes Google Sheets a powerful map data management tool.

Can Google Form responses automatically appear on my map?

Yes. Using the Form Submissions workflow, responses from Google Forms, JotForm, and similar tools are sent to Google Sheets and automatically pushed to your map, making it ideal for crowdsourced mapping.

Does Map to Sheets work with CRM systems?

Yes. You can sync CRM data such as Salesforce or HubSpot to Google Sheets, and Map to Sheets will update your map automatically. This keeps location data consistent across your systems.

Which data source takes priority — the map or Google Sheets?

Google Sheets is the priority source. If a location is edited both in Sheets and in the Mapme Editor, the spreadsheet version overrides the map editor data.

Can I use formulas to create map content?

Yes. You can use Google Sheets formulas to build structured descriptions, combine fields, or format content before sending it to your map. This is useful for advanced data management workflows.

Is Map to Sheets a two-way sync?

In Direct Editing mode, syncing is two-way (map ↔ Sheets). In Data Management mode using helper sheets, syncing is one-way (Sheets → map).

What plans include Map to Sheets?

The Map to Sheets integration is available on the Expert and Enterprise plans.