Did you know that you can now insert Google Sheets Charts to Google Docs and Google Slides that update when the automation is run in just a few simple steps? Take a look! 😀
In this article you will learn how to:
1. Add Google Sheets Charts to Google Docs and Google Slides
2. How Google Sheets Charts in Google Docs and Google Slides work during an automation
In this article, we will jump straight to adding a Google Sheets chart to a Google Docs and a Google Slides template. However, if this is your first time creating a workflow, please refer to this article to learn more.
The first step is to copy the chart from your Google Sheets Source:
Next, insert it into your template document by selecting the "Link to spreadsheet" option:
Note | If you select the 'Paste unlinked' option, your chart will be inserted into your template as a static snapshot, preventing updates from being reflected within it.
Now, your template will look like this:
Note | If you're using Google Slides as your template, the steps are identical to those in Google Docs. Select "Link to spreadsheet" from the options:
And then your template will look like this:
When an automation is run Portant will make sure all the charts are updated so they contain the most recent data. It’s a bit like clicking this update button before running an automation (apart from Portant does it automatically):
Then your outputs will contain the most recent and up to date charts.
We created Portant in 2021 and the feedback we have received since then has been very helpful and greatly appreciated. If you have any feedback please feel free to send us an email at email@example.com or use our contact form here: https://www.portant.co/support
Blake and James
You can do a lot more than just mail merge with Portant. Portant is a fully-fledged online document automation solution that can optimise many different document flows. You can use our online document automation platform to optimise your repetitive work, so you can get back to doing the work you enjoy.Get started
Transform your work life with responsive, fully customizable, and easy-to-use templates.
Select a Google Doc agreement template, add an eSignature placeholder and put your contract signing on auto-pilot.
Select a Google Sheet of invoice data, add a Google Docs invoice template, and generate 10, 100 or even 1000's of invoices at a time.
Select a Google Form, add tags to a Google Doc template, and generate Docs every time your receive a Google Form response.
Every time a Google Form is submitted an incident report PDF is automatically generated and shared via email.
Select a Google Form, add tags to a Google Doc or Slides template, and generate PDFs from responses.