---
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-08-10
lang: en
author: "Aditya Sharma"
description: "Do you want to display Google Sheets data inside an Elementor table without manual data entry? Connecting a live spreadsheet to your table keeps the content current whenever the source..."
image: https://theplusaddons.com/wp-content/uploads/2023/05/How-to-Import-Data-From-Google-Sheets-in-Elementor-Table_-1024x536.jpg
word_count: 559
---

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

## 

- The Plus Addons for Elementor Table widget importa datos de Google Sheets directamente en una tabla de Elementor y actualiza el contenido automáticamente cuando cambia la hoja de origen.
- Google API Key requiere crear un proyecto en Google Developers Console, habilitar Google Sheets API y copiar la clave desde Credentials > + CREATE CREDENTIALS > API Key.
- Table widget usa tres datos clave para la importación: API Key, Sheet ID y Table Range, y permite forzar una actualización con Delete All Transient antes del tiempo programado.

Do you want to display Google Sheets data inside an Elementor table without manual data entry? Connecting a live spreadsheet to your table keeps the content current whenever the source data changes.

The Table widget in The Plus Addons for Elementor lets you import data from Google Sheets directly into an Elementor table. Set a refresh interval and your table updates automatically from the source spreadsheet.

**Best Used For:**

- Marketing and sales teams displaying live metrics or pricing data from a shared spreadsheet

- Agencies managing client data in Google Sheets who need it visible on an Elementor site

- Course and membership sites presenting enrollment or progress data pulled from a Google Sheet

*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 is installed and 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 generate a Google API Key.

#### Generate Google API Key

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

2. If you do not have any project created, click the **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. Click **+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 **Google Sheets API**, then click the **Enable** button.

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

6. Click **Credentials** in the left sidebar.

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

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

8. The API Key is generated. Copy and save the key.

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

In the same Google account where you generated the API key, make sure you have a Google Spreadsheet with your data.

Now, to import Google Sheet data into the Elementor table with the Table widget, follow these steps.

1. Add the Table widget to 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 the **Share** button. In the popup, set **General Access** to **Anyone with the link** and click **Done**.

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

This allows the Table widget to access your spreadsheet.

4. Find your Google Sheet 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)

The sheet ID in this example is "12XzuHrBwRQ_peHokt7xSczlZfRqVXCdWRDxLm-3dPjU".

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

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

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

Go to your Spreadsheet, select the range, then click **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)

Your Google Spreadsheet data now appears in the Elementor table.

From the **Refresh Time** dropdown, select how often the Table widget pulls new data from the Google Sheet.

To force a refresh before the scheduled time, click the **Delete** button in the **Delete All Transient** section. This clears the cached data and pulls fresh data from the Google Sheet.

The Plus Addons for Elementor also includes the [Circle Progress widget](https://theplusaddons.com/docs/create-circle-progress-bars-in-elementor/) if you need to visualize numerical data from your spreadsheet as animated progress indicators.

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