Map to Sheets is available from the Google Workspace Marketplace as a Google Sheets Add-on.
With Map to Sheets, leverage the potential of Google Sheets to create and manage your interactive maps. Check out all the benefits of Map To Sheets.
Map To Sheets is available with the Pro+ plan and Enterprise plan.
Install the Mapme Add-on
You can install the Mapme Add-on directly from the Google Workspace Marketplace or open a new Google Sheet and
- go to Extensions -> Add-ons -> Get Add-ons
- Search for Map to Sheets and click on Install
During the installation process, you will be asked to give the permissions needed to run Map To Sheets.
Once the installation is completed, open a Google Sheets. In the menu go to: Extension > Add-ons > Manage Add-ons
On the Map to Sheets App, click on the 3 dots in the top right and select “Use in this document”
Configure Map To Sheets
In the Google Sheets menu, go to: Extensions > Map To Sheets and select Open. You will now see the Map to Sheets panel.
Click on “Setup” to configure the application.
API Key
To generate an API key, in the Mapme editor, select in the top right menu Account > API Access Token.
Create the data template
Click on the “Create” button to generate the data template. You only need to do this once per map.
Map Id
To find your map ID, click in the left menu on the “About” page and then click on the “Copy” button.
Paste the Map Id the B1 cell.
Map to Sheets is now ready.
If your map already has data, click on the SYNC button to pull the data from your map to Google Sheets. Depending on the amount of data, it can take up to a minute.
If your map has now data, you can skip this step.
If you want to manage multiple maps in your Mapme account, create a new sheet and repeat the setup process for each map. We recommend renaming the sheets with the map title, so you can easily identify each map.
Manage your map data
You can now add, update or delete locations in Google Sheets. When you are done, click on the SYNC button to synchronize Google Sheets with your map data.
When you are ready for the latest changes to go live, click on the PUBLISH button.
If you keep the Mapme editor open, you might need to reload the editor in order to see the updates from Google Sheets.
If you have users making changes in both the Mapme editor and Google Sheets, don’t forget to run a SYNC before making new changes in Google Sheets. This will minimize data conflicts.
The Status Field
The status column displays information about the state of each location. The options for the location status are :
- new – new location added in Google Sheets
- modified – location’s data has been modified. It is not yet synched with the Mapme editor
- draft – the location is synched between Google Sheets and the Mapme editor. It is not published yet
- published – location is published
- conflict – there is a conflict for this location between Google Sheets and the Mapme Editor
- error – error details can be found in cell Q3
Delete locations
To delete locations, use the check box in the “Delete” column. If you need to delete many locations, use the shift and drag the field. Sync Google Sheets and the Mapme editor
Conflict resolutions
If a location is modified in both the Mapme Editor and the Google Sheets, Map To Sheets automatically detects and displays information about the conflict. In order to resolve the conflict, click on the cell showing the conflict and select one of those 3 options:
- Use the value in the Mapme Editor
- Use the value in Google Sheets
- Enter a new value
Once you updated the value, mark the conflict as resolved.
