Jump to content

Product Form Storage Help

Recommended Posts

I sell lacrosse clinics on squarespace commerce.

However, all the information from the "product form" parents fill out upon checkout only gets sent to me in an email and then I have to manually transfer that info into a spreadsheet. (Parent/player name, contact info, school, local team, US Lacrosse number, jersey number requested etc.)

I would like that information to automatically populate in a spreadsheet in google drive as well as send me that same information in real time upon purchase.

Squarespace already has something very very similar in the pages as I can create a "form block" and it gives me the "storage" option to sync with my google drive and every time a parent emails me via the form block I get an email and also it real-time populates into a google doc spreadsheet. I would like this for all of my commerce products, but can't figure out how?!?!?

Squarespace in the past has said this isn't an option. I've reached out to them again and haven't heard back yet. Hopefully the community has an answer or an e-commerce alternate I can switch to as I don't enjoy transferring 100s of registrations by hand that take up 12+ hours of my time each week. I don't see a "storage" option with the product forms.

Thank you!

Link to comment
1 hour ago, azlaxacademy said:

I sell lacrosse clinics on squarespace commerce.

However, all the information from the "product form" parents fill out upon checkout only gets sent to me in an email and then I have to manually transfer that info into a spreadsheet. (Parent/player name, contact info, school, local team, US Lacrosse number, jersey number requested etc.)

I would like that information to automatically populate in a spreadsheet in google drive as well as send me that same information in real time upon purchase.

Squarespace already has something very very similar in the pages as I can create a "form block" and it gives me the "storage" option to sync with my google drive and every time a parent emails me via the form block I get an email and also it real-time populates into a google doc spreadsheet. I would like this for all of my commerce products, but can't figure out how?!?!?

Squarespace in the past has said this isn't an option. I've reached out to them again and haven't heard back yet. Hopefully the community has an answer or an e-commerce alternate I can switch to as I don't enjoy transferring 100s of registrations by hand that take up 12+ hours of my time each week. I don't see a "storage" option with the product forms.

Thank you!

I usually parse email content using Google apps script for other client project, but for your case I think taking a look at http://integromat.com/ will help, they have some template that can integrate ss order and google sheet or other services

BeyondSpace - Squarespace Website Developer

🖼️ Lightbox Studio (Enable Pinch/Zoom on lightbox)
🗓️ Delivery Date Picker (Squarespace Date format)
💫 Animated Buttons (Referral URL)
🥳 Sparkplugin Customisations Browsers (Browse +100 Spark plugin customisations)
🥳 Elfsight Template Browsers (Browse +1000 Elfsight widget Templates)

If you find my answer useful, let's leave a like or upvote so others with the same issue can find their solution. Thank you!

 

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.