Insert Data from Google Sheets in Elementor Charts Widget

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.

Click here to check Premium Chart Widget Tutorial and Premium Chart Widget demo.

Requirements:

  • 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.

Premium Charts Widget for Elementor
Elementor Charts Widget

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.

Getting Google Sheets Link to Add It to Elementor Charts Widget
Getting Google Sheets Link to Add It to Elementor 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 [4].

Now, your Google sheet data is connected to Elementor Chart widget.

Integrate Google Sheet with Elementor Charts Widget
Integrate Google Sheet with Elementor Charts Widget

If you still need any further assistance, feel free to contact Premium Addons support team from here. We would be more than glad to help 😁

Related Docs:

Download Now it's free!

Extend your Elementor Page Builder capabilities now with Premium Addons. 25+ Elementor Widgets Totally Free of charge.

Stay Updated

Subscribe to our newsletter to receive the latest updates and features.