> For the complete documentation index, see [llms.txt](https://sl-guide.storeify.app/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://sl-guide.storeify.app/import-and-sync-from-google-sheets.md).

# Import and Sync from Google Sheets

Keep your locations in a Google Sheet and let Store Locator import them for you. This guide covers preparing the sheet, connecting it, previewing and applying changes, and turning on automatic sync.

**Before you begin:** you need access to the app in your Shopify admin and a Google account that can edit the sheet. To import rows without coordinates, add your Google Maps API key in **Settings > General > Google map API key** first.

> <mark style="color:$primary;">**Plans.**</mark> Importing from Google Sheets is included in the **Startup** plan and above. Automatic sync is included in the **Pro** plan and above. See Pricing in the app for your plan’s location limit.

### Contents

1. Understand how Google Sheets import works
2. Find Google Sheets in the app
3. Quick start: import your first sheet
4. Prepare your sheet
5. Share and connect your sheet
6. Preview and apply changes
7. Add, edit and delete locations from your sheet
8. Keep locations in sync automatically
9. Troubleshooting
10. Frequently asked questions
11. Checklist

### 1. Understand how Google Sheets import works

* Your **sheet** is a Google Sheet with one location per row. Row 1 holds the column names.
* You **connect** one sheet (and one tab of it) to your store. You can switch to another sheet at any time.
* The **first import** sends every row. After that, each import applies only the rows you **added**, **edited** or **deleted** since the last import. Rows that didn't change are left alone.
* Each row is matched to a location already in Store Locator by its **url\_key**, or, if the row has no url\_key, by **name + street + city**. A matching row updates that location; a row with no match becomes a new location.
* Only the columns in your sheet are changed. If your sheet has no thumbnail column, for example, your locations keep their images.

The workflow:

1. Prepare the sheet and share it.
2. Connect it in the app.
3. Preview what will change.
4. Apply the changes.
5. Optional: turn on automatic sync, so edits in the sheet reach your store locator by themselves.

### 2. Find Google Sheets in the app

| Where                                        | What you do there                                                             |
| -------------------------------------------- | ----------------------------------------------------------------------------- |
| **Locations > Import > Import Google Sheet** | Prepare, connect, preview, import and set up automatic sync                   |
| **Google Sheets** in the app menu            | The same steps, on their own page                                             |
| **Pricing**                                  | See which plan includes importing and automatic sync, and your location limit |

| Plan      | Import from Google Sheets | Automatic sync | Locations    |
| --------- | ------------------------- | -------------- | ------------ |
| Free      | —                         | —              | 1            |
| Startup   | Yes                       | —              | Up to 100    |
| Pro       | Yes                       | Yes            | Up to 1,000  |
| Advanced  | Yes                       | Yes            | Up to 5,000  |
| Platinum  | Yes                       | Yes            | Up to 10,000 |
| Unlimited | Yes                       | Yes            | Unlimited    |

<figure><img src="https://3193615300-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MbGA3WnXKJXk8zrgkrt%2Fuploads%2FySNT42jF16mAB4tRISAh%2Fimage.png?alt=media&amp;token=7606aa6e-55b7-4b84-9e9a-4cc0d7b168b7" alt="The Import Google Sheet tab on the Import Locations page."><figcaption><p>The Import Google Sheet tab on the Import Locations page.</p></figcaption></figure>

### 3. Quick start: import your first sheet

#### Step 1: Create your sheet

1. Open **Locations > Import** and click the **Import Google Sheet** tab.
2. Click **Make a copy of our template**. Google Sheets opens a copy in your Google Drive.
3. Replace the example row with your locations, one per row.

#### Step 2: Share the sheet

1. In Google Sheets, click **Share**.
2. Under General access, choose **Anyone with the link** and keep the role **Viewer**.
3. Click **Copy link**.

#### Step 3: Connect the sheet

1. Back in the app, paste the link into **Google Sheet link**.
2. Click **Connect sheet**.

#### Step 4: Preview

1. Click **Preview**.
2. Fix any rows listed under **Rows to check in your sheet**, then click **Preview** again.

#### Step 5: Import

1. Click **Import N locations** (N is the number of rows to import).

> <mark style="color:$primary;">**Expected result:**</mark> the progress bar reaches the end and shows **Import finished**. Your locations appear in **Locations** and on your store locator.

### 4. Prepare your sheet

Put the column names in row 1 and one location per row below. Columns are matched by name, so their order doesn't matter. Columns the app doesn't know are skipped, and the preview lists them.

**Required:** **name**, plus an address (**street**, **city**…) or **lat** and **lng**.

#### Start from the template or the sample

| Button                          | What it does                                                                                    |
| ------------------------------- | ----------------------------------------------------------------------------------------------- |
| **Make a copy of our template** | Opens a copy of our template sheet in your Google Drive                                         |
| **Download sample (Excel)**     | Downloads the same columns with an example row. Open it in Google Sheets with **File > Import** |
| **Copy column names**           | Copies all column names. Click cell A1 of your own sheet and paste: one name per column         |

#### Columns

| Column                                  | What to put in it                                                                                                                                                                                                                                                           |
| --------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| name                                    | Location name (required)                                                                                                                                                                                                                                                    |
| url\_key                                | A unique handle for the location's page, for example `downtown-store`. Letters, numbers and single hyphens. Also identifies the row ([see section 7](https://sl-guide.storeify.app/import-and-sync-from-google-sheets#id-7.-add-edit-and-delete-locations-from-your-sheet)) |
| status                                  | Active or Draft (see below)                                                                                                                                                                                                                                                 |
| thumbnail                               | Image URL                                                                                                                                                                                                                                                                   |
| email                                   | Email address                                                                                                                                                                                                                                                               |
| web\_text                               | Text shown for the website link                                                                                                                                                                                                                                             |
| web                                     | Website URL                                                                                                                                                                                                                                                                 |
| street, city, region, postcode, country | Address                                                                                                                                                                                                                                                                     |
| lat, lng                                | Latitude and longitude, for example `37.7749` and `-122.4194`                                                                                                                                                                                                               |
| telephone                               | Phone number                                                                                                                                                                                                                                                                |
| description                             | Description of the location                                                                                                                                                                                                                                                 |
| schedule                                | Opening hours, in the same format as the sample file                                                                                                                                                                                                                        |
| sort\_order                             | A number that sets the order in the store list                                                                                                                                                                                                                              |
| products                                | Products for the location, in the same format as the sample file                                                                                                                                                                                                            |
| tags                                    | Tags, separated by commas                                                                                                                                                                                                                                                   |
| social                                  | Social links, in the same format as the sample file                                                                                                                                                                                                                         |
| icon\_marker                            | Map pin image URL                                                                                                                                                                                                                                                           |
| meta\_title, meta\_description          | SEO title and description of the location page                                                                                                                                                                                                                              |

**Other column names that work.** Names are not case-sensitive, and spaces count as underscores. These common names are also recognized:

| Use for                         | Also accepted                           |
| ------------------------------- | --------------------------------------- |
| name                            | Store name, Location name, Store, Title |
| url\_key                        | Handle, Slug                            |
| status                          | Active, Published, Visibility           |
| street                          | Address, Street address, Address 1      |
| city                            | Town                                    |
| region                          | State, Province, County                 |
| postcode                        | Zip, Zip code, Postal code, Post code   |
| lat / lng                       | Latitude / Longitude, Lon, Long         |
| telephone                       | Phone, Phone number, Tel, Mobile        |
| email                           | E-mail, Email address                   |
| web                             | Website, Website URL, URL               |
| thumbnail                       | Image, Image URL, Photo, Logo           |
| schedule                        | Opening hours, Hours                    |
| meta\_title / meta\_description | SEO title / SEO description             |

**Status values.** Active, Yes, True, 1, Published, Enabled, On, Visible or Show make a location **Active**. Draft, No, False, 0, Inactive, Disabled, Off, Hidden, Hide or Unpublished make it **Draft**. An empty cell uses the status chosen in **Status of new locations**.

**Custom fields.** Add a column named `cf_` followed by the field key, for example `cf_opening_note`. You'll find each key on the Custom fields page (**Settings > Store information visibility > Manage custom fields**). A column named exactly like the field's label also works.

> <mark style="color:$warning;">**Row limit.**</mark> A tab can have up to 20,000 rows. For more, split the locations over several tabs and import them one at a time.

### 5. Share and connect your sheet

The app needs to read your sheet. Choose one way to share it:

| Sharing                                                                       | When to use it                                           |
| ----------------------------------------------------------------------------- | -------------------------------------------------------- |
| **Anyone with the link** (Viewer)                                             | Simplest. Enough for importing by hand                   |
| Add the email address shown in step **2. Connect your sheet** as a **Viewer** | Keeps the sheet private. **Required for automatic sync** |

To add the email address: in Google Sheets click **Share**, paste the address shown on the page (use the copy button next to it), choose **Viewer** and click **Send**.

#### Connect

1. In Google Sheets, click **Share > Copy link**.
2. Paste it into **Google Sheet link** and click **Connect sheet**.

> <mark style="color:$primary;">**Expected result:**</mark> the sheet's name appears with **Open sheet**, and **Tab** shows the tab to import.

<figure><img src="https://3193615300-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MbGA3WnXKJXk8zrgkrt%2Fuploads%2F2BmMDdRBkDnTHNZQE0KS%2Fimage.png?alt=media&amp;token=092ad098-072b-4e3f-aaf0-a47396f813ca" alt=""><figcaption><p>A connected sheet, with the tab selector and the <strong>Use another sheet</strong> and <strong>Disconnect</strong> buttons.</p></figcaption></figure>

#### Choose the tab

If your sheet has several tabs, pick one in **Tab**. The app imports one tab at a time.

#### Use another sheet or disconnect

* **Use another sheet** lets you paste a different link. A new sheet starts with a full import, and automatic sync is turned off until you turn it on again for the new sheet.
* **Disconnect** removes the connection. Your locations stay as they are.

> <mark style="color:$primary;">**Used the earlier Google Sheet import?**</mark> If you imported with a Sheet ID and range before, the link field is already filled in with that sheet. Click Connect sheet to keep using it.

### 6. Preview and apply changes

The preview shows exactly what an import will do, before anything changes.

#### Options

| Setting                                  | What it does                                                                                                                                                     | Default                   |
| ---------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------- |
| **Status of new locations**              | Status given to new locations when the sheet has no status column, or the cell is empty                                                                          | Active                    |
| **When a row is deleted from the sheet** | **Delete the location**, **Set the location to Draft** or **Keep the location**                                                                                  | Set the location to Draft |
| **Import every row again**               | Sends every row instead of only the changed ones. Use it to overwrite changes made in Store Locator with the values in your sheet. Shown after your first import | Off                       |

A row that matches a location already in Store Locator always updates it.

#### Read the preview

Click **Preview**.

<figure><img src="https://3193615300-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MbGA3WnXKJXk8zrgkrt%2Fuploads%2FUIIcaGLCMzHr4ommgGPy%2Fimage.png?alt=media&amp;token=0d5fa88e-d391-4dc4-be51-1363902ed4c1" alt=""><figcaption><p>The preview counts what will happen, lists the first rows with their result and the rows to fix.</p></figcaption></figure>

| You see                                 | Meaning                                                                                       |
| --------------------------------------- | --------------------------------------------------------------------------------------------- |
| **new**                                 | Rows that will become new locations                                                           |
| **changed**                             | Rows that will update a location                                                              |
| **to delete** / **to set to Draft**     | Locations whose row was deleted from the sheet                                                |
| **unchanged**                           | Rows that didn't change since the last import; they're skipped                                |
| **with errors**                         | Rows that can't be imported; listed under **Rows to check in your sheet** with the row number |
| **over plan limit**                     | New rows beyond your plan's location limit; they won't be added                               |
| **addresses to look up on Google Maps** | New rows without lat and lng; the app finds their coordinates                                 |
| **First rows**                          | The first rows that will be imported, with their result                                       |
| **Rows deleted from the sheet**         | Each removed row and what will happen to its location                                         |

The preview also warns about columns that won't be imported and about a missing **name** or address column.

#### Apply the changes

Click **Import N locations** (first import) or **Apply N changes** (later imports).

> <mark style="color:$primary;">**Expected result:**</mark> the progress shows "N of N rows · N imported · N with errors" and ends with **Import finished**. Rows that failed are listed under **Rows that were not imported**, with their row number in the sheet.

<figure><img src="https://3193615300-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MbGA3WnXKJXk8zrgkrt%2Fuploads%2FvuXpjWBywRnkvUUQvN1Y%2Fimage.png?alt=media&amp;token=f67884f4-92c3-4160-b431-51af07ee63fe" alt=""><figcaption><p>A finished import with one row that needs fixing in the sheet.</p></figcaption></figure>

Each import also appears in **Bulk Import > Recent Import History**, named after your sheet and tab.

#### Coordinates

* Rows with **lat** and **lng** are placed exactly there.
* New rows without coordinates are looked up on Google Maps using your **Google map API key** (**Settings > General**). Without a key, those rows are listed as errors.
* An existing location keeps its coordinates as long as its address doesn't change.

### 7. Add, edit and delete locations from your sheet

Once the first import is done, just edit the sheet and apply the changes again (or let automatic sync do it).

| In the sheet         | In Store Locator                                                                            |
| -------------------- | ------------------------------------------------------------------------------------------- |
| Add a row            | A new location is added                                                                     |
| Edit a row           | That location is updated; only the columns in your sheet change                             |
| Delete a row         | The location is deleted, set to Draft or kept, per **When a row is deleted from the sheet** |
| Leave a row as it is | Nothing happens to that location                                                            |

**Renaming a location.** Give every row a **url\_key**: rows are then matched by url\_key, so you can rename a location or change its address freely. Without a url\_key, a row whose name, street or city changed is still recognized when at least two of the three stay the same.

**Deleting rows safely.**

* Only locations imported from this sheet are deleted or set to Draft. Locations you added in Store Locator are never touched.
* If more than half of the rows (and more than 5) disappear at once, for example when the sheet was cleared or the wrong tab is selected, nothing is removed and the preview shows a warning. Delete those locations in **Locations** if that was intended.

**Rows with errors** are not counted as imported: fix them in the sheet and they're tried again on the next import.

{% hint style="info" %} <mark style="color:$warning;">**Changes made in Store Locator.**</mark> Editing a location in the app doesn't change your sheet. The sheet's values return only when you edit that row in the sheet again, or import with **Import every row again**.
{% endhint %}

### 8. Keep locations in sync automatically

> <mark style="color:$primary;">**Pro plan and above.**</mark> Automatic sync is included in the Pro, Advanced, Platinum and Unlimited plans.

When the sheet changes, Google notifies Store Locator. About 3 minutes after your last edit, only the rows you added, edited or deleted are applied, with the options from step 3. Nothing is imported while the sheet stays the same.

#### Turn it on

1. Share the sheet with the email address shown in step **2. Connect your sheet**, as a **Viewer**. "Anyone with the link" isn't enough for automatic sync.
2. In **4. Keep locations in sync automatically**, select **Update locations automatically when the sheet changes**.
3. Click **Save sync settings**.

> <mark style="color:$primary;">**Expected result:**</mark> a "Automatic sync is on." message, and the status line shows **Watching the sheet for changes.**

<figure><img src="https://3193615300-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MbGA3WnXKJXk8zrgkrt%2Fuploads%2Fg6vPN8hk9mLwVPkUlwsJ%2Fimage.png?alt=media&amp;token=07b4ed50-4060-4676-bd53-b012de1b2ce9" alt=""><figcaption><p>Automatic sync is on. The status line shows the last change in the sheet and the last import.</p></figcaption></figure>

#### Read the status line

| Status                          | Meaning                                                                                                         |
| ------------------------------- | --------------------------------------------------------------------------------------------------------------- |
| Watching the sheet for changes. | Automatic sync is on                                                                                            |
| Last change in the sheet: …     | When Google last reported an edit                                                                               |
| Last import: …                  | When changes were last applied, followed by a summary such as "5 new or changed rows, 1 location set to Draft." |
| Checked …: nothing to update.   | The sheet was edited, but no location data changed (for example, only formatting)                               |

#### Apply changes right away

Click **Sync changes now** to apply the rows changed since the last import without waiting.

#### When automatic sync turns itself off

Automatic sync stops, and the status line says why, when:

* the sheet is deleted or moved to the trash, or the app can no longer open it;
* 5 syncs in a row fail;
* your plan no longer includes automatic sync.

Fix the cause, then select **Update locations automatically when the sheet changes** and click **Save sync settings** again.

### 9. Troubleshooting

| Problem                                                                       | What to check                                                                                                                                                              |
| ----------------------------------------------------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| "This sheet isn't shared with us yet."                                        | In Google Sheets, click **Share** and set **Anyone with the link** (Viewer), or add the email address shown on the page as a **Viewer**                                    |
| "We couldn't find this spreadsheet."                                          | Copy the link again with **Share > Copy link** and paste the whole link                                                                                                    |
| "This is a "Publish to the web" link."                                        | Use **Share > Copy link** instead of the published link                                                                                                                    |
| "This is an Excel file stored in Google Drive."                               | Open the file and choose **File > Save as Google Sheets**, then use the link of the new sheet                                                                              |
| "The sheet is empty." or "The sheet has no locations below the header row."   | Put the column names in row 1 and the locations below. Check that **Tab** shows the right tab                                                                              |
| "No "name" column found."                                                     | Add a column named **name** (or Store name, Location name) in row 1                                                                                                        |
| A column is listed as not imported                                            | Rename it to one of the names in [section 4](https://sl-guide.storeify.app/import-and-sync-from-google-sheets#id-4.-prepare-your-sheet), or ignore it if you don't need it |
| "Add an address (street, city) or lat and lng"                                | Fill in the address or both coordinates for that row                                                                                                                       |
| "No lat/lng, and no Google Maps API key in Settings…"                         | Add lat and lng to the row, or add your key in **Settings > General > Google map API key**                                                                                 |
| "url\_key can only contain letters, numbers and single hyphens"               | Use only a–z, 0–9 and single hyphens, for example `downtown-store`                                                                                                         |
| "url\_key … is also used on row N"                                            | Each url\_key must be unique: change one of the two rows                                                                                                                   |
| "url\_key … belongs to another location"                                      | Another location already uses that url\_key: choose a different one                                                                                                        |
| Rows show **over plan limit**                                                 | Your plan's location limit is reached. Upgrade in **Pricing**, or remove locations you don't need                                                                          |
| "This sheet has more than 20,000 rows."                                       | Split the locations over several tabs and import them one at a time                                                                                                        |
| "The previous import from this sheet is still running."                       | Wait for the current import to finish, then try again                                                                                                                      |
| Deleted rows weren't removed, with a warning about rows gone at once          | More than half of the rows (and more than 5) disappeared together. Check the tab and the sheet; delete the locations in **Locations** if that was intended                 |
| Automatic sync won't turn on: "To sync automatically, share the sheet with …" | Add the email address shown on the page as a **Viewer** of the sheet                                                                                                       |
| Automatic sync won't turn on: "…a setup issue on our side."                   | Contact us; you can still import by hand meanwhile                                                                                                                         |
| Edits in the sheet don't show up                                              | Check that the status line says **Watching the sheet for changes.** and wait about 3 minutes after your last edit. Click **Sync changes now** to apply them right away     |
| A change made in Store Locator was undone                                     | That row was edited in the sheet afterwards, and the sheet's values were applied. Edit the sheet instead, so both stay the same                                            |

{% hint style="info" %} <mark style="color:$primary;">**Contact support**</mark> from the link at the bottom of any app page. Include the link of your sheet, the tab name, the row numbers involved and a screenshot of the message.
{% endhint %}

### 10. Frequently asked questions

#### Does deleting a row in the sheet delete the location?

Only if **When a row is deleted from the sheet** is set to **Delete the location**. The default sets it to Draft, and **Keep the location** leaves it as it is.

#### Will the import touch locations I created in the app?

It updates a location only when a row matches it (same url\_key, or same name, street and city). Deleting rows only affects locations that came from this sheet.

#### Can I use several sheets or tabs?

One sheet and one tab are connected at a time. Switch with **Tab** or **Use another sheet**.

#### How fast is automatic sync?

Changes are applied about 3 minutes after your last edit. Google sometimes reports edits a few minutes late. **Sync changes now** applies them right away.

#### Do I need lat and lng?

No. New rows without coordinates are looked up on Google Maps with your Google map API key.

#### Can I import an Excel file instead?

Yes: use the **Import Excel** tab, or open the Excel file in Google Sheets and connect it here.

#### Can I change the column order or add my own columns?

Yes. Columns are matched by name, and columns the app doesn't use are skipped.

#### What happens if I edit a location in Store Locator after importing?

Your edit stays until that row changes in the sheet, or you import with **Import every row again**.

### 11. Checklist

* [ ] Row 1 has the column names, including **name** and an address or **lat**/**lng**.
* [ ] Every row has a unique **url\_key** (recommended).
* [ ] The sheet is shared (Anyone with the link, or the app's email as Viewer for automatic sync).
* [ ] **Google map API key** is set in **Settings > General** if some rows have no coordinates.
* [ ] **Status of new locations** and **When a row is deleted from the sheet** are set the way you want.
* [ ] **Preview** shows no rows to check.
* [ ] The first import shows **Import finished**.
* [ ] Optional: automatic sync is on and the status line says **Watching the sheet for changes.**
