Hey there, it's Baptiste from Agent Studio! I want to share my journey of solving a common problem with you: creating beautiful charts from Typeform responses.
I had a client who needed spider charts within a report for their automation project. I tried different options like Google Sheets, Looker, and Docmaker, but none of them quite met the aesthetic standards we were aiming for. That's when I stumbled upon Quickchart.io, and it turned out to be the missing piece of the puzzle.
Here's the breakdown: I used Typeform to collect responses, Google Sheets for data management, and Quickchart.io for the chart creation.
To achieve the desired look, I created a background image using Figma and a Google Docs template to display the final result. By replacing variables and aligning the graph with the background image via Make, I was able to create visually stunning reports.
You can test how it works for yourself by filling in this dummy version of the typeform:
If you're curious about the entire workflow head over to the full tutorial post here on the Typeform Developer blog.
I explain there:
- How to create the typeform
- Calculating average scores for each assessment using Google Sheets
- Generating the graph with Quickchart.io
- Automatically inserting the graph into a Google Docs template via Make
- Sending the generated report automatically via email to the respondent
I hope you find this useful, I'd love to get your thoughts on this approach. What other use cases can you think of for this? Have you tried auto-generating graphs from Typeform responses and how does your method compare?
Thanks!
