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.

wpdesk

Bartek

dyszczo

★★★★★
THE BEST AND FREE GOOGLE SHEETS INTEGRATION FOR WOOCOMMERCE
ShopMagic for Google Sheets will let you connect your WordPress with Google Sheets. You’ll be able to export all the data from WooCommerce orders to Google Sheets ⭐.
No need to use any external or 3rd party software to establish a connection between your WordPress and Google Sheets. Thanks to our plugin, it is set directly between your store and Google Sheets.
You can decide to which spreadsheet your data should be exported. You can also select rows and tabs of your document.
All of that is available just within a few clicks – no burdensome configuration is needed. Connect your Google account with ShopMagic and you will be ready to save any data to all of your spreadsheets.
When installed and activated, there will be a new action type called Add row to Google Sheets. Select it, and choose the sheet from your account to integrate.
<a href="https://shopmagic.app/sk/shopmagic-for-google-sheets-rm-blog/" rel="nofollow ugc">See the whole process on our blog → 😊</a>
<h3>SHOPMAGIC FOR GOOGLE SHEETS USE CASES</h3>
Every time a new order will be created in WooCommerce, ShopMagic will export its data to the new row of a spreadsheet of your choice. However, it is not the only way how you can use our plugin.
ShopMagic for Google Sheets will let you:
<ul>
<li>Save any CF7 form submission in WordPress or WooCommerce</li>
<li>Add a review to your spreadsheets database</li>
<li>Create a list of your users updated in realtime</li>
<li>Send the data from your WordPress forms and WooCommerce orders to Google Sheets</li>
<li>Gather WordPress blog posts, comments, subscriptions, and bookings in spreadsheets</li>
</ul>
Why choose ShopMagic for Google Sheets:
<ul>
<li>Ultra-fast configuration</li>
<li>Free WooCommerce and Google Sheets integration</li>
<li>No need to use external software</li>
<li>Multiple integrations</li>
<li>90+ placeholders</li>
<li>The possibility of further extending with ContactForm 7 or Gravity Forms</li>
<li>Sending data from WordPress and WooCommerce to Google Sheets with a few clicks</li>
</ul>
When connected, you can use choose any of your Sheets in the automation settings.
★★★★★
<h3>SHOPMAGIC FOR GOOGLE SHEETS IS AVAILABLE FOR FREE</h3>
That’s right. We believe that everyone should have the possibility to benefit from modern marketing strategies and solutions. Especially in the current world situation. That’s why we are giving this add-on for free, to every WooCommerce store owner. It is the fourth ShopMagic add-on which is available for free. The rest are:
<ul>
<li><a href="https://wordpress.org/plugins/shopmagic-abandoned-carts/" rel="ugc">ShopMagic Abandoned Carts</a>, designed to recover WooCommerce abandoned carts, lower the abandoned cart rates, send personalized emails and cart reminders.</li>
<li><a href="https://wordpress.org/plugins/shopmagic-for-twilio/" rel="ugc">ShopMagic for Twilio</a> integration to send SMS directly from the WordPress dashboard or text messages and notifications for your WooCommerce customers. You may also use the plugin to send SMS reminders about the customer’s abandoned cart in WooCommerce to the specific reminder list of customers.</li>
<li><a href="https://wordpress.org/plugins/shopmagic-for-contact-form-7/" rel="ugc">ShopMagic for Contact Form 7</a> that will let you use data from the Contact Form 7 submission forms in your automation. You can use the Contact Form 7 integration to create a custom WordPress or WooCommerce product enquiry, order, and checkout form.</li>
</ul>
You can use all free add-ons together to boost your email marketing in WordPress and WooCommerce 🚀!
<h3>IS THERE A PRO VERSION OF SHOPMAGIC FOR GOOGLE SHEETS?</h3>
No. ShopMagic for Google Sheets is designed as free, and it will be free once and for all. All of the features are included in this add-on.
You may use the add-on to export data from WordPress form submissions or WooCommerce to Google Sheets.
Start by configuring Google Account within ShopMagic settings using a token. Then, create new automation and choose the Add row to Google Sheets from the Actions list. Finally, choose the settings for the data export from your WordPress or WooCommerce to Google Sheets. The ShopMagic will do everything for you automatically!
No additional login, credit card, or external account is needed. Simply download, activate our plugins, and you are good to go!
However, there’s a non-direct way of extending ShopMagic for Google Sheets features. If you are using ShopMagic PRO you’ll have access to some add-ons like <a href="https://shopmagic.app/sk/shopmagic-for-google-sheets-add-gravity-forms/" rel="nofollow ugc">Gravity Forms</a>, <a href="https://shopmagic.app/products/shopmagic-manual-actions/" rel="nofollow ugc">Manual Actions</a> or <a href="https://shopmagic.app/products/shopmagic-customer-coupons/" rel="nofollow ugc">Customer Coupons</a>. You can use them to create better, more personalized WooCommerce marketing automation.
<h3>MORE ADD-ONS</h3>
ShopMagic for Google Sheets is available for free and can be used as your only ShopMagic add-on. However, it integrates with the rest of the add-ons. If you want to extend its functionality, all the ShopMagic PRO add-ons will work. To name a few:
<ul>
<li><a href="https://shopmagic.app/sk/shopmagic-for-google-sheets-delayed-actions/" rel="nofollow ugc">Delayed Actions</a> – Use it to delay your email. You can choose from delay for a specified number of minutes, hours, days, or weeks or to send an email at a specified time. Delay both SMS and email notifications.</li>
<li><a href="https://shopmagic.app/sk/shopmagic-for-google-sheets-review-requests/" rel="nofollow ugc">Review Requests</a> – Request a review from your customer. You can automate your review request flow, and create an automated thank-you email when a customer will review your product.</li>
<li><a href="https://shopmagic.app/sk/shopmagic-for-google-sheets-manual-actions/" rel="nofollow ugc">Manual Actions</a> – Trigger custom emails, directly from your WordPress dashboard, whenever you want, and to whomever you want. Send manual emails, and manually trigger SMS messages. Use it to notify your customers about special offers in your WooCommerce store.</li>
<li><a href="https://shopmagic.app/sk/shopmagic-for-google-sheets-advanced-filters/" rel="nofollow ugc">Advanced Filters</a> – Adds conditional logic and custom filters for your email marketing automation based on specific criteria like order total value.</li>
<li><a href="https://shopmagic.app/sk/shopmagic-for-google-sheets-customer-coupons/" rel="nofollow ugc">Customer Coupons</a> – Send the WooCommerce discount coupons automatically in emails to boost your sales and rescue abandonment carts with special offers.</li>
<li><a href="https://shopmagic.app/sk/shopmagic-for-google-sheets-add-ons/" rel="nofollow ugc">ShopMagic's Integrations</a> – Integrate your store with WooCommerce Bookings, WooCommerce Memberships, and WooCommerce Subscriptions plugins.</li>
<li><a href="https://shopmagic.app/sk/shopmagic-for-google-sheets-slack/" rel="nofollow ugc">Slack Integration for ShopMagic</a> is also here to let you send notifications from WordPress and WooCommerce!</li>
</ul>
If you are looking for more information about available add-ons, check our <a href="https://shopmagic.app/sk/shopmagic-for-google-sheets-home" rel="nofollow ugc">ShopMagic website</a>.
★★★★★
<h3>How to create ShopMagic’s automation?</h3>
Creating automation in ShopMagic is a simple process. You can use below video guide:
<iframe loading="lazy" class="youtube-player" width="750" height="422" src="https://www.youtube.com/embed/UIBnaT_peHc?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>
On the other hand, ShopMagic has a bunch of built-in recipes, which you can import if you prefer not to start from scratch.
Use the ShopMagic plugin to prepare best automatic newsletters, customize emails, surveys, reviews, and automate email marketing with WordPress and for WooCommerce customers!
<h3>Data use policy</h3>
Learn about <a href="https://shopmagic.app/sk/shopmagic-for-google-sheets-privacy" rel="nofollow ugc">Use of Data Policy by WP Desk Plugins</a>
<h3>Requirements</h3>
The only requirement is the core version of the <a href="https://wordpress.org/plugins/shopmagic-for-woocommerce/" rel="ugc">ShopMagic plugin</a>.

ShopMagic for Google Sheets

Integrate your WooCommerce store with Google Sheets - the most popular Spreadsheet service for free.

GSheetConnector for Core Lite vs ShopMagic for Google Sheets