Jump to content
Search In
  • More options...
Find results that contain...
Find results in...
Advanced Search

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.

  inventory
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,

Dorian

 

Link to post
  • 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 Integromat to do this.

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

sf-digital-signature-logo-email145.png.46606a2288a2847f44d81b9b7b58f3a5.png
Hi, I'm Paul, founder of SF Digital, a specialist company helping Squarespace users by building the features that Squarespace didn't include.
Explore our range of Squarespace Extensions, including the Wishlist, and Datepicker Extension or book a Squarespace Expert for 1:1 help. Note that links in my posts may be affiliate links.

Link to post

Create an account or sign in to comment

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


×
×
  • Create New...