EZ Inventory can automatically read data from a Google Sheets spreadsheet and bulk update the available inventory quantity in Shopify.

The steps below will walk you through how to do this.

1. Open the Google Sheets spreadsheet and click the "Share" button on the right.

2. Set the sharing settings (view/read-only permission is fine) and copy the link.

3. In EZ Inventory, create a Data Feed. Then under Source Data > Feed Type, select "Web (HTTP/HTTPS)". Select "CSV" for the Format option, and paste the link under "Website URL".

4. In the Field Mapping section, specify the column names.

5. (Optional) If you'd like to schedule the inventory update to run automatically, you can do so under the Schedule section.