@Liz @AlejandroGR -i’ve been trying to work with the Document Studio and the Google Sheets/Slides teams to make the radar charts work - it was one of the first things i askd in the ocmmunity/support forum foing back 3 years ago.. no love lol..
it is possible to link a chart in a google slide/doc to a sheet and update it when the underlying data changes, the hard part that i am trying to work out with folks is to have the ‘data refresh’ be limited to the last row added - that is the data that is merged into the Slide/doc in other areas as well. getting the trigger to refresh when the document studio workflow runs is the key part and that is what i am missing at this point.. still a work in progress at this end.
one thing i have NOT checked out yet is the zapier ability outlined here that refreshes charts in a google slide … this might work on the trigger to update the slide BEFORE the Document Studio workflow - or simply replace it?? - but i have not had the time to test this out yet.. am hoping for some time over the holidays to get it working. i think the issue for me on this is what happens if 4 records are added quickly i the data … will the zap update for first record and wait till the workflow complets before update the slide for the second… etc..
Report gprilla will do it but cost wise not feasible if you are going to have a lot of folks do it and not charge for it..
des
