For the management of a small farm, I have developed an order flow that feeds in a series of linked google sheets and allows to do accurate accounting, packing, cash flow, etc.
The orders are from a Wix website store, but they need to be inserted in one of the google sheets by hand.
I would like to develop a way that would automatically update the google sheet when a new order is submitted to the wix store. The input data to the google sheet are the customer name, the date, the product name, quantity and price.
I can code in Matlab and Python but I’ve never worked with APIs. So I am looking from advice on how to proceed tackling this problem.
Thanks Giri Zano, I had seen this, but I wonder how it could be made to automatically send data to google sheets whenever an order is submitted to the store?
@usumdelphini What you could do is use the new onNewOrder API https://www.wix.com/corvid/reference/wix-stores-backend/events/onneworder
and integrate it with the code from the excel-example. If that is too much for you, you could try the onNewOrder with Zapier: call the Zapier-hook onNewOrder, link a sheet to it and voila.
ALso look at Integromat, a Zapier on steroids: less components to i/o with, but more in-depth.
how we gonna add the product quantity column in automation to google sheet