{"id":119413,"date":"2023-05-25T18:23:05","date_gmt":"2023-05-25T12:53:05","guid":{"rendered":"https:\/\/etemplates.wdesignkit.com\/theplusaddons\/?post_type=documents&p=119413"},"modified":"2023-05-26T13:24:57","modified_gmt":"2023-05-26T07:54:57","slug":"import-data-from-google-sheets-in-elementor-table","status":"publish","type":"documents","link":"https:\/\/etemplates.wdesignkit.com\/theplusaddons\/docs\/import-data-from-google-sheets-in-elementor-table\/","title":{"rendered":"How to Import Data From Google Sheets in Elementor Table?"},"content":{"rendered":"\n

Importing data from Google Sheets into an Elementor table offers a seamless way to display and manage dynamic content on your website. By integrating Google Sheets with Elementor, you can effortlessly update and synchronise your data in real-time, ensuring that your table is always up to date.<\/p>\n\n\n\n

With the help of the Table widget from The Plus Addons for Elementor, you can import data from your Google Sheets directly into an Elementor table, eliminating the need for manual data entry and streamlining your workflow.<\/p>\n\n\n\n

To check the complete feature overview documentation of The Plus Addons for Elementor Table widget, click here<\/a>.<\/em><\/p>\n\n\n\n

Requirement  – This widget is a part of The Plus Addons for Elementor, make sure it’s installed & activated to enjoy all its powers.<\/em><\/strong><\/p>\n\n\n\n

\n
LIVE WIDGET LINK<\/a><\/div>\n<\/div>\n\n\n\n

<\/p>\n\n\n\n

To do this, first, you have to generate Google API Key.<\/p>\n\n\n\n

Generate Google API Key<\/h4>\n\n\n\n

1. Login to your Google account and go to the Google Developers Console<\/a>.<\/p>\n\n\n\n

2. If you don\u2019t have any project created, then click on CREATE PROJECT <\/strong>link.<\/p>\n\n\n\n

\"google<\/figure>\n\n\n\n

3. On the next screen, add your Project name<\/strong> and click the CREATE<\/strong> button.<\/p>\n\n\n\n

\"google<\/figure>\n\n\n\n

4. Then click on +ENABLE APIS AND SERVICES<\/strong> at the top.<\/p>\n\n\n\n

\"google<\/figure>\n\n\n\n

5. On the next page, search for Google Sheets API in the search bar. Click on Google Sheets API<\/strong> then click on the Enable<\/strong> button.<\/p>\n\n\n\n

\"google<\/figure>\n\n\n\n

6. Then click on Credentials<\/strong> in the left sidebar.<\/p>\n\n\n\n

7. On the Credentials page, from the top, click on + CREATE CREDENTIALS<\/strong> > API Key<\/strong>.<\/p>\n\n\n\n

\"google<\/figure>\n\n\n\n

8. It will generate the API Key, copy and paste the key into a notepad.<\/p>\n\n\n\n

\"google<\/figure>\n\n\n\n

In the same Google account that you generated the API key with, you should have a Google Spreadsheet with some data.<\/p>\n\n\n\n

Now to import Google Sheet data into the Elementor table with the Table widget follow the steps –<\/p>\n\n\n\n

1. Add the Table widget on the page, then select Google Sheet<\/strong> from the Content Table<\/strong> dropdown.<\/p>\n\n\n\n

2. In the API Key<\/strong> field, paste your API Key.<\/p>\n\n\n\n

\"table<\/figure>\n\n\n\n

3. Go to your Google Spreadsheet, and click on the Share<\/strong> button. In the popup, set the General Access<\/strong> to Anyone with the link<\/strong> and click on Done<\/strong>.<\/p>\n\n\n\n

\"google<\/figure>\n\n\n\n

This will allow the Table widget to access your Spreadsheet.<\/p>\n\n\n\n

4. Now, you have to find your Google Sheet ID. You can find the spreadsheet id in the spreadsheet URL.<\/p>\n\n\n\n

Example URL: https:\/\/docs.google.com\/spreadsheets\/d\/12XzuHrBwRQ_peHokt7xSczlZfRqVXCdWRDxLm-3dPjU\/edit#gid=0<\/a><\/p>\n\n\n\n

Then your id should be \u201c12XzuHrBwRQ_peHokt7xSczlZfRqVXCdWRDxLm-3dPjU\u201d<\/p>\n\n\n\n

\"google<\/figure>\n\n\n\n

Copy and paste your spreadsheet id in the Sheet ID<\/strong> field of the Table widget.<\/p>\n\n\n\n

5. In the Table Range<\/strong> field, you have to add the cell range of your Google Spreadsheet, which you want to show in your Elementor table.<\/p>\n\n\n\n

Go to your Spreadsheet, select the range, and then click on Data<\/strong> > Named ranges<\/strong>. <\/p>\n\n\n\n

It will show the cell range copy and paste it into the Table Range<\/strong> field of the Table widget.<\/p>\n\n\n\n

\"data<\/figure>\n\n\n\n

That\u2019s it. Now data from your Google Spreadsheet will show in your Elementor table.<\/p>\n\n\n\n

From the Refresh Time<\/strong> dropdown, you can select how often new data will be pulled from the Google Sheet.<\/p>\n\n\n\n

But if you want to pull fresh data from the Google Sheet before that specific time, you can click the Delete<\/strong> button in the Delete All Transient<\/strong> section. This will delete the existing data and add new data from the Google Sheet.<\/p>\n\n\n\n

Also, check How to Import Data From CSV in Elementor Table<\/a>.<\/p>\n","protected":false},"author":25,"featured_media":119434,"parent":0,"comment_status":"open","ping_status":"open","template":"","format":"standard","docs":[527,552],"class_list":["post-119413","documents","type-documents","status-publish","format-standard","has-post-thumbnail","hentry","docs-plus-widgets","docs-table"],"acf":[],"_links":{"self":[{"href":"https:\/\/etemplates.wdesignkit.com\/theplusaddons\/wp-json\/wp\/v2\/documents\/119413","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/etemplates.wdesignkit.com\/theplusaddons\/wp-json\/wp\/v2\/documents"}],"about":[{"href":"https:\/\/etemplates.wdesignkit.com\/theplusaddons\/wp-json\/wp\/v2\/types\/documents"}],"author":[{"embeddable":true,"href":"https:\/\/etemplates.wdesignkit.com\/theplusaddons\/wp-json\/wp\/v2\/users\/25"}],"replies":[{"embeddable":true,"href":"https:\/\/etemplates.wdesignkit.com\/theplusaddons\/wp-json\/wp\/v2\/comments?post=119413"}],"version-history":[{"count":0,"href":"https:\/\/etemplates.wdesignkit.com\/theplusaddons\/wp-json\/wp\/v2\/documents\/119413\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/etemplates.wdesignkit.com\/theplusaddons\/wp-json\/wp\/v2\/media\/119434"}],"wp:attachment":[{"href":"https:\/\/etemplates.wdesignkit.com\/theplusaddons\/wp-json\/wp\/v2\/media?parent=119413"}],"wp:term":[{"taxonomy":"docs","embeddable":true,"href":"https:\/\/etemplates.wdesignkit.com\/theplusaddons\/wp-json\/wp\/v2\/docs?post=119413"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}