Name: FlexTable – Data Table Sync with Google Sheets
Rating: 4.6 (35 reviews)
Author: WPPOOL

FlexTable – Spreadsheet to WP Table Sync ets you create responsive tables that stay updated based on changes made in your connected sheet. After linking a sheet, any edits made there will reflect automatically on your site. The plugin includes shortcode and page-builder support so you can place tables on any page or post and keep them synchronized. It also supports sorting, pagination, search, AI analysis and options for displaying images, links, and other data formats.

Recommended by WordPress experts! 🤩

Let’s grow, connect, and thrive together!

🤝 Join Our Facebook Community
🌐 Follow Us on X (Twitter)
🎥 Subscribe on YouTube
👍 Like Our Facebook Page

To show your spreadsheet data in a WP table, connect your sheet to FlexTable and embed it on your site.

👁️ View Demo | 🚀 Get PRO | 🤝 Join Our Community

LEARN MORE

😍 FlexTable Free Features

Sync Data with Google Sheets: Keep your WordPress tables synced with connected Google Sheets spreadsheets. You can update your table from anywhere through the connected sheet without ever needing to enter your website dashboard.
Gutenberg Table Block & Elementor Table Widget: The built-in Gutenberg block and Elementor widget will make sure you can create responsive tables with any of your preferred page builders.
Responsive Tables: Tables made with this plugin are responsive for any device. The plugin allows collapsing on mobile and tablet screens. There are also options to choose between three responsive styles (Default, Collapsible, and Scrollable) and adjust height.
Shortcode Supported: Place your data-table easily with the shortcode feature. A shortcode will be created with the table created. You can place the code anywhere you want on your page or posts.
Link Support: With advanced link support you can import URLs/links from Google Sheets. All the URLs/links will be shown as links instead of text. You can change the link behavior by redirecting your users when they click on those links.
Image Support: Load images from any URL that contains an image. Just add the image URL to your sheet and it will load that image on your website.
Merge Cells: If your spreadsheet has merged cells, you can enable this feature to improve the appearance and clarity.
Cache Table for Faster Loading: Enabling this option can improve your table loading speed.
Prevent frequent cache updates for faster table loading: Optimized caching helps your tables load faster and reduces unnecessary API requests.
Choose the maximum day to store the cache: With Cache Duration, you decide the duration of Google Sheets checking for updates. Just set it to 1 day, 7 days, 30 days etc, whatever fits your update routine. It helps your tables load quicker and reduces unnecessary API requests
2 Table Themes: Easily customize the appearance by choosing one of the provided themes (Simple and Simple on Dark).
Duplicate Tables: Easily generate duplicates without manually recreating them from scratch. Save time and maintain consistency across multiple tables.
Table Description: Communicate with your site visitors with clear descriptions that describe the purpose of your tables. Easily convey important information through the description.
Cell Formatting Style: Choose between expanded and wrapped table styles.
Rows to Show Per Page: Choose the number of rows you want to display per page.
Table Title: Enable this feature to show the title in the h3 tag in your website front-end. Rename your tables as you want.
Show Info Block: Show Showing X to Y of Z entries block below the table. With this feature, you will get an idea of the data sequence of your table at a glance. The plugin also has an On/Off button on the backend for this feature.
Allow Sorting: It allows data sorting on your table in the exact order you need. You can turn off the feature if you want your data not sorted.
Search Bar: Quickly locate data using the built-in search bar for better usability.
Pagination Support: Access in-built table pagination support. Order your data in a simple manner of sequential pages that are contextually connected.
Asynchronous Loading: Enable this feature to load the table in the front end after loading all content with a pre-loader.
Set Maximum Response Timeout for Table Loading: Take control of performance with a global setting to define how long (in seconds) the plugin should wait for a response from the Google server.
Multisite Support: With spreadsheet to Table Multisite support, share sync features across your multisite network.

👁️ View Demo | 🚀 Get PRO | 🤝 Join Our Community

⚡ Experience the Full Potential with FlexTable Pro

Import Styles from Google Sheets: Import cell background color & cell font color, font size, font widget, font family & all other styles from connected sheet.
Custom CSS: Write your own custom CSS to design the table or the page itself. Your custom-written CSS will be applied to the front end of the website.
Export Table: Exporting via CSV, Excel, PDF, JSON, Print, and Copy is easy on this plugin.
Tab Management: Manage all the tables in 1 place as a tab. This feature enables you to effectively manage your data from multiple sheets.
Vertical Scroll/Sticky Header: This feature allows you to scroll vertically. Activating this feature will allow the table to behave as a sticky header.
6 Premium Table Themes: Switch your table’s look and feel. Each of the themes is created to provide a modern and responsive experience.
Customize Table Theme: Personalize header, body, and border colors.
Table Theme Builder: Create your own themes to display tables. With an in-built table builder, customize every section of your table. Once you create a theme, it’s yours. You can use the theme for later on as well.
Premium Table Pagination: Choose from five themes for pagination—Default, Modern, Minimal, Tailwind, or Outlined. You can customize the active pagination color and position the pagination at the middle or bottom right.
Horizontal Dragging: Once you enable this feature your users will be able to drag the table horizontally.
Hide Column: Hide your Sheet’s column on desktop screen OR mobile screens.
Hide Row: Hide your Sheet’s rows based on your custom row selection.
Hide Cell: Hide your Sheet’s cell data based on your custom cell selection.
Optimized Loading: By enabling this feature, the scripts will load only on the relevant pages/posts in your website where the table is added.
Table Sorting Control: Easily set a default sort order for tables when the page loads. You can also hide the sorting controls from the table for a cleaner and more streamlined display.
Freeze Header & Column: You can now freeze any column(s) from the left or right side, based on your preference. Additionally, you can also freeze the header with a customizable height to enhance your viewing experience while scrolling.
Always-on support: We have a dedicated and hardworking team. Get support for any issues with Flex Table.

👁️ View Demo | 🚀 Get PRO | 🤝 Join Our Community

✨ AI Powered FlexTable

Transform static tables into intelligent, conversational experiences that understand and respond to your users’ needs. It delivers two powerful capabilities to enhance data accessibility:

Instant AI Summary – One-click comprehensive overviews of your entire dataset
Interactive AI Table Assistant – Conversational Q&A for deep data exploration

⚡ Instant AI Summary

With just one click, your visitors receive a clear and concise AI-generated summary of your entire table. People naturally prefer quick, ready-made answers over complex data tables. This intelligent data summary feature helps them understand your information faster than ever.

How it works

There are two quick ways to showcase the AI table summary for your users.

Generate on Click: Visitors will see a button to summarize the table. When they click, AI will create the summary live using your prompt. Suitable for tables with frequently changing data.
Instant Summary: You can generate and save the summary in advance. Visitors will see it immediately. Suitable for tables with mostly static data.

🤖 Interactive AI Table Assistant

Beyond automatic summaries, empower your visitors with conversational AI capabilities. Users can ask specific questions about your table data and receive instant AI-powered answers tailored to their needs.

How Ask AI Works:

Users can type questions like:

“What’s the average value in this column?”
“Show me entries from last month.”
“Which row has the highest sales?”

The AI analyzes your table in real-time and delivers personalized data analysis instantly.

This intelligent table interaction transforms static data into an engaging, conversational data experience.

💼 FlexTable in Academic and Administrative Management

Use the Search Only Display feature to create a focused search interface for your tables. It provides a search field that helps users locate specific entries such as student details, employee information, or institutional data. You can enable column-specific searches and control which fields appear on the front end.

This feature is useful for building tools like student report cards, class grading systems, or course schedules. It also supports broader record-management workflows where clear and accessible data presentation is required.

Examples of how it can be used:

Let users search records by ID, grade level, or class section.
Allow filtering of teacher profiles by department or subject.
Enable front-end lookups for class schedules by time or instructor.
Provide a searchable staff directory with role or department filters.
Display exam results filtered by student name or course.

👁️ View Demo | 🚀 Get PRO | 🤝 Join Our Community

🔥 More Awesome Plugins

If you like FlexTable, then consider checking out our other awesome projects:

🌓 WP Dark Mode:
Use WP Dark Mode plugin to create a stunning dark version for your WordPress website. WP Dark Mode works automatically without going into any complicated settings.
🔄 FlexStock – Manage WooCommerce Inventory from Google Sheets:
FlexStock – Stock Sync with Google Sheet for WooCommerce | Auto-sync WooCommerce products from Google Sheets. Flex Stock is an easy, powerful, and simple inventory management system to handle your WooCommerce products.
🛒 FlexOrder – Manage Order with Google Sheets:
Try FlexOrder – Bulk Order Sync with Google Sheet for WooCommerce | Manage WooCommerce orders from Google Sheets. WooCommerce order sync, e-commerce order management, and sales order management with Google Sheets. Try Flex Order now!
💬 FormyChat – Send Form Leads to Chat App:
Try FormyChat | Connect Form to Chat Apps with Contact Form 7, WPForms, Gravity Form | Welcome Popup & Multi-agent Live Chat
🎁 EchoRewards – Boost Sales with a Smart Referral System:
Try EchoRewards | With Echo Reward, you can refer a friend for WooCommerce to launch your customer referral program. Echo Rewards Referral Plugin is a WooCommerce referral plugin to boost your sales. Generate coupons, reward customers, and launch the ideal refer-a-friend program for your store.

