> For the complete documentation index, see [llms.txt](https://helpcenter.channable.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://helpcenter.channable.com/import-data/import-how-to/import-your-product-data/import-via-a-data-file/google-sheets.md).

# Google Sheets

{% hint style="info" %}
Good to know

* Your data feed URL **must be in an accessible online location**.
* The data feed has to be updated on the same URL (recommended at least once a day) with the latest product information (e.g. available stock, prices).
  {% endhint %}

### Step 1: Your data source

{% hint style="warning" %}
**Important:** Before you start, make sure your Google sheet is [shared and publicly available](/import-data/import-how-to/import-your-product-data/import-via-a-data-file/google-sheets/share-a-google-sheet-make-publicly-available.md).
{% endhint %}

* In Channable, go to **Setup > Import** and click **+ Choose import method**.
* Select the Google sheets file type.

### Step 2: Import settings

* Provide the requested information:
  * For **Name**, give your import a descriptive name (e.g., "Webshop Google import").
  * For **Google spreadsheet url**, add the URL to fetch your live product data.
* Click **Run import**. 

### Step 3: Import mapping

This page displays fields retrieved from your data feed (e.g. price, description, title).

* **Imported data field:** Fields from your import data.
* **Project field:** Corresponding project fields in Channable. Our system will automatically detect and link most fields to standardized fields.

Match (map) your imported fields to a corresponding project field. Channable does most mapping automatically, but review and adjust before importing.

{% hint style="info" %}
**Note:** We create new project fields if we can't assign your import field to a standardized field. These fields will have a project field with the same name as your import field.
{% endhint %}

{% hint style="info" %}
Before you continue

1. Compare and adjust mapping:
   * Review your **Imported data fields** against Channable's matched **Project fields**. If a field was matched incorrectly, click on the field to select a different field.
2. Check and correct field types:
   * Check that the right field type is assigned to your project fields. If a field has the wrong type, click **Edit** next to the field, select the correct type in the dropdown, and click **Save & Import**.
3. Exclude fields (optional):
   * To exclude a field from being included in your product data, click the checkbox in the **Select** column for that field and click **Do not import selected fields**.

Once you've finished mapping, click **Save & Import** to start importing your product data. Depending on how much data you're importing, it can take a while to finish.

Note: Check the **Status** column in **Setup** to check your import progress. Your product data is fully imported when the Status is **Finished**.
{% endhint %}

### Step 3: Overview

* Go to **Overview** to view your imported products.
* After your product data has finished importing, click on an item to see detailed information.

<figure><img src="/files/OOmR6aDntkdmtBWWCtEH" alt=""><figcaption></figcaption></figure>

Your import is now successfully set up! You can now use this product data to create and optimize Feeds, Marketplaces, Shopping Ads, and more in Channable.

#### Read next

{% content-ref url="/pages/rn0Xdp1OsrxTz5nIwsQF" %}
[Combine multiple imports](/import-data/import-how-to/combine-multiple-imports.md)
{% endcontent-ref %}

{% content-ref url="/pages/XAtuxaZAvIvN503Rx8Kc" %}
[Share a Google sheet (make publicly available)](/import-data/import-how-to/import-your-product-data/import-via-a-data-file/google-sheets/share-a-google-sheet-make-publicly-available.md)
{% endcontent-ref %}


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://helpcenter.channable.com/import-data/import-how-to/import-your-product-data/import-via-a-data-file/google-sheets.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.