Create map from Google Sheets with Google Maps JavaScript API (demo).
-
Info window:
- Title / ID
- Picture
- Info lines, as many as you want
-
Custom marker cluster images
-
URL options:
- Center (latitude & longitude)
- Zoom
-
Set Google Cloud APIs.
- Get an API Key
- Create Maps API
- Set Google Sheets API
-
Put the API Key in
index.html
. -
Put folowing data in
gsmap.js
:- Google Sheets ID
- Google Sheets sheet name
- API Key
- Maps ID
-
Arrange map data in Google Sheets as follows:
- First row: Column titles. Name them anything as you want.
- Column A: Info window title / ID.
- Column B & C: Latitude & longitude respectively.
- Column D: Info window image.
- Other columns: Info lines, as many as you want.
-
Get a web server to test.
The custom cluster images must be served from a web server to load.