A useful location sheet has one physical location per row, column headings in the first row, and a complete name and address for each location. Keep your own headings; Storepoint lets you match them during setup.
Ready to connect? Follow Set up Google Sheets sync. For an overview of the finished map, see Google Sheets store locators.
Start with a clean location list
Keep the list on one tab. Separate summary rows, totals, merged headings, and internal notes from the records you want to sync. If one retailer has five branches, give each branch its own row and address.
Use this example as a structure, not a required naming convention:
| Store | Street | City | Province | Country | Products |
|---|---|---|---|---|---|
| Casa Giulina | 100 King Street West | Toronto | Ontario | Canada | Coffee, Tea |
| Cedar & Co. | 250 Queen Street West | Toronto | Ontario | Canada | Coffee |
These are sample records. Use your own verified location details when publishing.
You can also download the Storepoint location template and import it into Google Sheets.
Give each row an address customers can visit
Use a complete street address and include the country, particularly when your list spans multiple countries. Keep postal codes as text when leading zeros matter. Check that a head-office address has not been copied onto every branch.
You can use one full-address column or split address parts into separate columns. Storepoint combines the mapped parts during setup. If you have verified map coordinates, keep a latitude column and a longitude column as well.
Choose consistent product and service tags
Use a comma-separated list such as Coffee, Tea, Parking. Agree on the spelling of each tag so Coffee and Coffee products do not become unintentionally different choices.
Tags can describe carried products, dealer services, retailer types, or accessibility features. They describe the data you maintain; they do not measure current shelf inventory. After syncing, organize them into filter groups.
Separate public details from internal information
Useful public columns include phone, website, opening hours, product tags, and direct image URLs. Internal account notes can remain unmapped, but consider keeping confidential material outside any sheet shared using general link access.
Create any extra custom location fields in Storepoint before mapping them. Use direct image URLs instead of a link to a photo viewer page.
Check these before connecting
- Every row represents one location with a name and complete address.
- The first row contains a heading for each column.
- Duplicate branch rows and summary rows have been removed.
- Product and service tags use consistent spelling.
- The document is a native Google Sheet, not an Excel file merely stored in Drive.
Next, connect your sheet and choose a sync schedule. That guide covers read access, mapping, updates, removal behavior, and troubleshooting.