Custom product form export to Google Sheets

Site URL: https://www.megunticookrowing.org/

I see that I am not the only one with this request.  To have a storage destination [Google Sheets, for example] for custom product forms.  I offer a service that requires a form be completed prior to checkout.  I do receive an email with the form data, once the product has been checked out and paid.  However, I am not able to export the data to a sheet, the data being critical to the service and operations.

I can not even get an integration app such as Zapier and Parabola to access this data and export it in real time.  Should be a simple fix for Squarespace?  Others are asking for this too?  I have been using Squarespace for almost 4 years and this is a real shortcoming.  Please advise and thank you!

,

Jo-Ann Cook

On 7/8/2022 at 10:45 PM, joanncook said:

I see that I am not the only one with this request - to have a storage destination [Google Sheets, for example] for custom product forms.

Please see my 2021 post. To summarise, you can collect the Custom Product Form data using the Orders API and then push this to a Google Sheet (or other location), but you'll probably want the assistance of a developer (or someone familiar with these tools) as you will need custom code or a Robotic Process Automation (RPA) tool like Parabola or Make (formally Integromat).