Updating Graph in Docs Connected to Sheets before Generating PDF report

[Brian Fraser]

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

 

[Pabblymember11]

Hey @Brian Fraser

Could you please share the name of the workflow and what is the current output you are getting by creating the PDF?

 

[Brian Fraser]

Thank you for your reply. The name of the workflow is 'Test 2' located in the '_Sandbox' fold in my account.

Here are two report outputs (note that the graph should change):
1) https://drive.google.com/file/d/1NGmvqPT6aNs765OFl823PQnwo-QAoi9w/view?usp=sharing
2) https://drive.google.com/file/d/1YGIAv1Tj2satE5zWLatEBwNaAYPWXct9/view?usp=sharing

Attached is the Sheets data used to create the graph.

 

[Pabblymember11]

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.