Question

Multi-Product Google Form Submissions to Google Sheets

  • 29 February 2024
  • 1 reply
  • 14 views

Hello,

I'm encountering a challenge with automating the addition of product data from Google Form submissions to a Google Sheet. Context: My form allows respondents to submit details for multiple products within a single submission. These products (clothing) are will be added to Shopify later. Each product includes several attributes (e.g., Title, Category, Type, Description, etc), and the number of products per submission can vary.

Adding the first product is not the problem, as shown in the screenshot below. 

This is how the end results ideally looks like: 

I am trying to use Looping by zapier to loop the 2nd, 3rd, 4th, etc etc, but I just can’t get it to work. Perhaps this is too complex to do in zapier, i dont know. I just don’t know how to do it...This is my setup (only using title and description for now to test): 

 

For each Product submission in google forms, every single product data has a unique identifier. 

 

 

Thanks in advance!


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +14

Hi @steijnd 

Values from the Looping step should be mapped to the GSheet step.