---
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
lang: en
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?

## 

- Integrates Google Sheets with Elementor using The Plus Addons for Elementor Table widget for real-time data synchronization.
- Generates Google API Key through Google Developers Console to enable access to Google Sheets API.
- Imports data by configuring the Table widget with Google Sheet ID and cell range, allowing dynamic content display on the website.

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/).