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.

Creative Werk Designs

Arpit G Shah

<a href="https://www.wpsyncsheets.com/wpsyncsheets-for-contact-form-7/?utm_source=wp-repo&utm_campaign=wpsyncsheets-for-contact-form-7&utm_medium=description" rel="nofollow ugc">WPSyncSheets For Contact Form 7</a> automatically exports and syncs your Contact Form 7(CF7) submissions to a single Google Sheet while securely saving every entry in your WordPress database. Contact Form 7 Google Sheets Connector helps you to get real-time Google Sheets integration with built-in database storage to prevent data loss. Manage all your Contact Form 7 database(CFDB7) entries in one place with powerful, reliable, and easy-to-use features.
If you are looking for <a href="https://www.wpsyncsheets.com/wpsyncsheets-for-contact-form-7/?utm_source=wp-repo&utm_campaign=wpsyncsheets-for-contact-form-7&utm_medium=description" rel="nofollow ugc">Google Sheets and Database Addon for Contact Form 7</a> this addon is the best choice. It lets you save and manage form submissions directly in your WordPress database and sync Contact Form 7 entries to Google Sheets.
<a href="https://demo.wpsyncsheets.com/wpsyncsheets-for-contact-form-7/" rel="nofollow ugc">Demo</a> | <a href="https://docs.google.com/spreadsheets/d/1JaU6HDX4AhYkMrCsDuOTds-KLlFoHW7S27Ojq9hJAFE/edit?gid=709624087#gid=709624087&range=A340" rel="nofollow ugc">Sample Sheets</a> | <a href="https://docs.wpsyncsheets.com/wpssc-introduction/" rel="nofollow ugc">Docs</a> | <a href="https://wordpress.org/support/plugin/contactsheets-lite/" rel="ugc">Support</a> | <a href="https://www.wpsyncsheets.com/wpsyncsheets-for-contact-form-7/?utm_source=wp-repo&utm_campaign=wpsyncsheets-for-contact-form-7&utm_medium=description" rel="nofollow ugc">Pro</a>
<h3>WPSyncSheets For Contact Form 7 Features</h3>
<ul>
<li>
<a href="https://www.wpsyncsheets.com/contact-form-7-to-google-sheets-integration/?utm_source=wp-repo&utm_campaign=wpsyncsheets-for-contact-form-7&utm_medium=description" rel="nofollow ugc">Contact Form 7 to Google Sheets Integration</a> 
Connect Contact Form 7 with Google Sheets and save form entries to database in real time. CF7 Google Sheets Connector is also create a new sheet or select an existing one, add new tabs automatically, and map which form fields to save. WPSyncSheets For Contact Form 7 acts as a secure connector and can store data like name, email, IP address, page URL, and submission date. Data is synced instantly using secure Google authentication, and no Google account or Drive data is stored by the plugin author.
</li>
<li>
Save Form Submissions in Database 
Database Addon for Contact Form 7 lets you save Contact Form 7 submissions to your WordPress database. It also stores all the form entries in a single optimized database table and Google Sheets. It has ability to displays the entry count for each form with search and filter options. Each contact form 7 submission has its own entry detail page to add notes, show submission date, shop page url and many more.
</li>
<li>
Export Contact Form 7 Entries to Google Sheets, CSV & Excel 
CF7 Google Sheet Connector is the bridge between WordPress plugin Contact Form 7 and Google Sheets. It can help you to export all your form submissions to Excel and CSV which has already stored within the WordPress database. WPSyncSheets For Contact Form 7 plugin has also ability to export entries with date filter (Today, Last 7 Days, This Month, Custom Range) option and form wise cf7 entries export.
</li>
<li>
Modern & Elegant Dashboard for Easy CF7 Entry Management 
WPSyncSheets For Contact Form 7 includes a clean dashboard inside WordPress admin that shows all Contact Form 7 forms and their connection status with Google Sheets or Save to Database. You can manage all integrations from CF7 → Google Sheets or Database.
</li>
</ul>
<h3>Upgrade to <a href="https://www.wpsyncsheets.com/wpsyncsheets-for-contact-form-7/?utm_source=wp-repo&utm_campaign=wpsyncsheets-for-contact-form-7&utm_medium=description" rel="nofollow ugc">Pro Features</a></h3>
<blockquote>
✅ Edit Sheet Headers – Rename spreadsheet columns from plugin settings 
✅ Sort Sheet Headers – Reorder columns to match your desired field layout 
✅ Payment Status Control – Sync entries only after PayPal or Stripe payment is successful 
✅ Save File Uploads – Store uploaded files and add clickable links in the spreadsheet 
</blockquote>
You can check out the <a href="https://docs.wpsyncsheets.com/wpssc-setup-guide/?utm_source=wp-repo&utm_campaign=wpsyncsheets-for-contact-form-7&utm_medium=description" rel="nofollow ugc">user guide</a> to easily setup the plugin or watch the below video on <a href="https://www.wpsyncsheets.com/contact-form-7-to-google-sheets/?utm_source=wp-repo&utm_campaign=wpsyncsheets-for-contact-form-7&utm_medium=description" rel="nofollow ugc">How to Export Contact Form 7 Entries</a>
<iframe loading="lazy" class="youtube-player" width="750" height="422" src="https://www.youtube.com/embed/DLkh2J6lbqE?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>Related Import-Export Google Sheets Plugins</h3>
<a href="https://www.wpsyncsheets.com/?utm_source=wp-repo&utm_campaign=wpsyncsheets-for-contact-form-7&utm_medium=description" rel="nofollow ugc">WPSyncSheets</a> connects WordPress and WooCommerce platforms with Google Sheets. Our mission is to help businesses automate data transfer, simplify operations, and reduce repetitive tasks through real-time, two-way data synchronization.
🔸 <a href="https://www.wpsyncsheets.com/wpsyncsheets-for-woocommerce/?utm_source=wp-repo&utm_campaign=wpsyncsheets-for-contact-form-7&utm_medium=description" rel="nofollow ugc">WPSyncSheets For WooCommerce</a>: Import Export WooCommerce Orders, Products, Customers & Coupons.
🔸 <a href="https://www.wpsyncsheets.com/wpsyncsheets-for-gravity-forms/?utm_source=wp-repo&utm_campaign=wpsyncsheets-for-contact-form-7&utm_medium=description" rel="nofollow ugc">WPSyncSheets For Gravity Forms</a>: Send Gravity Forms submissions to Google Sheets in real-time.
🔸 <a href="https://www.wpsyncsheets.com/wpsyncsheets-for-core/?utm_source=wp-repo&utm_campaign=wpsyncsheets-for-contact-form-7&utm_medium=description" rel="nofollow ugc">WPSyncSheets For Core</a>: Import, Export & Bulk Edit WordPress Posts and Pages via Google Sheets.
🔸 <a href="https://www.wpsyncsheets.com/wpsyncsheets-for-elementor/?utm_source=wp-repo&utm_campaign=wpsyncsheets-for-contact-form-7&utm_medium=description" rel="nofollow ugc">WPSyncSheets For Elementor</a>: Map & Sync Elementor Form Entries to Google Sheets in Real Time.
🔸 <a href="https://www.wpsyncsheets.com/wpsyncsheets-for-document-library-pro/?utm_source=wp-repo&utm_campaign=wpsyncsheets-for-contact-form-7&utm_medium=description" rel="nofollow ugc">WPSyncSheets For Document Library Pro</a>: Sync Document Library Pro documents with Google Sheets.
🔸 <a href="https://www.wpsyncsheets.com/wpsyncsheets-for-wpforms/?utm_source=wp-repo&utm_campaign=wpsyncsheets-for-contact-form-7wpsyncsheets-for-contact-form-7&utm_medium=description" rel="nofollow ugc">WPSyncSheets For WPForms</a>: Map & Sync WPForms Entries to Google Sheets.
🔸 <a href="https://www.wpsyncsheets.com/wpsyncsheets-for-ninjaforms/?utm_source=wp-repo&utm_campaign=wpsyncsheets-for-contact-form-7&utm_medium=description" rel="nofollow ugc">WPSyncSheets For Ninja Forms</a>: Automatically Sync Ninja Form Entries to Google Sheets.
🔸 <a href="https://www.wpsyncsheets.com/wpsyncsheets-for-fluent-forms/?utm_source=wp-repo&utm_campaign=wpsyncsheets-for-contact-form-7&utm_medium=description" rel="nofollow ugc">WPSyncSheets For Fluent Forms</a>: Sync Fluent Form Entries to Google Sheets in Real Time.
🔸 <a href="https://www.wpsyncsheets.com/wpsyncsheets-for-formidable-forms/?utm_source=wp-repo&utm_campaign=wpsyncsheets-for-contact-form-7&utm_medium=description" rel="nofollow ugc">WPSyncSheets For Formidable Forms</a>: Automatically Map and Sync Formidable Form Entries to Google Sheets.

WPSyncSheets For Contact Form 7 – CF7 Google Sheets Connector & Save to Database


The plugin support was better than I expected and resolved my issues within half an hour by updating the patched plugin.


Immediate and effective support

Connect Contact Form 7 submissions to Google Sheets to sync your form entries and save all cf7 forms submitted data to the database.

GSheetConnector for Core Lite vs WPSyncSheets For Contact Form 7 – CF7 Google Sheets Connector & Save to Database