Hi,
I have many users (>100) to whom I deliver products weekly. I would like to automatically generate a short Typeform feedback form per user. The core issue is that I cannot use only one form, but I rather have to customize it, since each user receives different products.
Since I already have the data per user in a g-sheet (i.e., which products the user received each week), my idea was to use one Typeform template and import the varying part of the form from the g-sheet. Is it possible to:
1. Import data from g-sheets into Typeform? (I know the other way around is possible)
2. Automatically create new Typeform feedback forms every week after I’ve updated the g-sheet?
I have read through the Google Sheets integration documentation and haven’t been able to figure out whether the above-mentioned functionality is available. Any help would be appreciated.
Thanks :)
Creating TypeForms from Google Sheets
Best answer by john.desborough
Jakob - as Mariana indicated, we can’t generate things on the fly out of the Google Sheets world yet.
One of the things that you could do, from your Google Sheet is to use something like the Document Studio add-on to create custom emails and send them out on a scheduled basis, using the fields from the sheet to create the feedback site url, complete with hidden fields being passed into the form.
I created a short example/demo typeform at this link, that is ready to accept information being passed as follows (click through the link below to see this work with the products being passed):
i have created the structure to combine three elements (products) purchased into the url and matched it up against the typeform which i created with 3 question groups, one for each product. (i specifically did this as a quick test). You would could create your email something like the one in the image below which has a clickable image and the text link to the feedback form shown:
If the number of products that you want reviewed by your clients varies from, say, 1-10, what i would do to extend the form above is to create 10 question groups (the max), create a ‘count’ variable in the google sheet to provide the number of products that are being appended to the url (use a bunch of if() statements in your field that assembles the concatenated/combined url plus variables) and then pass that number as a hidden variable called prod_count (for example). I would use the prod_count variable to start a declining counter in each question group and at the end of the question group determine if the counter was =0 and if so send them to the end otherwise go to the next question group.
(there are a couple of posts in the community that i have made on that declining counter option you can search for - bad grammar and all.
hope this helps provide a bit of a workaround
des
+5Hi 
Thanks for sharing all these details - they are super useful! Although we don't have these features at the moment, I made sure to pass on your feedback to the relevant team. If you have any other suggestion or feedback, please feel free to share them here. We're all ears!
+6- Certified Partner & Champion
- 5257 replies
- Answer
Jakob - as Mariana indicated, we can’t generate things on the fly out of the Google Sheets world yet.
One of the things that you could do, from your Google Sheet is to use something like the Document Studio add-on to create custom emails and send them out on a scheduled basis, using the fields from the sheet to create the feedback site url, complete with hidden fields being passed into the form.
I created a short example/demo typeform at this link, that is ready to accept information being passed as follows (click through the link below to see this work with the products being passed):
i have created the structure to combine three elements (products) purchased into the url and matched it up against the typeform which i created with 3 question groups, one for each product. (i specifically did this as a quick test). You would could create your email something like the one in the image below which has a clickable image and the text link to the feedback form shown:
If the number of products that you want reviewed by your clients varies from, say, 1-10, what i would do to extend the form above is to create 10 question groups (the max), create a ‘count’ variable in the google sheet to provide the number of products that are being appended to the url (use a bunch of if() statements in your field that assembles the concatenated/combined url plus variables) and then pass that number as a hidden variable called prod_count (for example). I would use the prod_count variable to start a declining counter in each question group and at the end of the question group determine if the counter was =0 and if so send them to the end otherwise go to the next question group.
(there are a couple of posts in the community that i have made on that declining counter option you can search for - bad grammar and all.
hope this helps provide a bit of a workaround
des
+6- Certified Partner & Champion
- 5257 replies
thanks
des
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.