Elementor Charts Widget allows you to easily pull data from your Google Spreadsheets and show it in a dynamic chart with few simple steps. Once you’ve updated your Google sheets, the charts will be updated automatically.
- You will need Premium Addons PRO plugin installed and activated on your website.
- Also, make sure that this widget/addon is enabled so you can find it in the Elementor editor. Check this article to know how to do that.
- Premium Addons works only with Elementor Page Builder plugin so you will need to have it installed and activated as well.
Premium Charts Widget For Elementor Page Builder
Drag and drop Elementor Chart widget to your page.
Google Sheet [Part1]
To add Google Sheets into Elementor Charts Widget.
1- First, Go to your Google Sheet file, from the toolbar click on File.
2- Click on [Publish to the web].
3- Select Comma-Separated Values (.csv).
4- Click on Publish button and copy the generated link.
5- From Published content & settings, enable automatically republish when changes are made (Recommended) so that any changes made to the sheet will be published directly to your charts widget.
Elementor Charts Widget [Part2]
And now we will move to the next step, you have to configure Elementor charts Widget to display your Google Sheet on your webpage.
Navigate to Premium Charts Widget -> Content
6- Set Data Type to [CSV File] option.
7- Set File Type to [Remote File] option.
8- Data Separator: Use a separator to separate between the data cells. You can write comma [,].
9- File URL: Paste Google Sheet file URL. Refer back to step .
Now, your Google sheet data is connected to Elementor Chart widget.
If you still need any further assistance, feel free to contact Premium Addons support team. We would be more than glad to help 😁