Guest Posted September 23, 2020 Posted September 23, 2020 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
paul2009 Posted September 23, 2020 Posted September 23, 2020 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 ↘️ Me: I'm Paul, a SQSP user for >18 yrs & Circle Leader since 2017. I value honesty, transparency, diversity and good design ♥. Work: Founder of SF.DIGITAL. We provide high quality original extensions to supercharge your Squarespace website. Content: Views and opinions are my own. Links in my posts may refer to my own SF.DIGITAL products or may be affiliate links. Forum advice is completely free. You can thank me by selecting a feedback emoji. Buying a coffee is generous but optional.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.