Results in PDF: How to create a chart in Google slide from Google Spreadsheets | Community
Skip to main content
Answered

Results in PDF: How to create a chart in Google slide from Google Spreadsheets


Forum|alt.badge.img

I want to automatically send an email with attached PDF showing the individual results of the recipient. I got to the point of connecting Google spreadsheets to Google slides, using Document studio. Ultimately, google slides will be converted to PDF and then send to the recipient. 

Now, how do I automatically create a bar/chart in Slides, using the data in spreadsheets? E.g., I have several questions answered by a 1-10 score. In stead of showing the answer as a number, how is it shown as a chart? It has to be on individual level.

 

Thank you!

Best answer by john.desborough

@Rosemary - here’s a short video that shows how it was done .. there are a few things that i included for folks who have not managed to use Document Studio before but hopefully you can see how this is done..

full transparency: this ‘spoofs’ a bar chart (creating a ‘canned’ image that is fed data based on a filter for the current row only that dynamically updates the chart embedded in a Google Slide IS possible, but is a complicated little beast.. this is an easier approach) 

 

View original

10 replies

Liz
Community Team
Forum|alt.badge.img+5
  • Tech Community Advocate
  • 14903 replies
  • October 21, 2021

Hi @Rosemary Lovely name! :) Welcome to the community! I believe @john.desborough has more experience setting this up than I do and may be able to offer you some pointers. :) 


Forum|alt.badge.img
  • Author
  • Explorer
  • 5 replies
  • October 25, 2021

Thank you, I would love to hear @john.desborough 's experience and tips if he has some! :)


john.desborough
Forum|alt.badge.img+6
  • Certified Partner & Champion
  • 5270 replies
  • October 25, 2021

@Liz @Rosemary  - funny you should ask this at the moment. I am working on this solution for a client. I will post one possible approach to solving this later this evening after i finish off some client work and end of day parental responsibilities.. 

 

des


Forum|alt.badge.img
  • Author
  • Explorer
  • 5 replies
  • October 27, 2021

@john.desborough what a nice coincidence :). I am very much looking forward to reading the possible solution. Thanks in advance!


Liz
Community Team
Forum|alt.badge.img+5
  • Tech Community Advocate
  • 14903 replies
  • October 27, 2021

Thanks in advance, @john.desborough !


john.desborough
Forum|alt.badge.img+6
  • Certified Partner & Champion
  • 5270 replies
  • October 27, 2021

@Rosemary @Liz -- sometimes life and the need for another coffee get in the way. 

here is a simple example of how you can make it work… have a peek while i do some other client work and drink another/the inevitable coffee lol.. 

oh.. you will have to enter a valid email address to see the example. 

cheers

 

des


Forum|alt.badge.img
  • Author
  • Explorer
  • 5 replies
  • October 27, 2021

@john.desborough This is exactly what I had in mind 🙂. Maybe I am missing something, but my question is, how do I create this myself? I have made the Typeform, and connected it to Google spreadsheets and then to Google slides, using Document studio. I don't know how to get the graph? Oh, and enjoy the coffee :)  


john.desborough
Forum|alt.badge.img+6
  • Certified Partner & Champion
  • 5270 replies
  • Answer
  • October 27, 2021

@Rosemary - here’s a short video that shows how it was done .. there are a few things that i included for folks who have not managed to use Document Studio before but hopefully you can see how this is done..

full transparency: this ‘spoofs’ a bar chart (creating a ‘canned’ image that is fed data based on a filter for the current row only that dynamically updates the chart embedded in a Google Slide IS possible, but is a complicated little beast.. this is an easier approach) 

 


Forum|alt.badge.img
  • Author
  • Explorer
  • 5 replies
  • October 27, 2021

@john.desborough Thank you very much, you absolutely rocked my day! :) 


Liz
Community Team
Forum|alt.badge.img+5
  • Tech Community Advocate
  • 14903 replies
  • October 28, 2021

Thank you, @john.desborough !! Glad this helped, @Rosemary ! :sunglasses: