WesternDeal

GSheetConnector

Abdullah Kaludi

GSheetConnector for Core Lite is an addon plugin—a bridge between your <a href="https://wordpress.org/" rel="ugc">WordPress</a> core content (Pages, Posts, Users and Comments) and <a href="https://www.google.com/sheets/about/" rel="nofollow ugc">Google Sheets</a>.
It allows you to send and manage your WordPress data in Google Sheets, helping you keep everything organized, accessible, and easy to track from one central place.
<h4>🗂️ WordPress Core ➜ to 📊 Google Sheets</h4>
Easily connect your WordPress Pages, Posts, Users, and Comments to Google Sheets without writing any code. This plugin helps you organize your WordPress data into structured spreadsheets for easy tracking and management.
<h4>⚡️ How to Use this Plugin</h4>
<h4>Option 1: All Data in One Spreadsheet (Tabs Based)</h4>
<ul>
<li>
Step 1: In Google Sheets 
➜ Log into your Google account and open Google Sheets. 
➜ Create a new spreadsheet or open an existing one.
</li>
<li>
Step 2: Connect Google Sheets in WordPress 
➜ Log into your WordPress Admin Dashboard. 
➜ Navigate to GSheetConnector → Settings. 
➜ Click Fetch Sheets to load your Google Spreadsheets. 
➜ Select your Google Spreadsheet Name from the dropdown.
</li>
<li>
Step 3: Select Data Type (Tab Creation) 
➜ Scroll to Google Sheets / Tab Name section. 
➜ Enable the toggle for the tabs you want to create:
</li>
<li>Posts</li>
<li>Pages</li>
<li>Users</li>
<li>
Comments 
➜ The plugin will create separate tabs inside the selected spreadsheet.
</li>
<li>
Step 4: Configure Sheet Headers (Columns) 
➜ Go to Google Sheet Headers (Column Name) section. 
➜ Choose the header group:
</li>
<li>Post Headers</li>
<li>Page Headers</li>
<li>Comment Headers 
➜ Enable the fields you want to include (e.g. Post Title, Post Date, Status, Author). 
➜ Use Check All to include all available fields. 
➜ Save the settings.</li>
</ul>
<h4>Option 2: Separate Sheet for Each Data Type (Feed Settings)</h4>
<ul>
<li>Step 1: Create a Feed 
➜ Navigate to GSheetConnector → Settings → Feed Settings. 
➜ Click Add Feeds. 
➜ Enter a Feed Name. 
➜ Select a Feed Type:</li>
<li>Posts</li>
<li>Pages</li>
<li>Users</li>
<li>
Comments 
➜ Save the feed and click Edit.
</li>
<li>
Step 2: Configure Feed Headers 
➜ Open the created feed from the feed list. 
➜ Select the Google Spreadsheet Name for this feed. 
➜ Based on the feed type, configure headers:
</li>
<li>Posts Headers</li>
<li>Pages Headers</li>
<li>Users Headers</li>
<li>
Comments Headers 
➜ Enable the fields you want to include as columns. 
➜ Use Check All if required.
</li>
<li>
Step 3: Create an Individual Sheet per Feed 
➜ Click Submit Data after selecting headers. 
➜ The plugin will create an individual sheet (tab) inside the selected spreadsheet. 
➜ Each feed maintains its own separate sheet for better data organization.
</li>
<li>
Step 4: Manage Feeds 
➜ View all feeds under Feed Settings. 
➜ Enable or disable feeds using the status toggle. 
➜ Edit or delete feeds anytime as needed.
</li>
</ul>
<h3>External Services</h3>
GSheetConnector for Core Lite relies on Google APIs to connect WordPress with Google Sheets. 
These services are required for authentication and for creating, reading, and updating spreadsheets 
based on WordPress core data (Posts, Pages, Users, and Comments).
This plugin does NOT send any data to the plugin author’s servers.
<h4>1. Google Sheets API</h4>
• Service: Google Sheets API (Google LLC) 
• Purpose: 
Used to create spreadsheets, create sheet tabs, write WordPress data into sheets, 
and read existing spreadsheet information. 
• Data Sent: 
Spreadsheet structure and content based on the administrator’s selected WordPress data. 
• When Data Is Sent: 
Only when the site administrator explicitly performs an action such as submitting data 
or creating sheets. 
• API Scope Used: 
https://www.googleapis.com/auth/spreadsheets 
• Terms of Service: 
https://policies.google.com/terms 
• Privacy Policy: 
https://policies.google.com/privacy
<h4>2. Google Drive API</h4>
• Service: Google Drive API (Google LLC) 
• Purpose: 
Used to list available Google Spreadsheets and access spreadsheet file metadata. 
• Data Sent: 
File metadata (such as spreadsheet ID and name). 
• When Data Is Sent: 
When the administrator fetches or selects Google Spreadsheets from the plugin settings. 
• API Scopes Used: 
https://www.googleapis.com/auth/drive.file 
https://www.googleapis.com/auth/drive.metadata.readonly 
• Terms of Service: 
https://policies.google.com/terms 
• Privacy Policy: 
https://policies.google.com/privacy
<h4>3. Google OAuth 2.0 Authentication</h4>
• Service: Google OAuth 2.0 (Google LLC) 
• Purpose: 
Used to securely authenticate users and authorize access to Google Sheets and Google Drive. 
• Data Sent: 
OAuth authorization requests, access tokens, and refresh tokens. 
• When Data Is Sent: 
During the “Sign in with Google” authorization process. 
• API Scope Used: 
https://www.googleapis.com/auth/userinfo.email 
• Certificate Endpoint Used: 
https://www.googleapis.com/oauth2/v3/certs 
• Data Storage: 
OAuth access tokens are stored securely in the site’s WordPress database. 
• Terms of Service: 
https://developers.google.com/terms 
• Privacy Policy: 
https://policies.google.com/privacy
<h3>Privacy Policy</h3>
GSheetConnector for Core Lite uses Google APIs to allow users to connect their WordPress site with Google Sheets.
This plugin does not collect or transmit personal data to the plugin author or any external servers. Google account authentication and access to Google Sheets are handled securely using Google OAuth.
Access tokens required for Google authentication are stored securely in the site’s own WordPress database and are used only to perform actions requested by the site administrator.
The plugin only accesses Google Sheets and Google Drive data after explicit user consent during the Google authorization process.
No data is sold or shared with third parties, and no data is stored on the plugin author’s servers.

