# Update inventory from a Google Sheet

With Stockeo, you can sync the inventory in your Shopify store from a Google Sheet.

{% embed url="<https://www.youtube.com/watch?v=WEjzW2EpYW8>" %}
Update Shopify inventory from a Google Sheet
{% endembed %}

### Publish the spreadsheet as CSV

The first step is to make the spreadsheet available as a CSV file under a link.

In Google Sheets, click on File > Share > Publish to web

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

Change the publication format from "Web page" to "Comma-separated values (.csv)", and click Publish.

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

Copy the file link that appeared after you clicked Publish.

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

### Set up an automation in Stockeo

Create a new automation in Stockeo.

In the Feed Source section, paste the link you copied in the previous step into the URL field.

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

In the Data Mapping section, switch the format to CSV, and specify which column in the Google Spreadsheet contains SKUs and which one contains quantities. You can also add mapping for other columns if you want to sync other information like cost or price.

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

That's all you need to configure. Make sure to save the settings.

### Run the automation

You can either wait until the scheduled time or run the automation manually. If you want to run it immediately, then go to the Automations page, and click on More actions > Run.

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


---

# Agent Instructions: 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://help.stockeo.solvenium.com/common-use-cases/update-inventory-from-a-google-sheet.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.