Insert graphs obtained in a form in a google document

10 views
Skip to first unread message

Francisco Moreno

unread,
Nov 29, 2022, 1:17:32 PM11/29/22
to Google Apps Script Community
Hello,
Do you know if it is possible insert the graphs displayed by a form in the "Answers" tab in a google document, automating the task with Apps Script?
Thanks.

cwl...@gmail.com

unread,
Dec 1, 2022, 7:29:47 AM12/1/22
to Google Apps Script Community
Not specifically with Apps script. It doesn't look like those charts are part of the FormsApp. However, you might be able to replicate the Pie charts simply by linking the form to a Sheet, and charting the responses in another tab in the spreadsheet.
Then for each answer, copy the chart, and paste into the Doc making sure you select "Link to Spreadsheet" so the chart updates as responses come in.


Reply all
Reply to author
Forward
0 new messages