Shopify to Google Sheets API - Product Availability Information

1 0 0

Hi there Guys,


I'm needing some help with my Shopify to Google Sheets integration. 


I am trying to export my products being sold on Shopify with an API to a Google Sheet. The information i am needing to get from the API is a stock available number with a SKU of the item.


I've managed to integrate the API but its not giving me the SKU data of each product but rather the Inventory Item ID.


The Request URL i've been using is from 


Help would be greatly appricated.

Reply 1 (1)

Shopify Partner
152 4 19

Hi @gpcarlone 


If you are okay using an app to do this, please use the Product & Inventory Export sheet on the Sheet Master app on the Shopify App Store


Please email me at if you need help getting set up. Here's a video on how it works:



Automating Commerce at Comstack