Jump to content

Checkout / Product form location + Google drive

Go to solution Solved by paul2009,

Recommended Posts

Hello,

I have products set up in my store which have forms attached.

Ordinarily, when you set up a form there's the tab to change the email that it's linked too and to link google drive to create a document which holds the data.

I can't see a way to do this for the product forms. Can anyone point me in the right direction?

Thank you.

Link to comment
  • Replies 7
  • Created
  • Last Reply

Top Posters In This Topic

  • Solution

Custom Product Forms are used to collect information relating to a particular product, such as personalisation details. This information is submitted with the order in the email to the merchant, and is included in the order confirmation email to the customer. Custom Product Forms do not include an option to submit the form data to Google Drive as you can with Form Blocks. 

I provided a more detailed response below:

 

Edited by paul2009
Link to more detailed answer

About: SQSP User for 17 yrs. Circle Leader since 2017. I value honesty, transparency, diversity and good design ♥.
Work: Founder of SF Digital, building Squarespace Extensions to supercharge your commerce website. 
Content: Links in my posts may refer to SF Digital products or may be affiliate links.
If my advice helped, you can thank me by clicking one of the feedback emojis below. I love coffee too.

Link to comment
  • 3 months later...

 

On 7/21/2020 at 3:35 AM, paul2009 said:

Custom Product Forms are used to collect information relating to a particular product, such as personalisation details. This information is submitted with the order when the order is submitted; it cannot be sent via email or Google Drive. 

Can you explain what information you are collecting, and why you want to submit it via email or Google Drive? For example, is the form being used to collect a product enquiry from a potential customer? If yes, you may find our Product Enquiry Form extension helpful.

Hi @paul2009 I have been wondering the same thing. In the case of a clinic (service product) it would be SO HELPFUL and time saving for my client if I could get it to collect in a google sheet. 

Link to comment
  • 4 months later...

@paul2009 I also require this feature desperately. 

The product form collects information about my service and I need that information in a spreadsheet so that I can deliver the service to my customers.

As it is now I need to do a multiple click process to export new orders each day and then manually ADD them to a spreadsheet.

The standard forms work perfectly going into a google sheet, I don't understand why the product form doesn't have the same functionality.

It would also be great to be able to set up Zapers based on the information that customers provide to streamline service delivery.

Link to comment
4 minutes ago, rebaccasanders said:

The product form collects information about my service and I need that information in a spreadsheet so that I can deliver the service to my customers.

You can use the Orders API to retrieve all order details or specific order details, and automatically pull them into another tool such as a Google Sheet.

Better still, instead of making repeated API calls, you could subscribe to webhook notifications using the newer Webhook Subscriptions API.

About: SQSP User for 17 yrs. Circle Leader since 2017. I value honesty, transparency, diversity and good design ♥.
Work: Founder of SF Digital, building Squarespace Extensions to supercharge your commerce website. 
Content: Links in my posts may refer to SF Digital products or may be affiliate links.
If my advice helped, you can thank me by clicking one of the feedback emojis below. I love coffee too.

Link to comment
  • 2 months later...

@paul2009,

Curious here since Squarespace customer service just advised that no currently offered API's can pull the product form details into a Google Sheet.

Can you provide any more specific detail on how this might be achieved? I was looking into Automate.io as the juncture between SS API's and Google Sheets.

For example:

Consumer selects Add to Cart and is presented with a form:

Flavor 1: Dropdown
Flavor 2: Dropdown
Flavor 3: Dropdown
Flavor 4: Dropdown
Notes: Text box response

Ultimately it would improve our business processes to be able to see a full list of orders on any particular day with answers by the column so I can full totals and produce a specific number of each respective flavor.

Any ideas on this?

Thank you!

Will

Edited by dubwebdev
Link to comment
On 6/3/2021 at 4:45 AM, dubwebdev said:

Curious here since Squarespace customer service just advised that no currently offered API's can pull the product form details into a Google Sheet.

Hey Will

I imagine there has been a misunderstanding between what is possible and what is included.

To be clear, Squarespace does offer an API (the Orders API) that can pull information from orders where a Custom Product Form has been used. Here's an example of the relevant section of JSON, where the customer has selected "Middle Chest" for the form field "Shirt Emblem Location":

    // Array of form data submitted via a product's custom form
    // prior to being added to the cart.
    "customizations": [ {
      "label": "Shirt Emblem Location",
      "value": "Middle Chest"
    } ],

However, the API is designed to be used by Developers ("Software Engineers") to build custom functionality. There's not a built-in feature to pull this information into a Google Sheet - it would need to be custom written or be achieved by using a Robotic Process Automation (RPA) tool like Parabola or Make (formally Integromat).  

I hope this helps to clarify.

Paul

 

Edited by paul2009
Integromat became Make

About: SQSP User for 17 yrs. Circle Leader since 2017. I value honesty, transparency, diversity and good design ♥.
Work: Founder of SF Digital, building Squarespace Extensions to supercharge your commerce website. 
Content: Links in my posts may refer to SF Digital products or may be affiliate links.
If my advice helped, you can thank me by clicking one of the feedback emojis below. I love coffee too.

Link to comment
  • paul2009 featured and unfeatured this topic
  • 6 months later...

Hi @paul2009.

I'm attempting to use Make to automate populating a google sheet with squarespace purchase information, including a custom form required to complete the purchase.

The "customizations": field in Make is only picking up the last of three fields in the related custom form (see attached). Is this expected behavior? 2102410668_Screenshot2023-02-06at5_51_33PM.png.b899bcadd9c1414eda19c769c5206993.png

1148643091_Screenshot2023-02-06at5_53_13PM.thumb.png.69fb3cbd56810303679aba48cc3018f6.png

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.