External Services

This plugin connects to external services only for the features you configure. You supply your own API key for whichever AI provider you choose in Settings, and only that provider is contacted.

OpenAI
– Purpose: Generates table summaries responses and summary for the table.
– Service URL: https://api.openai.com/v1/
– Privacy Policy: https://openai.com/privacy/
– Terms of Service: https://openai.com/policies/row-terms-of-use/

Google Gemini
– Purpose: Generates table summaries responses and summary for the table.
– Service URL: https://generativelanguage.googleapis.com/
– Privacy Policy: https://policies.google.com/privacy
– Terms of Service: https://ai.google.dev/gemini-api/terms
Full terms of service and privacy policy links for each provider are also available in the plugin’s Privacy section under Settings.

Google Sheets Style Sync (script.google.com)
– Purpose: A Google Apps Script web app used to collect cell styles and formatting data (background color, font color, font size, font weight, font family etc.) from connected Google Sheets. This is required for the “Import Sheet Styles” feature to replicate spreadsheet visual formatting in the WordPress table.
– Data sent: The Google Sheets spreadsheet ID (extracted from the sheet URL you configure) to identify which sheet to read styles from.
– When it connects: Only when the table is loaded and the “Import Sheet Styles” feature is enabled for that table.
– Service URL: https://script.google.com/
– Privacy Policy: https://policies.google.com/privacy
– Terms of Service: https://policies.google.com/terms

Headway Changelog Widget (headwayapp.co)
– Purpose: Displays plugin changelog and update notifications inside the WordPress admin documentation/help page. This shows what’s new in recent plugin versions.
– Data sent: A plugin identifier to fetch the relevant changelog feed. No personal user data is sent.
– When it connects: Only when an admin views the plugin’s documentation page inside the WordPress dashboard.
– Service URL: https://headwayapp.co/
– Privacy Policy: https://headwayapp.co/privacy
– Terms of Service: https://headwayapp.co/terms

Appsero Telemetry (appsero.com + icanhazip.com)
– Purpose: Appsero SDK collects basic usage telemetry to help with debugging and product improvements. As part of this, it calls icanhazip.com solely to obtain the server’s public IP address for the telemetry payload.
– Data sent: Basic site environment info (WordPress version, PHP version, active plugins list, server IP via icanhazip.com). No personal visitor data is collected.
– When it connects: Only after the site admin explicitly opts in via the admin notice. No data is sent by default.
– When it connects: When telemetry tracking is enabled (opt-in), and also when submitting the plugin deactivation feedback form, regardless of tracking opt-in status.

Appsero URL: https://appsero.com/
Appsero Privacy Policy: https://appsero.com/privacy-policy/
icanhazip.com URL: https://icanhazip.com/
icanhazip.com is a simple public IP lookup service operated by Cloudflare.

Source Code

The source files for all compiled/minified JavaScript and CSS are publicly available in the plugin repository:

The following compiled files have human-readable sources in the repository:
– assets/public/scripts/frontend/frontend.min.js source in assets/src/scripts/
– assets/public/scripts/backend/admin.min.js source in assets/src/scripts/
– assets/public/scripts/backend/divi.min.js source in assets/src/scripts/
– react/build/index.js source in react/src/

Build instructions:

Run npm install in the root to install dependencies.
Run npm run build to compile the JavaScript and CSS assets.
The compiled files are output to assets/public/scripts/ and react/build/.

Privacy Policy

Flex Table uses Appsero SDK to collect some telemetry data upon user’s confirmation. This helps us to troubleshoot problems faster & make product improvements.

Appsero SDK does not gather any data by default. The SDK only starts gathering basic telemetry data when a user allows it via the admin notice. We collect the data to ensure a great user experience for all our users.

Integrating Appsero SDK DOES NOT IMMEDIATELY start gathering data, without confirmation from users in any case.

Learn more about how Appsero collects and uses this data.

Additionally, read the WPPOOL privacy policy.