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.
Form input fields
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.
Setup steps
Open Apps Script
Open Apps Script from the Google Sheets file where you want to create map images.
Paste Code.gs
Paste the generated Code.gs content into Apps Script. If code already exists, back it up before replacing it.
Run setup
Select setupMapImageGenerator 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 Map Images menu to create the maps. Results are created on the dedicated output sheet.
Save the implementation guide
After generation, 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.
What the guide includes
The setup method, post-setup review points, generated script, settings JSON, and config hash are collected in one document. The setup method starts with a note that the generated script appears later in the guide.
Available formats
Choose Markdown (.md), Word (.docx), or the PDF save view.
Post-setup review points
Menu display
Reload the spreadsheet and confirm that the KOKOCAL Map Images 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.
Common guide
Related setup guides
In addition to this generator-specific guide, review the shared Apps Script basics and the guidance for using multiple generated scripts in the same file.
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.