Shopify Connect - API Integration with Google sheets

Magic Sheets
0 ratings

What does it do?

Stock management of your Shopify store from Google sheets

How does it work?

1. This product is connected by API with Shopify, so the first thing is to complete the necessary info to set up YOUR store.

  • Go to API tab
  • Complete API key and password
  • Complete the shop name

2. Click on the custom menu >>> "Inventory Tools"

  • Pull Current Product list from Shopify
  • Pull Current Inventory levels from Shopify
  • Pull Current Location List from Shopify

3. Upload new stock to Shopify

Go to "UPDATE_INVENTORY" tab >>> Link

  • Select the product
  • Select the product
  • Complete with the right stock
  • Update all the inventories by clicking on Inventory Tools >>> Upload stock to Shopify

Why should I use it?

  • Increase your efficiency 10x by upgrading more than 500 products in one click
  • Integrate Shopify into all your spreadsheets, you can use Sheets2Sheets to bring your current inventory into the spreadsheet and upload it from there.
  • Avoid human error
  • Automate your processes

Who made it?

Milton Slonim is a Google Sheets developer with a degree in Business Administration and many years of experience working with agencies.

What's included?

A copy of the template is ready to use it.

Main features:

✔️Pulling all your product and location data from Shopify to Google sheets

✔️Update all your SKU's via API in Shopify in just 1 click


Updating stock is one of the most complex and manual processes for all companies.

I recommend that you buy the spreadsheet and update your stock from there. There are no monthly or hidden costs.

If you are interested in taking a step further and fully automate your stock system you can email me at to chat about it.

I want this!

Shopify Connect - API Integration with Google sheets

0 ratings
I want this!