---
title: "How to Import Data From Google Sheets in Elementor Table?"
url: https://theplusaddons.com/docs/import-data-from-google-sheets-in-elementor-table/
date: 2023-05-25
modified: 2026-04-11
author: "Aditya Sharma"
description: "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..."
image: https://theplusaddons.com/wp-content/uploads/2023/05/How-to-Import-Data-From-Google-Sheets-in-Elementor-Table_-1024x536.jpg
word_count: 554
---

# How to Import Data From Google Sheets in Elementor Table?

## Key Takeaways

- The Plus Addons for Elementor Table widget allows users to import data from Google Sheets directly into an Elementor table.
- Users must generate a Google API Key to enable the Table widget to access their Google Spreadsheet.
- The Table widget provides a Refresh Time option to select how often new data is pulled from the Google Sheet.

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.

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.

*To check the complete feature overview documentation of The Plus Addons for Elementor Table widget, [click here](/docs/table-elementor-widget-settings-overview/).*

***Requirement  - This widget is a part of The Plus Addons for Elementor, make sure it's installed & activated to enjoy all its powers.***

[LIVE WIDGET LINK](https://theplusaddons.com/elementor-widget/elementor-data-table/?utm_source=tpae&utm_medium=docs&utm_campaign=text)

To do this, first, you have to generate Google API Key.

#### Generate Google API Key

1. Login to your Google account and go to the [Google Developers Console](https://console.developers.google.com/).

2. If you don’t have any project created, then click on **CREATE PROJECT **link.

![google client id 1](https://theplusaddons.com/wp-content/uploads/2023/05/google-client-id-1.png)

3. On the next screen, add your **Project name** and click the **CREATE** button.

![google api key 2](https://theplusaddons.com/wp-content/uploads/2023/05/google-api-key-2.png)

4. Then click on **+ENABLE APIS AND SERVICES** at the top.

![google api key 3](https://theplusaddons.com/wp-content/uploads/2023/05/google-api-key-3.png)

5. On the next page, search for Google Sheets API in the search bar. Click on **Google Sheets API** then click on the **Enable** button.

![google api key 4](https://theplusaddons.com/wp-content/uploads/2023/05/google-api-key-4.gif)

6. Then click on **Credentials** in the left sidebar.

7. On the Credentials page, from the top, click on **+ CREATE CREDENTIALS** > **API Key**.

![google api key 5](https://theplusaddons.com/wp-content/uploads/2023/05/google-api-key-5.png)

8. It will generate the API Key, copy and paste the key into a notepad.

![google api key 6](https://theplusaddons.com/wp-content/uploads/2023/05/google-api-key-6.png)

In the same Google account that you generated the API key with, you should have a Google Spreadsheet with some data.

Now to import Google Sheet data into the Elementor table with the Table widget follow the steps -

1. Add the Table widget on the page, then select **Google Sheet** from the **Content Table** dropdown.

2. In the **API Key** field, paste your API Key.

![table google sheet](https://theplusaddons.com/wp-content/uploads/2023/05/table-google-sheet.png)

3. Go to your Google Spreadsheet, and click on the **Share** button. In the popup, set the **General Access** to **Anyone with the link** and click on **Done**.

![google sheet share access](https://theplusaddons.com/wp-content/uploads/2023/05/google-sheet-share-access.gif)

This will allow the Table widget to access your Spreadsheet.

4. Now, you have to find your Google Sheet ID. You can find the spreadsheet id in the spreadsheet URL.

Example URL: [https://docs.google.com/spreadsheets/d/12XzuHrBwRQ_peHokt7xSczlZfRqVXCdWRDxLm-3dPjU/edit#gid=0](https://docs.google.com/spreadsheets/d/12XzuHrBwRQ_peHokt7xSczlZfRqVXCdWRDxLm-3dPjU/edit#gid=0)

Then your id should be “12XzuHrBwRQ_peHokt7xSczlZfRqVXCdWRDxLm-3dPjU”

![google sheet id](https://theplusaddons.com/wp-content/uploads/2023/05/google-sheet-id.png)

Copy and paste your spreadsheet id in the **Sheet ID** field of the Table widget.

5. In the **Table Range** field, you have to add the cell range of your Google Spreadsheet, which you want to show in your Elementor table.

Go to your Spreadsheet, select the range, and then click on **Data** > **Named ranges**. 

It will show the cell range copy and paste it into the **Table Range** field of the Table widget.

![data table table range](https://theplusaddons.com/wp-content/uploads/2023/05/data-table-table-range.gif)

That’s it. Now data from your Google Spreadsheet will show in your Elementor table.

From the **Refresh Time** dropdown, you can select how often new data will be pulled from the Google Sheet.

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

Also, check [How to Import Data From CSV in Elementor Table](https://theplusaddons.com/docs/import-data-from-csv-in-elementor-table/).

## Frequently Asked Questions

**Q: What should I do if my Google Sheets data isn't showing up in the Elementor table?**
A: If your Google Sheets data isn't appearing, check that you've set the General Access of your spreadsheet to 'Anyone with the link' after clicking the Share button. This step is crucial for the Table widget from The Plus Addons for Elementor to access your data. If access is restricted, the widget won't be able to pull the information.

**Q: What is the best way to set the Table Range for my Elementor table?**
A: To set the Table Range effectively, select the desired cell range in your Google Spreadsheet, then navigate to Data > Named ranges to copy the range. This ensures that only the relevant data is displayed in your Elementor table, optimizing performance and clarity.

**Q: How do I generate a Google API Key for importing data into Elementor?**
A: To generate a Google API Key, log into your Google account and access the Google Developers Console. Create a new project, enable the Google Sheets API, and then create credentials by selecting '+ CREATE CREDENTIALS' and choosing API Key. This key is essential for linking your Google Sheets with the Elementor Table widget.

**Q: Are there any limitations when using Google Sheets with Elementor tables?**
A: One limitation is that the Table widget from The Plus Addons for Elementor requires a valid Google API Key and proper access settings on your Google Sheet. If these are not configured correctly, the data import will fail, preventing the table from displaying the intended content.