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.
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
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
Share your Google Sheet so anyone with the link can view it.
- 2
Create a new table in FlexTable and paste the sheet link. Pick the tab you want to show.
- 3
Choose search, sorting, pagination and style options.
- 4
Insert 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?
Do I need a Google Cloud account?
How often does the table update?
Can I keep the sheet private?
Does FlexTable work with Google Sheets formulas?
More FlexTable integrations
All FlexTable integrationsConnect Google Sheets with FlexTable
In the free version of FlexTable. Start with the free plugin from WordPress.org.