---
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-09-14
lang: en
author: "Aditya Sharma"
description: "If your price list, schedule or directory already lives in a Google Sheet, typing it again into Elementor is double work. The Google Sheet source of the Table widget from..."
image: https://theplusaddons.com/wp-content/uploads/2023/05/How-to-Import-Data-From-Google-Sheets-in-Elementor-Table_-1024x536.jpg
word_count: 616
---

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

## 

- The Plus Addons for Elementor Table widget reads a Google Sheet range and shows it as a table on the page, so price lists, schedules, or directories do not need to be typed again into Elementor.
- Google Sheets source requires The Plus Addons for Elementor Pro, while the Table widget itself is free and must be switched on under The Plus Addons > Widgets.
- Google Cloud setup needs a Google Sheets API key, and the spreadsheet must be shared with General access set to Anyone with the link so the table can read it.
- Table Range uses a sheet name and cell range such as Sheet1!A1:E13, the first row becomes the table header, and Refresh Time stores sheet data for 1 hour, 2 hour, 6 hour, 1 day, or 1 Week.

If your price list, schedule or directory already lives in a Google Sheet, typing it again into Elementor is double work.

The **Google Sheet** source of the **Table** widget from The Plus Addons for Elementor reads a range of your spreadsheet and shows it as a table on your page.

