How to Auto-Update Linked Objects on Google Docs?
Jean-Baptiste JACOB
Context
I’m having marketing weekly reports be automatically created following this workflow:
Airtable → Make → Google Sheets → Google Docs
I chose to have part of the data go through Google Sheets in order to get cell color-coding depending on their value with Google Sheets’ conditional formatting.
The Google Doc features linked objects – a table and charts – that come from Google Sheets.
Need
As of today, I have to manually click the ‘Update All’ button on Google Docs to refresh the data in the linked objects. But since the reports will be created on a weekly basis, I’d like to find a way to automate this. The thing is, there’s no auto-refresh feature on Google Docs. And from what I found online, it’s not possible yet to automate it with the Google Docs API (see this thread on Stack Overflow and this post on Google’s IssueTracker).
But is it possible to automate it with Google Apps Script?
Keith Andersen
What ever function you have in Google Sheets to send data to Docs - simply attach a timer trigger to it. Have it fire the function on the Day/time of your choosing.
My website: https://sites.google.com/view/klaweb/
Passions: God, Family, Scriptures, Learning, Data Management, Google Sheets + App Script and much more!
--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/3c6f89c4-3ddf-4a64-836c-eec6634268den%40googlegroups.com.
Jean-Baptiste JACOB
Keith Andersen
https://youtu.be/MiWfaCNRzsA?si=flJPnsejQwddnpH9
My website: https://sites.google.com/view/klaweb/
Passions: God, Family, Scriptures, Learning, Data Management, Google Sheets + App Script and much more!
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/bde677d8-c655-4968-8b69-a7e9bfd3990dn%40googlegroups.com.
Jean-Baptiste JACOB
You received this message because you are subscribed to a topic in the Google Groups "Google Apps Script Community" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-apps-script-community/O9Jy1CmBa_A/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAFKgK%2BF8PUkfp5mf2vcY5tT57VYYkPGEhz1NNvxddx7iBqxPJQ%40mail.gmail.com.