Checkout / Product form location + Google drive

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.

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. 

@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.

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.

@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

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

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?