Rewatch the workshop: Learn how to automatically turn quiz responses into personalised reports đȘ
Hey folks, Â
Yesterday I ran a live workshop showing how to auto-generate and send PDF reports from typeform responses. We looked at how to use Typeform, Google Sheets/Docs/Slides, and Document Studio to automate PDF report creation and email distribution â without coding!
Thanks to everyone who turned up on the day and joined in, it was good fun! I'm posting the recording of the workshop here so you can rewatch it (or watch for the first time if you didn't make it live!)
Â
Â
Here's a breakdown of what you'll find in the session:
400:01] Intro and welcome from Liz
401:44] A bit about me
403:29] What we'll cover â scope of the workshop
406:58] Examples of PDF reports you can create
409:06] Intro to the tools you'll need
410:02] Overview of the process
410:52] Certificate example walkthrough (simple complexity)
426:05] Data quality assessment example walkthrough (medium complexity)
Thanks again, and hopefully see you again soon for more Typeform enlightenment! Â
des
Â
Page 1 / 1
Having had a sneak peek into what tricks @john.desborough has up his sleeve for this, I can whole heartedly recommend this one. Great for anyone who wants to save time and impress their clients/potential clients!
Â
So excited :)
Â
Â
Iâm gutted to have found Typeform after the date of this workshop. I could do with learning all this right off the bat - any chance you recorded it or are running another one?
Assessment reports: create custom assessments and automatically send them to your audience
Iâm gutted to have found Typeform after the date of this workshop. I could do with learning all this right off the bat - any chance you recorded it or are running another one?
Assessment reports: create custom assessments and automatically send them to your audience
Itâs coming up in 10 days. You didnât miss anything!
Thank you very much for doing this @john.desboroughÂ
Â
I have been desperately seeking a way to send personalized reports based on quiz outcomes to my customers. I spoke with the people at ReportGorilla, an integration option for Typeform but they quoted me nearly $10k for the first year.
OMG - I just lost a month! I was already in October in my head! Yey! Iâll get signed up!!
Will this webinar help with creating a team report? (collective responses - not just individual)
Will this webinar help with creating a team report? (collective responses - not just individual)
@pdxchickgirl - can you give a little more context on what you mean by âcollective responsesâ for a team report? just want that info before i can yes or no about the inclusion in the workshop
Â
des
I am creating an assessment for each member of a team to take and have an anonymous report that shows an average, mean, or range (low to high) - depending on the question - Â of the team membersâ responses pooled together. I can then have a team profile with strengths and gaps.
@pdxchickgirl - It isnât explicitly a use case that i will cover in detail, but one of the samples I was going to show includes describing how to pull data from sheets (not just a tab in same sheet) into the âreport rowâ of data if you need.Â
that will be more work on the google sheets end than in the typeform - i use a similar method for a maturity assessment where i have the user input an industry selection along with their responses. The google sheet (ecosystem) has a sheet/tab that captures the âindustry relatedâ data inputs from the user, calculates the revised industry totals/averages/means etc and the updated averages are pulled into the report that goes back to the userâŠÂ say they were user 15 in the industry, the values returned would be based on 15 responses for that individual versus the 14 that the previous industry participant would have received.Â
building that out in google sheets was much more effort than what i intend to show in the session BUT it is possibleâŠÂ
to get the composite âteam profileâ ie one report that shows âsummary report dataâ for all team members, that would probably have to be run outside of the process that I am going to present - more based on each transaction coming in than a summary - BUT you could follow the same principles to generate if you wanted to.Â
Â
hope that is not too vague an answer for you.. but itâs all i have from 36,000 feet over the Atlantic at the moment.. lol
Â
des
Thanks for your reply, John! Iâm wondering if I should have chosen a different platform for team responses (any recommendations? Is that ok to ask here?), but Iâm also interested in what you are presenting, too, because it would be nice to have a personal report as well from this process. Safe travels!
Hello John!
Will it be recorded so I can watch it and implement your process?
Your workshop will happen during my own workshop in another communityâŠÂ
Thank you so much for doing this. THIS is the subject I have been researching for months and really need the help.
Guillaume
Hey @Guillaume Wiatr yep donât worry weâll capture @john.desborough in action (hopefully Iâll remember to press record :P) and share the workshop on the Community afterwards. If you sign up to it weâll send you an email afterwards with a link to the recording.
Hope you find it helpful, and good luck with your workshop Â
Thanks so much @john.desborough .  I have a client meeting that is a must attend, and am very grateful you will be recording.
Thanks a mil for this @john.desborough - bravo for such a well presented and useful guide. You definitely brought the magic (very disappointed that your interpretive dance didnât actually come out in the recording though )
Thanks to everyone who came and made it such a nice atmosphere. Echoing what des said in his wrapup, we LOVE it when you folks share the cool stuff youâve been doing and would be happy to shine the spotlight on you in Community events like these in the future. Feel free to ping myself or @Liz if you have something to share and we can make it happen!
@Guillaume Wiatr @pdxchickgirl @Cameron Cogs @kelsie pinging you here in case you couldnât make it yesterday
This was a lot of fun, @john.desborough ! Thank you so much for sharing your knowledge and interpretive dances!
Â
doing my best to pay it forwardâŠ.. @James @Liz thank you for hosting it..Â
Â
if anyone got/gets some value out of session, do me a favour and pay it forward by paying for someoneâs coffee the next time you are having a brewâŠÂ a first responder, a teacher, a nurse, anyone who makes our communities safer for everyone.Â
thanks
Â
des
Hey @john.desborough, I just finished watching your workshop. I just wanted to thank you for sharing with us what we can do with Document Studio. It seems very user-friendly, and I canât wait to show it to my team. Keep up the great work! This was amazing. I will look out for future workshops from you. Ps I will definitely pay it forward tomorrow when I get my daily coffee Â
Hey @john.desborough, I just finished watching your workshop. I just wanted to thank you for sharing with us what we can do with Document Studio. It seems very user-friendly, and I canât wait to show it to my team. Keep up the great work! This was amazing. I will look out for future workshops from you. Ps I will definitely pay it forward tomorrow when I get my daily coffee Â
@Jsanchez204Â - thanks for the props.. itâs my way of avoiding writing code lol.Â
and as @Liz will say - pix or it didnât happen (ie paying it forward selfie lol)Â
thanks again
Â
des
@James you better get that video of the interpretive dance! It has to be saved in zoom somewhere!Â
lol.. thanks @Gabolino .. nice to see you again .Â
Is this possible to do on the free version or only on one of the paid versions of Typeform?
Hey @kylaray yes, itâs possible to connect your typeform to Google Sheets using the free plan. You can then go ahead and use Document Studio with GSheets to create and send the reports as des explains in the guide. Again, thereâs no charge for doing this.