Google Sheets Integration’s integration with Google Sheets automates the process of adding new data to a chart, by updating the data periodically and almost ‘automagically’. It is simple to set up, so you might want to use it on your reports and any other data output that needs to be updated continuously. This tutorial is based on a guest blog by Jacqueline Lafloufa, editor at Kantar Brazil.

Gather the data in a Google Sheet

The data in this example shows the level of water reserves for the city of São Paulo in Brazil. This data is being monitored and recorded on a daily basis and we will create a monthly report.

Create a chart on

To get started, just head to and create your chart with the colors, titles and the chart type you think will be a good fit for the information you want to display. Here we chose a line chart, since we are dealing with information that changes over time.

Double-click on the chart and you will see some dummy data. Notice the buttons at the top of the grey section – the second one, the triangular logo, let’s you sync your Google Drive. Click on it.

Connect your Google account

You’ll need to connect to your Google account to have access to your sheet. Just log in with your account and authorize access.

Select the sheet you need

Choose the sheet with the data you need from your Google Drive, and click “select”.

Configure the auto-update interval

automate_data_import can update the information on your chart at different time intervals. Just select the one that fits your needs best, pick the sheet you want to show or select all sheets if you want to show multiple information in the same chart (this will create radio buttons on your final chart) and click “done”.

Adjust the chart settings

adjust_chart_settingsAdd information explaining what the X and Y axis are with labels. You can also change colors, the chart’s height and the range on the axes.

You’re done!

Now you can publish your chart, if you want. Just click on the “Publish” button at the top right corner of your screen, fill out the fields with name and keywords and click “Publish for everyone”. If you prefer, you can also share the chart privately and even set a password to add a layer of security.

Share or embed your chart and never worry about changing it again – you can just add more information to the sheet connected to it and see the chart automatically update in the interval of time you selected when you created the chart.

Connect your data.

Schedule a call with one of our experts to learn about our advanced plans.