top of page
Search

How to create a custom interactive map with Google Sheets

  • Writer: Nan Zhou
    Nan Zhou
  • Apr 6, 2022
  • 1 min read

Updated: Apr 1

For the last couple of weeks, we have been quietly working on something big - our first major integration - Google Sheets!


Previously, to import and update data, you would need to copy and paste the entire dataset into our builder. Now, you can import and update by simply linking it to one of your Google Sheets files!


Build a custom interactive map with Google Sheets without any coding

  1. Create a No Code Map App account

  2. Create a new map and choose a map template

  3. Under "Import Data", select Google Sheets.

  4. Enter your Google Sheets URL, and set up automatic data sync

  5. Select the data fields you want to import, and click on "Map My Data"

  6. Customise the map to match your branding



How it works?



I. IMPORT DATA

  1. Click on "Import data" and select the Google Sheets option.

  2. Enter your Google Sheets public link URL.

  3. Select your auto data sync frequency

  4. Select the data columns you want to import (up to 50 columns)

  5. Click on the "Map My Data" button and that's it!



II. UPDATE data

If you don't want to use the auto data sync feature, you can also manually sync.

  1. Go to "Configure data", and

  2. Click on "Sync the latest data"



III. Change file link

If you want to change the Google Sheets file link, simply click on the "Remove sync" button then you will be able to add in a new file URL.



Google Sheets integration is just one of the many data source integration we have planned for our app. So please stay tuned for much more! :)


Nan

 
 
 

1 comentario


nocodemapapp
07 abr 2022

Thanks! This is great. Will you be planning to auto-sync in the future? Would love to be able to simply update the Google Sheet to update the map. This will be helpful for automation as well, where I set up multiple ways to add rows to the Sheet, and it all auto-feeds into the live map. Thoughts?

Me gusta
bottom of page