---
title: "Google Sheets Integration with FlexTable"
id: "38737"
type: "page"
slug: "google-sheets"
published_at: "2026-11-19T06:40:44+00:00"
modified_at: "2026-11-19T06:40:44+00:00"
url: "https://wppool.dev/flextable/integrations/google-sheets/"
markdown_url: "https://wppool.dev/flextable/integrations/google-sheets.md"
---

![Image](https://wppool.dev/wp-content/themes/wppool/assets/img/integrations/google-sheets.svg)×![Image](https://imagedelivery.net/ljIyvOIdtJguvpVgdVbbiA/677e8947-f0cf-4071-1a41-9c17e6777f00/public)

# Google Sheets integration with FlexTable

FlexTable integrates with Google Sheets in the free version of FlexTable.

Paste a sheet link and FlexTable renders it as a searchable, sortable table that re-syncs automatically.

[Get FlexTable](https://wppool.dev/flextable-pricing/)
[Download free](https://wordpress.org/plugins/sheets-to-wp-table-live-sync/)

![Google Sheets logo](https://wppool.dev/wp-content/themes/wppool/assets/img/integrations/google-sheets.svg)  ![FlexTable logo](https://imagedelivery.net/ljIyvOIdtJguvpVgdVbbiA/677e8947-f0cf-4071-1a41-9c17e6777f00/public)

Google Sheets × FlexTable

## About Google Sheets

Google Sheets is Google's online spreadsheet. Sheets live in Google Drive, can be shared with a team and can be read or written by other apps through the Google Sheets API.

[Visit the Google Sheets website](https://www.google.com/sheets/about/)

Google Sheets is a third-party product.

What you get with FlexTable

Paste a sheet link and FlexTable renders it as a searchable, sortable table that re-syncs automatically.

- Works with any sheet shared by link, multiple tabs supported
- Pro imports cell styles, images, links, checkboxes and merged cells
- Cache duration and timeout settings control how often the sheet is read

## How to set up Google Sheets with FlexTable

Typical setup time: 2 minutes.

1. 1Share your Google Sheet so anyone with the link can view it.
2. 2Create a new table in FlexTable and paste the sheet link. Pick the tab you want to show.
3. 3Choose search, sorting, pagination and style options.
4. 4Insert the table with the block, the Elementor widget or the shortcode. It re-syncs when the sheet changes.

## What data moves

| Data | Direction |
| --- | --- |
| Sheet rows and calculated values | Google Sheet to the WordPress table |
| Cell styles, images, links, checkboxes, merged cells | Imported on Pro |

### Requirements

- A Google account and a sheet viewable by link
- FlexTable free. Pro adds cell styles, images, links, checkboxes and merged cells

## Use cases

### A public price list kept in a sheet

A distributor keeps prices in a sheet the sales team already edits. FlexTable shows that sheet on the website, so the public price list follows the sheet.

### Results and schedules that change often

A school or club updates results in a shared sheet, and the website table shows the new rows after the next sync.

## Google Sheets integration FAQ

### Is the sync two-way?

No. FlexTable reads from the sheet and displays it. Edit the data in Google Sheets and the table follows.

### Do I need a Google Cloud account?

No. FlexTable only needs a sheet that is viewable by link.

### How often does the table update?

FlexTable has a cache duration you set, from near real time to several hours.

### Can I keep the sheet private?

FlexTable needs a sheet that is viewable by link so it can fetch the rows. Keep private columns in a separate tab or sheet.

### Does FlexTable work with Google Sheets formulas?

Yes. FlexTable shows the calculated values from the sheet, so formulas, lookups and imported ranges all appear as their results.

## More FlexTable integrations

[All FlexTable integrations](https://wppool.dev/flextable/integrations/)

[Elementor An Elementor widget that lists your FlexTable tables and renders the one you pick.](https://wppool.dev/flextable/integrations/elementor/)
[Gutenberg Block Editor A FlexTable block that lists your tables and renders the one you choose, with a live preview in the editor.](https://wppool.dev/flextable/integrations/gutenberg/)
[OpenAI AI table summaries and AI search using your OpenAI API key.](https://wppool.dev/flextable/integrations/openai/)

## Connect Google Sheets with FlexTable

In the free version of FlexTable. Start with the free plugin from WordPress.org.

[Get FlexTable](https://wppool.dev/flextable-pricing/)
[Download free](https://wordpress.org/plugins/sheets-to-wp-table-live-sync/)
