Bulk updates
Add locations and change addresses, hours, phone numbers, categories, or links across many entries in one operation.
Data management
Import and sync locations with Google Sheets
Update dozens or thousands of locations in a familiar spreadsheet and keep your locator organized without repetitive work.
Bulk updates in a familiar tool
Flexible column mapping
Preview and validation before publishing
Clear conflict and duplicate rules
Match name, address, and phone, ignore what you do not need, and validate a preview.
Compare changes, choose the priority source, and apply only validated data.
Overview
Turn your spreadsheet into the locator data source
The Google Sheets integration brings location management into a workflow operations, franchise, and marketing teams already know. Instead of editing every entry separately, connect a spreadsheet, map its columns to ShopMaply fields, and apply bulk changes with validation before publishing.
Simple collaboration
Regional teams can review data in the familiar Google Sheets interface using the organization and permissions they already know.
Fewer manual errors
Reusable mapping and validation flag missing fields, invalid formats, and possible duplicates before synchronization.
Scale without complexity
The same workflow supports a small network with a few branches or a national catalog with thousands of points.
Mapping and quality
Adapt any spreadsheet structure to locator fields
Choose which column feeds each field and how the system should interpret identifiers and blank values.
Location fields
- Name and unique identifier
- Address, city, state, postal code, and country
- Latitude and longitude when available
- Phone, email, website, and action links
- Hours, categories, tags, and custom fields
Column mapping
- Automatic detection for common headings
- Manual selection for internal naming conventions
- Ignore columns that should not be imported
- Preview values before confirmation
- Reuse the configuration on future syncs
Validation
- Warnings for missing required fields
- Invalid format detection
- Duplicate row identification
- Summary of ready, warning, and blocked rows
- Fix the spreadsheet and validate again
Conflicts
- Match using the unique location identifier
- Choose whether ShopMaply or the sheet wins
- Define how blank cells are handled
- Review additions, changes, and possible removals
- Final synchronization result report
Safe workflow
Control what changes before updating the public locator
Synchronization separates connection, validation, and publishing to prevent unexpected changes to active data.
Identification
- Use a stable ID for each branch
- Do not rely on name alone to match a location
- Keep headings consistent
- Maintain one row per location
Update strategy
- Import once or reuse the connection
- Review the summary before applying
- Define how blank values are handled
- Choose the priority source for conflicts
Governance
- Limit sheet editing to responsible teams
- Standardize formats and category lists
- Run syncs at predictable times
- Validate a sample after large changes
How to configure
Connect Google Sheets in six steps
Prepare clear headings and a unique identifier for each location before starting.
Prepare the spreadsheet
Use one row per location, add headings, and include a stable unique identifier for every branch.
Open import
In the locator admin, open Locations and choose to import or synchronize with Google Sheets.
Connect and select
Authorize the required access, then select the spreadsheet and tab containing your location data.
Map the columns
Match each column to a ShopMaply field, ignore unnecessary data, and inspect a preview of several rows.
Define conflicts
Choose the matching identifier, priority source, and behavior for blank cells, duplicates, and removed rows.
Validate and sync
Review additions, changes, warnings, and errors. Fix issues, run the sync, and inspect the final report before publishing.
Use cases
Efficient management for networks of any size
The spreadsheet becomes a simple bridge between people who know each branch and the team managing the locator.
Franchise and retail
Consolidate regional updates and change hours, contacts, and services across the network.
Distributors and dealers
Keep official resellers, coverage, and categories aligned with the commercial database.
Healthcare, education, and services
Manage clinics, campuses, offices, or service points with standardized fields.
Small teams
Manage a few locations without learning a new data tool or depending on complex integrations.
Keep exploring
Related features
Analytics
Use search data to find where your location database needs improvement.
Learn more →Visual theme editor
Present synchronized locations in an on-brand experience.
Learn more →