---
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

- The Nexter Blocks Data Table block imports data from Google Sheets into a WordPress table by selecting Google Sheet in the Type section.
- Google API Key setup requires Google Developers Console, enabling Google Sheets API, and creating an API Key under Credentials.
- The Data Table block needs three inputs for the import: API Key, Sheet ID from the spreadsheet URL, and Table Range from Data > Named ranges.

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