GSheetConnector for Core Lite

Connect WordPress core data (Pages, Posts, Users and Comments) with Google Sheets easily.

WPPOOL

azizultex

wpdarkmode

Sabbir Sam

sahabuddinsgr

Mahafuz

devdrarif

<a href="https://wppool.dev/google-sheets-to-wordpress-table-live-sync/" rel="nofollow ugc">Website</a> | <a href="https://wppool.dev/docs-category/how-to-use-sheets-to-wp-table/" rel="nofollow ugc">Documentations</a> | <a href="https://www.youtube.com/playlist?list=PLd6WEu38CQSyY-1rzShSfsHn4ZVmiGNLP" rel="nofollow ugc">Tutorials</a> | <a href="https://lnk.wppool.dev/9HneVn4" rel="nofollow ugc">Live Demo</a> | <a href="https://lnk.wppool.dev/JQ6ok1B" rel="nofollow ugc">Get PRO</a> | <a href="https://lnk.wppool.dev/cRzJg8f" rel="nofollow ugc">Join Community</a>
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! 🤩
<iframe loading="lazy" class="youtube-player" width="750" height="422" src="https://www.youtube.com/embed/1b9QXLg0JdQ?version=3&rel=0&showsearch=0&showinfo=1&iv_load_policy=1&fs=1&hl=en-US&autohide=2&wmode=transparent" allowfullscreen="true" style="border:0;" sandbox="allow-scripts allow-same-origin allow-popups allow-presentation allow-popups-to-escape-sandbox"></iframe>
Let’s grow, connect, and thrive together!
<ul>
<li>🤝 Join Our <a href="https://lnk.wppool.dev/cRzJg8f" rel="nofollow ugc">Facebook Community</a></li>
<li>🌐 Follow Us on <a href="https://x.com/wppool_" rel="nofollow ugc">X (Twitter)</a></li>
<li>🎥 Subscribe on <a href="https://www.youtube.com/@WPPOOL" rel="nofollow ugc">YouTube</a></li>
<li>👍 Like Our <a href="https://www.facebook.com/wppool.dev" rel="nofollow ugc">Facebook Page</a></li>
</ul>
To show your spreadsheet data in a WP table, connect your sheet to FlexTable and embed it on your site.
<iframe loading="lazy" class="youtube-player" width="750" height="422" src="https://www.youtube.com/embed/IkxD64CoNfw?version=3&rel=0&showsearch=0&showinfo=1&iv_load_policy=1&fs=1&hl=en-US&autohide=2&wmode=transparent" allowfullscreen="true" style="border:0;" sandbox="allow-scripts allow-same-origin allow-popups allow-presentation allow-popups-to-escape-sandbox"></iframe>
👁️ <a href="https://lnk.wppool.dev/9HneVn4" rel="nofollow ugc">View Demo</a> | 🚀 <a href="https://lnk.wppool.dev/JQ6ok1B" rel="nofollow ugc">Get PRO</a> | 🤝 <a href="https://lnk.wppool.dev/cRzJg8f" rel="nofollow ugc">Join Our Community</a>
<h3>LEARN MORE</h3>
<ul>
<li><a href="https://youtu.be/Un4ByhNpFRI?rel=0" rel="nofollow ugc">How to Add a New Table in FlexTable</a></li>
<li><a href="https://youtu.be/uGPO8qLUIq0?rel=0" rel="nofollow ugc">How to Use Shortcode to Display Table in FlexTable</a></li>
<li><a href="https://youtu.be/OYPG_wWHnjc?rel=0" rel="nofollow ugc">How to Create Tables with Gutenberg Block in FlexTable</a></li>
</ul>
<h3>😍 FlexTable Free Features</h3>
<ul>
<li>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. Sync up to 100 rows for FREE. </li>
<li>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.</li>
<li>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.</li>
<li>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.</li>
<li>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.</li>
<li>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.</li>
<li>Merge Cells: If your spreadsheet has merged cells, you can enable this feature to improve the appearance and clarity.</li>
<li>Cache Table for Faster Loading: Enabling this option can improve your table loading speed.</li>
<li>Prevent frequent cache updates for faster table loading: Optimized caching helps your tables load faster and reduces unnecessary API requests.</li>
<li>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</li>
<li>2 Table Themes: Easily customize the appearance by choosing one of the provided themes (Simple and Simple on Dark). </li>
<li>Duplicate Tables: Easily generate duplicates without manually recreating them from scratch. Save time and maintain consistency across multiple tables.</li>
<li>Table Description: Communicate with your site visitors with clear descriptions that describe the purpose of your tables. Easily convey important information through the description.</li>
<li>Cell Formatting Style: Choose between expanded and wrapped table styles.</li>
<li>Rows to Show Per Page: Choose the number of rows you want to display per page. </li>
<li>Table Title: Enable this feature to show the title in the h3 tag in your website front-end. Rename your tables as you want. </li>
<li>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. </li>
<li>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.</li>
<li>Search Bar: Quickly locate data using the built-in search bar for better usability.</li>
<li>Pagination Support: Access in-built table pagination support. Order your data in a simple manner of sequential pages that are contextually connected.</li>
<li>Asynchronous Loading: Enable this feature to load the table in the front end after loading all content with a pre-loader.</li>
<li>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.</li>
<li>Multisite Support: With spreadsheet to Table Multisite support, share sync features across your multisite network.</li>
</ul>
👁️ <a href="https://lnk.wppool.dev/9HneVn4" rel="nofollow ugc">View Demo</a> | 🚀 <a href="https://lnk.wppool.dev/JQ6ok1B" rel="nofollow ugc">Get PRO</a> | 🤝 <a href="https://lnk.wppool.dev/cRzJg8f" rel="nofollow ugc">Join Our Community</a>
<h3>⚡ Experience the Full Potential with FlexTable Pro</h3>
<ul>
<li>Unlimited Table Creation: Create data-tables without limits.</li>
<li>Unlimited Row Sync: Fetch as many rows as you want to show.</li>
<li>Import Styles from Google Sheets: Import cell background color & cell font color, font size, font widget, font family & all other styles from connected sheet.</li>
<li>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.</li>
<li>Export Table: Exporting via CSV, Excel, PDF, JSON, Print, and Copy is easy on this plugin.</li>
<li>Tab Management: Manage all the tables in 1 place as a tab. This feature enables you to effectively manage your data from multiple sheets.</li>
<li>Vertical Scroll/Sticky Header: This feature allows you to scroll vertically. Activating this feature will allow the table to behave as a sticky header.</li>
<li>6 Premium Table Themes: Switch your table’s look and feel. Each of the themes is created to provide a modern and responsive experience.</li>
<li>Customize Table Theme: Personalize header, body, and border colors.</li>
<li>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.</li>
<li>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.</li>
<li>Horizontal Dragging: Once you enable this feature your users will be able to drag the table horizontally.</li>
<li>Hide Column: Hide your Sheet’s column on desktop screen OR mobile screens.</li>
<li>Hide Row: Hide your Sheet’s rows based on your custom row selection.</li>
<li>Hide Cell: Hide your Sheet’s cell data based on your custom cell selection.</li>
<li>Optimized Loading: By enabling this feature, the scripts will load only on the relevant pages/posts in your website where the table is added.</li>
<li>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.</li>
<li>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.</li>
<li>Always-on support: We have a dedicated and hardworking team. Get support for any issues with Flex Table.</li>
</ul>
👁️ <a href="https://lnk.wppool.dev/9HneVn4" rel="nofollow ugc">View Demo</a> | 🚀 <a href="https://lnk.wppool.dev/JQ6ok1B" rel="nofollow ugc">Get PRO</a> | 🤝 <a href="https://lnk.wppool.dev/cRzJg8f" rel="nofollow ugc">Join Our Community</a>
<h3>✨ AI Powered FlexTable</h3>
Transform static tables into intelligent, conversational experiences that understand and respond to your users’ needs. It delivers two powerful capabilities to enhance data accessibility:
<ol>
<li>Instant AI Summary – One-click comprehensive overviews of your entire dataset</li>
<li>Interactive AI Table Assistant – Conversational Q&A for deep data exploration</li>
</ol>
⚡ 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.
<ul>
<li>
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.
</li>
<li>
Instant Summary: You can generate and save the summary in advance. Visitors will see it immediately. Suitable for tables with mostly static data.
</li>
</ul>
🤖 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:
<ul>
<li>“What’s the average value in this column?”</li>
<li>“Show me entries from last month.”</li>
<li>“Which row has the highest sales?”</li>
</ul>
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.
<h3>💼 FlexTable in Academic and Administrative Management</h3>
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:
<ul>
<li>Let users search records by ID, grade level, or class section.</li>
<li>Allow filtering of teacher profiles by department or subject.</li>
<li>Enable front-end lookups for class schedules by time or instructor.</li>
<li>Provide a searchable staff directory with role or department filters.</li>
<li>Display exam results filtered by student name or course.</li>
</ul>
<iframe loading="lazy" class="youtube-player" width="750" height="422" src="https://www.youtube.com/embed/GLDIL1JT-J8?version=3&rel=1&showsearch=0&showinfo=1&iv_load_policy=1&fs=1&hl=en-US&autohide=2&wmode=transparent" allowfullscreen="true" style="border:0;" sandbox="allow-scripts allow-same-origin allow-popups allow-presentation allow-popups-to-escape-sandbox"></iframe>
👁️ <a href="https://lnk.wppool.dev/9HneVn4" rel="nofollow ugc">View Demo</a> | 🚀 <a href="https://lnk.wppool.dev/JQ6ok1B" rel="nofollow ugc">Get PRO</a> | 🤝 <a href="https://lnk.wppool.dev/cRzJg8f" rel="nofollow ugc">Join Our Community</a>
<h3>🔥 More Awesome Plugins</h3>
If you like FlexTable, then consider checking out our other awesome projects:
<ul>
<li>
🌓 <a href="https://wordpress.org/plugins/wp-dark-mode/" rel="ugc">WP Dark Mode</a>: 
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.
</li>
<li>
🔄 <a href="https://wordpress.org/plugins/stock-sync-with-google-sheet-for-woocommerce/" rel="ugc">FlexStock</a> – 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.
</li>
<li>
🛒 <a href="https://wordpress.org/plugins/order-sync-with-google-sheets-for-woocommerce/" rel="ugc">FlexOrder</a> – 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!
</li>
<li>
💬 <a href="https://wordpress.org/plugins/social-contact-form/" rel="ugc">FormyChat</a> – 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
</li>
<li>
🎁 <a href="https://wordpress.org/plugins/echo-rewards/" rel="ugc">EchoRewards</a> – 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.
</li>
</ul>
<h3>Privacy Policy</h3>
Flex Table uses <a href="https://appsero.com" rel="nofollow ugc">Appsero</a> 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 <a href="https://appsero.com/privacy-policy/" rel="nofollow ugc">Appsero collects and uses this data</a>.
Additionally, read the WPPOOL <a href="https://wppool.dev/privacy-policy/" rel="nofollow ugc">privacy policy</a>.

FlexTable – Data Table Sync with Google Sheets


I reported the email as spam and am not moving forward with exploring this plugin. Maybe somewhere in there it said that I was agreeing to this but I do not believe plugins should obfuscate this. Offer to have me join a mailing list by clicking a button, sure. Do not auto subscribe because I installed.


added me to mailing list without my permission


While the plugin is very intuitive, there are advanced capabilities that I was struggling with. I submitted a support request and within hours the support team had not only resolved my inquiry, but they created a detailed overview of the specific capability I was interested in. Definitely above and beyond!


Incredible Support

Turn Google Sheets into live WordPress tables. Embed, sync, and customize data instantly with search, filters, and styling - no coding needed.

GSheetConnector for Core Lite vs FlexTable – Data Table Sync with Google Sheets