Google Sheets URL is invalid or not syncing

What this article helps you do

Fix “invalid URL” or sync failures when connecting a Google Sheet to Mapstore. Mapstore requires a published CSV export URL, not an edit link. This guide walks you through the correct format and common mistakes.

Before you start

• You have a Google Sheet with store data (name, address, and any optional columns)
• You can access File -> Share -> Publish to web in Google Sheets
• You’re in Mapstore Stores -> Bulk where the Google Sheets sync URL is entered

Step-by-step instructions

1. Use the published CSV export, not the edit link

Mapstore rejects edit links. A valid URL must:

• Be from docs.google.com
• Include /pub in the path (published format)
• Have output=csv as a query parameter

Correct format:
https://docs.google.com/spreadsheets/d/YOUR_SHEET_ID/pub?output=csv

Incorrect:
https://docs.google.com/spreadsheets/d/YOUR_SHEET_ID/edit - Edit link; will not work.

2. Publish the sheet correctly

1. In Google Sheets, go to File -> Share -> Publish to web
2. Choose the sheet or range (usually the first sheet)
3. Set format to Comma-separated values (.csv)
4. Click Publish
5. Copy the generated URL - it should contain /pub and output=csv

3. Check for the edit-link error

If Mapstore says “This looks like a Google Sheets edit link,” you pasted the URL from the browser address bar while editing. Use the URL from Publish to web instead.

4. Verify the URL structure

• Host: docs.google.com
• Path: /spreadsheets/d/{sheet-id}/pub
• Query: output=csv (required)

If any of these are missing or different, sync will fail. Re-publish and copy the URL again.

5. Ensure the sheet has data

• Header row with at least name and address
• At least one data row with values in both columns
• Empty sheets or missing required columns cause “no stores” or validation errors

6. Sharing and permissions

The published URL is publicly readable. If you’ve restricted sharing, ensure “Anyone with the link” can view (or the URL is publicly accessible). Private sheets can cause fetch failures or timeouts.

How to verify it worked

• Mapstore accepts the URL without an error message
• First sync completes and stores appear under Stores
• Editing a value in the sheet and re-syncing shows the update in Mapstore

Common issues and fixes

Related articles

• Syncing store locations from Google Sheets
• Use the Google Sheets template and publish it correctly
• Preparing a CSV file for store import
• Understand skipped rows and import warnings