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.

GSheetConnector for WooCommerce is a powerful and easy-to-use Google Sheets integration plugin that connects your WooCommerce store directly with Google Sheets. Automatically sync WooCommerce orders, products, customers, and more into a Google Spreadsheet to organize, analyze, and manage your store data efficiently.
With real-time data sync, every new WooCommerce order is instantly added as a new row in your selected Google Sheet. You can also create separate tabs based on order status (Processing, Completed, Pending, Cancelled, Refunded) for better tracking and reporting.
This plugin is perfect for store owners, marketing teams, and accounting departments who want a simple and reliable way to maintain WooCommerce order data for reporting, analytics, inventory planning, and team collaboration.
<h3>🚀 Why Use This Plugin?</h3>
➜ Real-time sync of WooCommerce orders to Google Sheets 
➜ Sync Products, Product Variations, Coupons, and Customers 
➜ Automatically create separate sheets tabs based on order status 
➜ Customize and organize column headers in Google Sheets 
➜ Simple and secure Google account authentication 
➜ Debug logs for quick troubleshooting
<ul>
<li><a href="https://www.gsheetconnector.com/docs/woocommerce-gsheetconnector" rel="nofollow ugc">Documentation</a> | <a href="https://www.gsheetconnector.com/support" rel="nofollow ugc">Support</a> | <a href="https://woogsheets.gsheetconnector.com/" rel="nofollow ugc">Demo</a> | <a href="https://www.gsheetconnector.com/woocommerce-google-sheet-connector-pro" rel="nofollow ugc">WooCommerce Google Sheet Connector PRO</a></li>
</ul>
<h3>🧪 Check Live Demo</h3>
Demo Link: <a href="https://woogsheets.gsheetconnector.com/" rel="nofollow ugc">Open Demo</a>
Google Sheet (View Submitted Data): <a href="https://docs.google.com/spreadsheets/d/1BLkcJLk8bQvSSuIRPHXLDnSNBNmrEVGZ2o44x5uZVlI/edit#gid=1091708451" rel="nofollow ugc">View Sheet</a>
<h4>How to Use this Plugin</h4>
<ul>
<li>
Step: 1 – <a href="https://sheets.google.com/" rel="nofollow ugc">In Google Sheets</a> 
➜ Log into your Google Sheets. 
➜ Create a new sheet and name it. ( You can also select existing sheet while setting the connection as per Step 3).
</li>
<li>
Step: 2 – In WordPress Admin 
➜ Navigate to WooCommerce > Google Sheet > Integration Tab 
➜ Authenticate with Google using new “Google Access Code” while clicking on “Get Code” 
➜ Make Sure to ALLOW Google Permissions for Google Drive and Google Sheets and then copy the code and paste in Google Access Code field, and Hit Save & Authenticate. 
➜ Now fetch the sheet details by clicking “Click here to fetch Sheet details to be set at WooCommerce settings.”
</li>
<li>
Step: 3 – Connect with Google Sheet 
➜ Navigate to WooCommerce > Google Sheet > WooCommerce Data Settings. 
➜ Select the appropriate Sheet from the “Google Sheet Name” dropdown box. 
➜ Select WooCommerce Order Status to create Sheet Tabs and add headers to your selected Google Sheet. 
➜ Lastly test by ordering any product and putting it to a different order states ( Processing, Hold etc).
</li>
</ul>
<h3>🚀 Pro Plugin Features</h3>
➜ Sync all WooCommerce orders (default + custom order statuses) to Google Sheets in real time. 
➜ Sync all Products, Product Variations, Coupons, and Customers. 
➜ Sync existing orders, missed entries, and data based on order status or date range. 
➜ Cron-based automatic syncing at user-defined time intervals. 
➜ Bi-directional sync for Orders, Products, Variations, Coupons, and Customers (Google Sheet → WooCommerce). 
➜ Sync Custom Fields and Meta Fields (including third-party plugin data). 
➜ Choose from three different integration methods based on organizational needs. 
➜ Create multiple feeds and send data to different Google Sheets as required. 
➜ Create Individual feeds with individual sheets for Orders, Products, Products Variations, Users & Coupons 
➜ 2-way Sync – Send data from Google Sheets to your WooCommerce store via the connected sheet. 
➜ Easy tracking and monitoring through advanced error logs. 
➜ Freeze headers, add header color, and apply odd/even row background colors in Google Sheets. 
➜ Manage data row structure order-wise or product-wise. 
➜ Filter and sync data based on selected product categories. 
➜ Add and customize header names as needed. 
➜ Compatible with 50+ popular WooCommerce add-on plugins. 
<a href="https://www.gsheetconnector.com/wc-gsheetconnector-pro?wp-repo" rel="nofollow ugc">🔒 Upgrade to Pro? Get it Now</a>
<h3>🔗 Other Google Sheets Integrations</h3>
Contact Forms to Google Sheet Integration 
<a href="https://www.gsheetconnector.com/cf7-google-sheet-connector-pro?utm_source=wordpress.org&utm_medium=referral&utm_campaign=WPGSC&utm_content=plugin+repos+description" rel="nofollow ugc">CF7 GSheetConnector Pro</a> 
<a href="https://www.gsheetconnector.com/wpforms-google-sheet-connector-pro?utm_source=wordpress.org&utm_medium=referral&utm_campaign=WPGSC&utm_content=plugin+repos+description" rel="nofollow ugc">WPForms GSheetConnector Pro</a> 
<a href="https://www.gsheetconnector.com/gravity-forms-google-sheet-connector?utm_source=wordpress.org&utm_medium=referral&utm_campaign=WPGSC&utm_content=plugin+repos+description" rel="nofollow ugc">Gravity Forms GSheetConnector Pro</a> 
<a href="https://www.gsheetconnector.com/ninja-forms-google-sheet-connector-pro?utm_source=wordpress.org&utm_medium=referral&utm_campaign=WPGSC&utm_content=plugin+repos+description" rel="nofollow ugc">Ninja Forms GSheetConnector pro</a> 
<a href="https://www.gsheetconnector.com/forminator-forms-google-sheet-connector-pro?utm_source=wordpress.org&utm_medium=referral&utm_campaign=WPGSC&utm_content=plugin+repos+description" rel="nofollow ugc">Forminator Forms GSheetConnector Pro</a> 
<a href="https://www.gsheetconnector.com/formidable-forms-google-sheet-connector-pro?utm_source=wordpress.org&utm_medium=referral&utm_campaign=WPGSC&utm_content=plugin+repos+description" rel="nofollow ugc">Formidable Forms GSheetConnector Pro</a> 
<a href="https://www.gsheetconnector.com/fluent-forms-google-sheet-connector-pro?utm_source=wordpress.org&utm_medium=referral&utm_campaign=WPGSC&utm_content=plugin+repos+description" rel="nofollow ugc">Fluent Forms GSheetConnector Pro</a>
eCommerce to Google Sheet Integration 
<a href="https://www.gsheetconnector.com/woocommerce-google-sheet-connector-pro?utm_source=wordpress.org&utm_medium=referral&utm_campaign=WPGSC&utm_content=plugin+repos+description" rel="nofollow ugc">WooCommerce GSheetConnector PRO</a> 
<a href="https://wordpress.org/plugins/gsheetconnector-easy-digital-downloads?utm_source=wordpress.org&utm_medium=referral&utm_campaign=WPGSC&utm_content=plugin+repos+description" rel="ugc">GSheetConnector PRO for Easy Digital Downloads</a>
Page Builders to Google Sheet Integration 
<a href="https://www.gsheetconnector.com/elementor-forms-google-sheet-connector-pro?utm_source=wordpress.org&utm_medium=referral&utm_campaign=WPGSC&utm_content=plugin+repos+description" rel="nofollow ugc">Elementor Forms Google Sheet Connector</a> 
<a href="https://www.gsheetconnector.com/avada-forms-google-sheet-connector-pro?utm_source=wordpress.org&utm_medium=referral&utm_campaign=WPGSC&utm_content=plugin+repos+description" rel="nofollow ugc">Avada Forms Google Sheet Connector</a> 
<a href="https://www.gsheetconnector.com/divi-forms-db-google-sheet-connector-pro?utm_source=wordpress.org&utm_medium=referral&utm_campaign=WPGSC&utm_content=plugin+repos+description" rel="nofollow ugc">DIVI Forms Google Sheet Connector</a> 
<a href="https://www.gsheetconnector.com/gsheetconnector-for-core?utm_source=wordpress.org&utm_medium=referral&utm_campaign=WPGSC&utm_content=plugin+repos+description" rel="nofollow ugc">GSheetConnector For Core</a>

GSheetConnector for WooCommerce – Send your Orders and Products to Google Sheet in Real-Time

WooCommerce Google Sheet Connector automatically syncs orders, products, customers, coupons, and variations to Google Sheets.

GSheetConnector for Core Lite vs GSheetConnector for WooCommerce – Send your Orders and Products to Google Sheet in Real-Time