*To check the complete feature overview documentation of The Plus Addons for Elementor Table widget, [click here](https://theplusaddons.com/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/data-tables/?utm_source=tpae&utm_medium=docs&utm_campaign=text)

## Before You Start

- **Edition:** **Pro** — The Google Sheet source needs The Plus Addons for Elementor Pro. The Table widget itself is free.- **Widget to enable:** Table, switched on under **The Plus Addons > Widgets**.- A Google account with the spreadsheet.- A Google Cloud API key with the Google Sheets API enabled (steps below).

## Step 1: Create a Google API Key

- Sign in to the [Google Cloud console](https://console.cloud.google.com/) with your Google account.- Open **APIs and services**. If no project is selected yet, click **CREATE PROJECT**, or pick an existing project.

![The Google Cloud APIs and services page asking to select a project, with the Create Project link](https://theplusaddons.com/wp-content/uploads/2023/05/google-client-id-1.png)

- Give the project a name and create it.

![The New Project form in Google Cloud with a project name filled in](https://theplusaddons.com/wp-content/uploads/2023/05/google-api-key-2.png)

- In the project's **APIs & Services**, click **ENABLE APIS AND SERVICES**, search for **Google Sheets API** and enable it.

![The APIs and Services dashboard of the new project with the Enable APIs and Services link at the top](https://theplusaddons.com/wp-content/uploads/2023/05/google-api-key-3.png)

![Animated demo of searching the Google Cloud API library for Google Sheets API and enabling it](https://theplusaddons.com/wp-content/uploads/2023/05/google-api-key-4.gif)

- Go to **Credentials**, click **CREATE CREDENTIALS** and choose **API key**. Copy the key from the dialog.

![The Create Credentials menu on the Google Cloud Credentials page with API key at the top](https://theplusaddons.com/wp-content/uploads/2023/05/google-api-key-5.png)

![The API key created dialog in Google Cloud with the new key](https://theplusaddons.com/wp-content/uploads/2023/05/google-api-key-6.png)

> *Google's console changes over time, so its menus may look different from these screenshots. Restrict the key to the Google Sheets API in Google Cloud if you can.*

## Step 2: Share the Spreadsheet

In the spreadsheet, click **Share** and set **General access** to **Anyone with the link**, so the table can read it with your API key.

![Animated demo of sharing a Google spreadsheet with Anyone with the link](https://theplusaddons.com/wp-content/uploads/2023/05/google-sheet-share-access.gif)

## Step 3: Connect the Sheet to the Table Widget

- Add the **Table** widget. In **Content > Table**, set **Content Table** to **Google Sheet**.- Paste your key into **API Key**.- Copy the **Sheet ID** from the spreadsheet address: it is the long code between `/d/` and `/edit`. Paste it into **Sheet ID**.

![A Google spreadsheet with the Sheet ID highlighted in the browser address bar](https://theplusaddons.com/wp-content/uploads/2023/05/google-sheet-id.png)

- In **Table Range**, enter the sheet name and cell range to show, for example `Sheet1!A1:E13`. The first row of the range becomes the table header.

![Animated demo of selecting a cell range in a Google spreadsheet](https://theplusaddons.com/wp-content/uploads/2023/05/data-table-table-range.gif)

![The Google Sheet source with API Key, Sheet ID and Table Range filled in with example values, so the canvas shows the Data Not Found error box](https://theplusaddons.com/wp-content/uploads/2026/09/table-gsheet.webp)

## Refresh Time and Delete All Transient

The sheet data is stored on your site between updates. **Refresh Time** is how long it is stored: **1 hour**, **2 hour**, **6 hour**, **1 day** (default) or **1 Week**. Choose a short time if the sheet changes often.

**Delete All Transient** has a **Delete** button that clears the stored data of the Table widgets on your site. Only administrators can use it.

![Refresh Time set to 1 day with the Delete All Transient button below it, next to the error box shown for example values](https://theplusaddons.com/wp-content/uploads/2026/09/table-gsheet-refresh.webp)

## Limitations

- **Wrong or missing details show an error to visitors.** In our test, an empty or invalid API Key, Sheet ID or Table Range showed a red “Data Not Found! Google Sheet Data Not Found” box on the page. Check the table after publishing.- Sheet changes are not shown on every page view, because the data is stored for the Refresh Time.- Per-cell icons, images, buttons and tooltips are only available with the Custom source.- The source is Pro. The free plugin lists it as “Google Sheet (Pro)” with an upgrade notice.

## Troubleshooting

### The page shows Data Not Found

Check that the Google Sheets API is enabled for the key, that the sheet is shared with **Anyone with the link**, and that the Sheet ID and Table Range (including the sheet tab name) are typed exactly.

### Google Sheet is missing from Content Table

It needs The Plus Addons for Elementor Pro. If Pro is active, check that the Google Sheet option of the Table widget is switched on in the Table widget's settings under **The Plus Addons > Widgets**.

## Related Docs

- [Table widget settings overview](https://theplusaddons.com/docs/table-elementor-widget-settings-overview/)- [Import data from a CSV file](https://theplusaddons.com/docs/import-data-from-csv-in-elementor-table/)- [Show WordPress database entries in a table](https://theplusaddons.com/docs/show-wordpress-database-entries-in-an-elementor-table/)

## Frequently Asked Questions

**Q: What do I need before importing Google Sheets data into an Elementor table?**
A: The setup depends on The Plus Addons for Elementor Pro, because the Google Sheet source is a Pro feature while the Table widget itself is free. You also need the Table widget enabled under The Plus Addons > Widgets, a Google account with the spreadsheet, and a Google Cloud API key with the Google Sheets API enabled. That combination matters because the widget reads a range from your sheet instead of copying data manually.

**Q: How do I get a Google API key for the Table widget?**
A: The key comes from Google Cloud Console, not from Elementor. Create or pick a project, enable Google Sheets API in APIs and services, then go to Credentials and create an API key. The page also notes that Google’s menus can change over time, so the exact labels may look different. If possible, restrict the key to the Google Sheets API in Google Cloud for tighter control.

**Q: Why does my sheet need to be shared with Anyone with the link?**
A: The Table widget reads the spreadsheet through your API key, so the sheet has to be accessible at that permission level. Set General access to Anyone with the link so the widget can read it. If sharing is too restrictive, the table can fail even when the API key is valid, which is why this step is part of the basic setup for The Plus Addons for Elementor.

**Q: Why does Elementor show Data Not Found when I connect Google Sheets?**
A: That error usually points to one of three things: an empty or invalid API Key, an incorrect Sheet ID, or a wrong Table Range. The page also says the sheet must be shared with Anyone with the link and that Google Sheets API must be enabled for the key. A good sanity check is to verify the tab name inside Table Range, since even a small typo can trigger the red Data Not Found box.

**Q: How often does an Elementor table refresh Google Sheets data?**
A: The sheet data is cached on your site between updates, so changes do not appear on every page view. Refresh Time controls that cache window and can be set to 1 hour, 2 hour, 6 hour, 1 day by default, or 1 Week. Shorter intervals make updates appear sooner, while longer intervals reduce how often stored data gets replaced.