WesternDeal

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:
<ul>
<li>Posts </li>
<li>Pages </li>
<li>Users </li>
<li>Comments 
➜ The plugin will create separate tabs inside the selected spreadsheet.</li>
</ul>
</li>
<li>
Step 4: Configure Sheet Headers (Columns) 
➜ Go to Google Sheet Headers (Column Name) section. 
➜ Choose the header group:
<ul>
<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>
</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:
<ul>
<li>Posts </li>
<li>Pages </li>
<li>Users </li>
<li>Comments 
➜ Save the feed and click Edit.</li>
</ul>
</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:
<ul>
<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>
</ul>
</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.

Freemius

javmah

<h4>This Plugin Integrates, Automates, Sync & displays Google Sheets with WordPress and its most popular plugins.</h4>
WordPress events like new user registration, delete user, new post, update post, new page, user login, user logout, new database table row along with <a href="https://wordpress.org/plugins/advanced-custom-fields/" rel="ugc">Advanced Custom Fields</a> fields. This plugin also integrates <a href="https://wordpress.org/plugins/woocommerce/" rel="ugc">WooCommerce</a>, <a href="https://wordpress.org/plugins/contact-form-7/" rel="ugc">Contact form 7</a>, <a href="https://wordpress.org/plugins/ninja-forms/" rel="ugc">ninja form</a>, <a href="https://wordpress.org/plugins/formidable/" rel="ugc">Formidable</a>, <a href="https://wordpress.org/plugins/fluentform/" rel="ugc">Fluent forms</a>, <a href="https://wordpress.org/plugins/wpforms-lite/" rel="ugc">WPform</a>, <a href="https://www.gravityforms.com/" rel="nofollow ugc">gravity form</a>, <a href="https://wordpress.org/plugins/forminator/" rel="ugc">forminator form</a> submission events with <a href="https://www.google.com/sheets/about/" rel="nofollow ugc">Google Sheets</a>.
This plugin also UPDATES / CREATES WordPress posts, pages, users, WooCommerce products, WooCommerce orders, and Database table rows from Google Sheets. *
<pre><code>Spreadsheet Integration is the First & Only Google service 
account Authenticated plugin in the WordPress plugin 
repository. Now you don't have to give permission to 3rd 
party, More secure & reliable. Just share your Spreadsheet 
with your own service account. No need expensive Zapier or 
ITTF for WordPress Google Spreadsheet Integration.
</code></pre>
<h3>🔝 KEY FEATURES</h3>
<ol>
<li>
Unlimited integrations: Create as many integrations as you want and collect all the data you need with as many fields you want.
</li>
<li>
One click Update WordPress site: Just click your Google Spreadsheets to update WordPress Post and Page ! Awesome !!
</li>
<li>
Privacy and Security: Very Secure, just share your google sheet with service account email address, no 3rd party authentication access, the private sheet only.
</li>
<li>
Drop Down & Select: Build the integrations of your dream with its fully featured Drop Down & Select options.
</li>
<li>
Auto Google Spreadsheet & Worksheet: No need to copy or past sheet name just select more safe.
</li>
<li>
No restrictions on Event fields : There is No restrictions on Event fields, you can pass your won text via fields.
</li>
<li>
One Click Google Spreadsheet Columns title Create : just click to create integrated sheet column titles.
</li>
<li>
Auto-sync : Auto-sync Google sheet data and display data as table content in your post or page.
</li>
<li>
Google <a href="https://cloud.google.com/iam/docs/service-accounts" rel="nofollow ugc">service account</a> Authentication : Spreadsheet Integration is the first & only one service account Authenticated plugin in the WordPress plugin repository .
</li>
</ol>
<blockquote>
‘The professional version of this plugin is also the Best plugin for integrating WooCommerce with Google Sheets. It supports almost all data sources of WooCommerce. You can easily sync WooCommerce event data to Google Sheets and be able to bulk update wooCommerce products from Google Sheets. You can use the professional version for 7 days as a free trial.’
</blockquote>
<h3>🏆 STANDARD INTEGRATIONS EVENTS</h3>
<ul>
<li>
Update WordPress Post & Page from Google Sheets.
</li>
<li>
Contact form 7 forms submission to Google Sheets.
</li>
<li>
WordPress New user registration to Google Sheets.
</li>
<li>
WordPress User Profile Updates to Google Sheets.
</li>
<li>
WordPress User Login to Google Sheets.
</li>
<li>
WordPress User Logout to Google Sheets.
</li>
<li>
WordPress Delete User Profile to Google Sheets.
</li>
<li>
WordPress New post to Google Sheets.
</li>
<li>
WordPress update post to Google Sheets.
</li>
<li>
WordPress New page to Google Sheets.
</li>
<li>
WordPress New Comment to Google Sheets.
</li>
<li>
WordPress Edit Comment to Google Sheets.
</li>
<li>
WooCommerce New order to Google Sheets (not all fields).
</li>
<li>
WooCommerce Order status change to Google Sheets (not all fields ).
</li>
<li>
WooCommerce new product to Google Sheets (most of the Fields not all).
</li>
<li>
Display Google sheet on your WordPress Page and Post as a searchable and sortable table with daily auto sync.
</li>
</ul>
Thanks: 💖 Heartiest Gratitude to all of my users who inspired me and suggest me and compliment me in many ways, you guys are Awesome. Without yours support and love it was impossible to maintain this huge codebase. Please accept my sincere thanks.
<h3>Creating Integration</h3>
<iframe loading="lazy" class="youtube-player" width="750" height="422" src="https://www.youtube.com/embed/Cr0D_zU6adw?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>
<h3>Update / Create WordPress data from Google Sheet</h3>
<iframe loading="lazy" class="youtube-player" width="750" height="422" src="https://www.youtube.com/embed/84gTttWN4vo?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>
<h3>Google API and Service account Creation</h3>
<iframe loading="lazy" class="youtube-player" width="750" height="422" src="https://www.youtube.com/embed/ylUE1t3bkqs?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>
<h3>🔥 ADVANCE PROFESSIONAL INTEGRATIONS</h3>
<ol>
<li>
<a href="https://wordpress.org/plugins/woocommerce/" rel="ugc">WooCommerce Google Sheet Connect[PRO]</a>: This plugin syncs WooCommerce new order, WooCommerce Orders status Change, WooCommerce new Product and Product information update data to google sheet.
</li>
<li>
<a href="https://wordpress.org/plugins/woocommerce/" rel="ugc">WooCommerce Product and Order Update from Google Sheets [PRO]</a>: One click update your WooCommerce Products and Orders from Google Sheet!
</li>
<li>
<a href="https://developer.wordpress.org/plugins/metadata/" rel="nofollow ugc">wordPress Meta data [PRO] </a>: In this plugins Professional version, you can able to integrate WordPress Metadata as an event data source! Wow
</li>
<li>
<a href="https://developer.wordpress.org/plugins/metadata/" rel="nofollow ugc">wordPress Meta data update from Google sheet [PRO] </a>: Professional version supports update Meta data from Google sheet.
</li>
<li>
<a href="https://www.gravityforms.com/" rel="nofollow ugc">Gravity Forms [PRO] </a>: This plugin sync gravity forms form submission data to google sheet.
</li>
<li>
<a href="https://wordpress.org/plugins/advanced-custom-fields/" rel="ugc">ACF- Advanced Custom Fields [PRO]</a>: Spreadsheet integration supports ACF data fields.
</li>
<li>
<a href="https://wordpress.org/plugins/ninja-forms/" rel="ugc">ninja form [PRO]</a>: Spreadsheet Integration supports ninja forms form submission data to google sheet.
</li>
<li>
<a href="https://wordpress.org/plugins/formidable/" rel="ugc">Formidable [PRO]</a>: Spreadsheet Integration supports Formidable forms form submission data to google sheet.
</li>
<li>
<a href="https://wordpress.org/plugins/wpforms-lite/" rel="ugc">WPform [PRO]</a>: Sync WP form submission data to google sheet.
</li>
<li>
<a href="https://wordpress.org/plugins/weforms/" rel="ugc">weForms [PRO]</a>: This plugin also syncs weForm form submission data to google sheet.
</li>
<li>
<a href="https://wordpress.org/plugins/forminator/" rel="ugc">Forminator [PRO]</a>: This plugin also syncs Forminator form submission data to google sheet.
</li>
<li>
<a href="https://wordpress.org/plugins/fluentform/" rel="ugc">Fluent Forms [PRO]</a>: This plugin also syncs Fluent Forms submission data to google sheet.
</li>
<li>
<a href="https://wordpress.org/plugins/custom-post-type-ui/" rel="ugc">Custom Post Type UI [PRO]</a>: This plugin plugin supports custom post type UI as Event source.
</li>
<li>
<a href="https://wordpress.org/plugins/custom-post-type-ui/" rel="ugc">Custom Post Type update from Google sheet [PRO]</a>: One click update your custom post type from connected google sheet.
</li>
<li>
<a href="https://codex.wordpress.org/Database_Description" rel="nofollow ugc">wordPress database table row [PRO] </a>: Professional version supports wordPress database table row sync to Google sheets. One click update / insert your Google sheet data to wordPress database.
</li>
<li>
[wordPress create / update USER [PRO]]: Professional version supports creating / updating user information from google sheet.*
</li>
<li>
[more option on Google sheet sync [PRO]]: Professional version supports More Frequency on google sheet sync and display as a Table in WordPress Page and Post.
</li>
</ol>

WPGSI: Spreadsheet Integration

This would probably be a five star plugin if it wasn't for the upgrade nags in the admin interface. Please don't hijack the admin interface. Put your upgrade notices inside the settings page.

EDIT: Can't reproduce this because I have dismissed the notice already. I will give you the benefit of the doubt. Maybe I just imagined it.

good but has unnecessary admin notifications


This plugin is great. It is so powerful & is very useful for managing a large amount of posts. I had a few issues, and the plugin developer was able to quickly answer and solve my issues for me. I am so thankful for the plugin developers talent. 


Excellent plugin and support!!

Google sheet two-way sync 🔄 WordPress | WooCommerce | Contact form 7 | DB table | Google sheet as a Table.

GSheetConnector for Core Lite vs WPGSI: Spreadsheet Integration