---
title: "How to Import Data From Google Sheets in WordPress Table?"
url: https://nexterwp.com/docs/import-data-from-google-sheets-in-wordpress-table/
date: 2023-04-11
modified: 2026-04-15
author: "Aditya Sharma"
description: "Importing data from Google Sheets to a WordPress table can be an easy and efficient way to manage and update large amounts of data on your website. Google Sheets is..."
image: https://nexterwp.com/wp-content/uploads/2024/05/import-data-from-google-sheets-in-wordpress-table-1024x519.jpg
word_count: 504
---

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

## Key Takeaways

- Nexter Blocks includes a Data Table block that allows users to import data from Google Sheets into a WordPress table.
- Users must generate a Google API Key and set the Google Spreadsheet access to 'Anyone with the link' for the Data Table block to function properly.
- The Google Sheet ID is required and can be found in the spreadsheet URL, which is necessary for importing data into WordPress.

Importing data from Google Sheets to a WordPress table can be an easy and efficient way to manage and update large amounts of data on your website. Google Sheets is a popular and powerful cloud-based spreadsheet application that allows multiple users to edit and collaborate on data in real-time. By connecting your Google Sheets to your WordPress site, you can easily import and update data in your WordPress tables.

With the Data Table block from The Nexter Blocks you can easily import data from Google Sheets into a WordPress Table.

*To check the complete feature overview documentation of the Nexter Blocks* Data Table block, [click here](/docs/data-table-block-settings-overview/).

***Requirement  - This block is a part of the Nexter Blocks*, make sure its installed & activated to enjoy all its powers.**

[LIVE BLOCK LINK](https://nexterwp.com/nexter-blocks/blocks/wordpress-data-table/)

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://nexterwp.com/wp-content/uploads/2023/03/google-client-id-1.png)

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

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

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

![google api key 3](https://nexterwp.com/wp-content/uploads/2023/04/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://nexterwp.com/wp-content/uploads/2023/04/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://nexterwp.com/wp-content/uploads/2023/04/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://nexterwp.com/wp-content/uploads/2023/04/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 Sheets data into the WordPress table with the Data Table block follow the steps -

1. Add the Data Table block on the page, then in the **Table** tab, select **Google Sheet** from the **Type** section.

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

![](https://nexterwp.com/wp-content/uploads/2023/04/data-table-google-api-key-new-1.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**.

This will allow the Data Table block 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***

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

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

Copy and paste your spreadsheet ID in the **Sheet ID** field of the Data Table block.

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

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

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

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

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

## Frequently Asked Questions

**Q: What should I do if I can't generate a Google API Key?**
A: If you're having trouble generating a Google API Key, ensure you're logged into your Google account and have created a project in the Google Developers Console. If you haven't created a project, click on the 'CREATE PROJECT' link. After that, make sure to enable the Google Sheets API by searching for it in the APIs and Services section. If issues persist, check your account permissions or try a different browser.

**Q: Can I use the Data Table block to display data from multiple Google Sheets?**
A: The Data Table block from Nexter Blocks is designed to import data from a single Google Sheet at a time. If you need to display data from multiple sheets, you would have to create separate Data Table blocks for each sheet. This allows for more organized data presentation on your WordPress site.

**Q: What is the best way to set the Table Range for my Google Sheets data?**
A: When setting the Table Range in the Data Table block, it's essential to accurately specify the cell range you want to display. You can find this by selecting the desired range in your Google Spreadsheet and then using the 'Named ranges' feature. This ensures that only the relevant data is shown in your WordPress table, improving clarity and usability.

**Q: Are there any limitations when importing data from Google Sheets?**
A: While importing data from Google Sheets using the Data Table block is straightforward, there are limitations to consider. For instance, the block only supports one Google Sheet at a time, and the data range must be correctly defined. Additionally, ensure that your Google API Key is valid and that the Google Sheets API is enabled to avoid access issues.