Guide
Spreadsheet Map Image Creation Guide
A guide for creating latitude, longitude, address details, and map images from an address or facility name in Google Sheets with Apps Script.
Location details and map images are created on a separate sheet without changing the source sheet.
Output maps at several zoom levels such as 18, 16, 14, and 12 in one run.
Choose landscape, portrait, square, custom, or range-based map image sizes.
What this generator is for
This generator creates an Apps Script that reads an address, facility name, or store name from a configured cell in Google Sheets.
It uses the Google Maps service to create latitude, longitude, address details, and static map images on a dedicated output sheet.
It uses the built-in Apps Script Maps service, so a Google Maps API key is not required for the standard setup.
The source sheet is not changed. Review geocoding results before using generated maps in official or business documents.
Address or facility cell and output destination
Menu display language
Language used for the Google app menu and dialog or panel.
Source sheet name
The sheet that contains the data to process.
Address or facility cell
Specify the cell that contains the address, facility name, or store name in A1 notation.
Review sheet name
Sheet name where review results will be written.
Map size
Choose the map image size. Range-based mode estimates the size from the selected rows and columns.
Map image output range
Used as the base range for range-based sizing. Map images are inserted vertically from the top-left of this range.
Custom width
Width for custom size. Use 100 to 640 px.
Custom height
Height for custom size. Use 100 to 640 px.
Zoom levels
Enter the zoom levels to output, separated by commas. Values from 1 to 21 are supported.
Map size and zoom level settings
Source cell
Specify the cell that contains the address, facility name, store name, or search keyword.
Output sheet
Latitude, longitude, formatted address, and map images are written to a dedicated sheet.
Image options
Choose landscape, portrait, square, range-based, or custom size with one or more zoom levels.
Setup steps
Open Apps Script
Open Apps Script from the Google Sheets file where you want to create map images.
Create KOKOCAL_Menu.gs and KOKOCAL_MapImage.gs
Create KOKOCAL_Menu.gs and KOKOCAL_MapImage.gs in Apps Script, then paste the generated content into each file. Back up existing code before editing it.
Run setup
Select KOKOCAL_MapImage_setup from the function dropdown and run it manually. Reload the spreadsheet after setup.
Enter an address or facility name
Enter the address, facility name, or store name in the configured cell.
Create map images
Use the KOKOCAL menu to create the maps. Results are created on the dedicated output sheet.
Save the implementation guide
After generating the script, use Download setup guide at the top right of the generated result column to save the information needed for setup. Generated results disappear when you leave the page, so saving the guide before setup is recommended.
Post-setup review points
Menu display
Reload the spreadsheet and confirm that the KOKOCAL menu appears.
Location details
Confirm that latitude, longitude, and address details are created from the configured cell.
Map size
Confirm that map images use the selected preset, custom size, or range-based size.
Multiple zoom levels
Confirm that each configured zoom level is output vertically.
Source sheet unchanged
Confirm that values, formatting, and images on the source sheet were not changed.
Notes
Source sheet is not changed
The address or facility name is only read from the configured cell. Location details and map images are created on the dedicated output sheet.
Output sheet is recreated
When map images are created, contents, formatting, and images on the configured output sheet are cleared. Copy any needed output before rerunning.
No Google Cloud setup required
This script uses the built-in Apps Script Maps service. A Google Maps API key is not required, and processing runs in the Apps Script environment of the Google account that installed the script.
Google Maps service limits
Large or frequent runs may hit Apps Script or Google Maps service quotas.
Location information requires review
Geocoding results are candidates. Review map images and address details before using them in official or business documents.
Back up before use
Before changing order or temporarily hiding objects, make a copy of important slides.
Ready to generate the script
Create latitude, longitude, address details, and map images with multiple zoom levels from an address or facility name in a specified cell.
Guide
Related guides
Review these guides together with this page to make setup and operation smoother.
Getting started
Review the input column, generated result column, code, setup steps, review points, and JSON menu.
Apps Script basics
Review .gs files, HTML files, saving, first authorization, triggers, and other basics before setup.
Using multiple scripts
Learn how to organize KOKOCAL_Menu.gs, feature files, the shared menu, triggers, and permissions when combining generated scripts.