Updating Graph in Docs Connected to Sheets before Generating PDF report

Hello,

I have built the following workflow: [Trigger] Google Sheet with rows of unique data --> Data is passed to another Sheet updating rows to create a graph for each of the rows in the trigger Sheet --> Google Docs template is used to generate a report that includes the graph connected to the Sheet in step 2 --> Then PDFs are generated using the Docs files.

My issue is... All of the PDFs are generated in this workflow BUT the graph is not updating to reflect the new values. Is there a way to update the graph in the generated Google Doc before creating the PDF file?

Thank you,

Brian
 

Attachments

  • Screenshot 2022-09-13 6.23.08 AM.png
    Screenshot 2022-09-13 6.23.08 AM.png
    83.9 KB · Views: 17

Supreme

Well-known member
Staff member
Hey @Brian Fraser

To pass the percentage in the documents you should create the individual fields in your document first then pass the values dynamically like you are passing in the Google Sheets.

1663134805522.png
 
Top