Jump to content

Update inventory with Google Sheets

Recommended Posts

Site URL: https://www.enfiletonmasque.com

Hi everyone,

I am wondering how to connect a Google Sheet to Squarespace Inventory.

The goal is that Sheets gets updated each time someone purchases an item. And Squarespace product inventory gets updated each time I change the value in the Google Sheet (when I sell products through a physical store).


Lets say I have products with two size (M and S). I would like to create a Sheet, looking as follow.

product name M S
Raph 50 12
Rosie 2 37
Titi 26 16
Travis 6  
Le Président 24 32



STEP 2 is to connect a Sheet, where all customer information regarding the delivery (name, surname, order, address) is summarized.

So that I can automate the shipment and let it done by a third party company.


PS: I have the Advanced Commerce plan, so I imagined doing this with an API key.

Any help appreciated.


Thanks everyone,



Link to comment
  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

With the Advanced Commerce Plan, Squarespace allows you to read and write stock levels for your physical inventory using the Products API, so in theory it should be possible to use a Robotic Process Automation (RPA) tool like Parabola or Make (formally Integromat) to do this.

   If a post helps you, please click a "Like" option below  ↘️

Edited by paul2009
Integromat became Make

About: Squarespace Circle Leader since 2017. I value honesty, transparency, diversity and great design ♥.
Work: Squarespace Developer and founder of SF Digital, building the features Squarespace didn't include™. 
Content: Links in my posts may refer to SF Digital products or may be affiliate links.

Catch up on all the release notes and announcements 2023 [for Circle members only]. There's a public version here too!
If I helped, you can thank me by clicking one of the emojis below. If you prefer, you can buy me a coffee.
Improve your online store with our extensions.

Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

  • Create New...

Squarespace Webinars

Free online sessions where you’ll learn the basics and refine your Squarespace skills.

Hire a Designer

Stand out online with the help of an experienced designer or developer.