Who can use this feature?
With Infogram, you can create dynamic charts and maps that update live and in real-time. Connect to a Google Drive document, use a JSON feed, or source your data from an online database. Any changes you make in your external data source will appear in your project (including all embeds of the project).
Connecting to your Google Drive account
- After you've added a chart or a map to your project, double-click on it to access the datasheet.
- Select Add Google Drive document at the top of the datasheet.
- When doing this for the first time, you'll have to connect your Google Drive account to Infogram.
Pro tip: You can remove Google Drive and Infogram integration via the Google account settings. When you do, existing live-updating charts will lose their connection.
- Choose the Google Drive document you want to use for your data visualization, then click Select.
- When you edit the information in your Google sheet, it will automatically update your Infogram chart or map. These changes will automatically apply to your embeds and shared URL link.
Note: When changing the order of tabs in a Google sheet, the tabs will not automatically shift in your Infogram project. Each data tab of your Infogram project draws information from the numerically corresponding tab in the Google sheet; therefore, you have to rename the tabs in your Infogram chart manually.
Connecting to a JSON feed
- After you've added a chart or a map to your project, double-click on it to access the datasheet.
- Select Add JSON feed at the top of the datasheet.
- Use this example to see how your JSON feed should be formatted. To create a multi-tab chart or map, use the following example.
- Now, when you edit the information in your JSON feed, it will automatically update your Infogram chart or map. The data are refreshed approx. every 10 minutes.
These changes will automatically apply to your embeds and shared URL links.
Connecting to an online database
- After you've added a chart or a map to your project, double-click on it to access the datasheet.
- Click the database icon at the top of the datasheet.
- In the dropdown menu, pick the database you want to connect to. Select between MySQL, PostgreSQL, Amazon Redshift, Oracle, and Microsoft SQL Server databases.
- Fill out the form:
- Click Update for the information to load.
Now, your chart or map will be updated every time you open the project in 1) the editor 2) the webview 3) or your website where it is embedded. A request for data will be sent to Infogram, then to your database, which will provide the new data.