jameslittlewood Posted July 20, 2020 Share Posted July 20, 2020 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
Solution paul2009 Posted July 21, 2020 Solution Share Posted July 21, 2020 (edited) 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 July 9, 2022 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
jaisequoia Posted October 26, 2020 Share Posted October 26, 2020 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
rebaccasanders Posted March 6, 2021 Share Posted March 6, 2021 @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
paul2009 Posted March 6, 2021 Share Posted March 6, 2021 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
dubwebdev Posted June 3, 2021 Share Posted June 3, 2021 (edited) @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 June 3, 2021 by dubwebdev Link to comment
paul2009 Posted June 3, 2021 Share Posted June 3, 2021 (edited) 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 September 10, 2022 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
LizzyLou817 Posted February 6 Share Posted February 6 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? Link to comment
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment