WesternDeal

GSheetConnector

Abdullah Kaludi

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


GSheetConnector for Core Lite

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

Adam @ WPCrafter

sujaypawar

rohitrpatil

<p><strong>OttoKit – THE ALL IN ONE AUTOMATION PLUGIN AND BEYOND</strong><br />
★★★★★</p>
<p>👉 <a href="https://ottokit.com/" rel="nofollow ugc">Official Website Link</a><br />
👉 <a href="https://zipwp.org/plugins/suretriggers/" rel="nofollow ugc">Try the live demo of OttoKit</a></p>
<span class="embed-youtube" style="text-align:center; display: block;"><iframe loading="lazy" class="youtube-player" width="750" height="422" src="https://www.youtube.com/embed/MpxE2p8piSw?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></span>
<h3>CONNECT YOUR WORDPRESS PLUGINS, APPS & WEBSITES TO CREATE POWERFUL AUTOMATIONS ⚡</h3>
<p>At OttoKit, our mission is to empower you to connect your favorite apps, automate repetitive tasks, and unlock new growth opportunities for your business.</p>
<p>Today, running a business means dealing with a lot of different apps, services, and plugins. On average, organizations use 110 different softwares to run their business.</p>
<p>Contact forms, Email marketing tools, Social media sites, Payment gateways, CRMs, Helpdesk, eCommerce plugins, Communication tools, Project management platforms, LMS, and the list goes on.</p>
<p>That’s a lot of moving pieces!</p>
<p>Now the problem is, these are all independent tools. They usually can not communicate with one another, causing a lot of time and energy wasted on manual data entry and other mundane tasks. It also means opportunities are lost when important apps are not connected.</p>
<p>Just for an example, imagine a small business owner named Jane. She runs an eCommerce website. When someone places an order on her website, this is what she wants to do:</p>
<ul>
<li>Add a customer to a CRM</li>
<li>Add the order details to an accounting system.</li>
<li>Upload the invoice to a Google Drive folder that is shared with the accountant</li>
<li>Send a thank-you email to the customer</li>
<li>Then, send this customer another email after 15 days asking for a review.</li>
<li>If the customer leaves a five-star review, send a coupon encouraging the next purchase.</li>
<li>If the customer does not use the coupon, remind them of it 3 days before it expires</li>
<li>She also wants to get a notification of any order above $500 USD in a Slack channel</li>
<li>Also for those large orders, send a message on WhatsApp to make the customer feel special and build a better relationship with them.</li>
</ul>
<p>This is just one simple use case of a small business owner, trying to run and grow her simple eCommerce website. It is just impossible to manually do all of these tasks for each and every order that comes through her website!</p>
<p>That’s why we created OttoKit.</p>
<p>OttoKit is an automation platform that automates processes between different websites, applications, and WordPress plugins. It helps you create powerful workflows to connect your apps and automate repetitive tasks. It can automatically do any number of things in different apps, after something happens.</p>
<p>For example:</p>
<ul>
<li>What happens after someone buys a product</li>
<li>What happens after someone leaves a review</li>
<li>What happens after someone logs into your website</li>
<li>What happens after someone fills out a contact form</li>
<li>What happens when someone takes a quiz in an online course and achieve a certain score</li>
</ul>
<p>Now there are some tools, like Zapier that might help you do some of this. However, they do not connect well with WordPress and are quite expensive. Furthermore, they were made years ago, and their user experience leaves a lot to be desired.</p>
<p>Furthermore, many WordPress automation tools suffer from limited integrations, are bloated, and can slow down your website. They require a lot of technical knowledge to use and yet are unreliable.</p>
<p>OttoKit is different.</p>
<p>OttoKit is the only platform built specifically to seamlessly integrate with WordPress and external applications. We have a modern user interface that is easy to use, and our platform is designed to be lightweight and fast.</p>
<p>And most importantly, it doesn’t break the bank.</p>
<p>Now Jane can easily connect her website to her CRM, accounting system, email marketing platform, and other apps she wants.</p>
<p>OttoKit is our way to make sure that businesses, like Jane, can connect their favorite apps, automate mundane tasks, and focus on what truly matters — discover new growth opportunities  📈🙂</p>
<p><a href="https://ottokit.com/" rel="nofollow ugc">Sign up for free today!</a></p>
<h3>DISCLAIMER:</h3>
<p>OttoKit is a SaaS platform and requires an account on our website. When you install this plugin, you’ll need to register for a free account. Or, if you already have an account with us, you can simply connect this plugin to it.</p>
<p>This plugin helps you connect your WordPress website to the OttoKit SaaS platform.</p>
<h3>HOW IT WORKS ❓</h3>
<p>From installation to creating your first automation, OttoKit is designed to be simple and intuitive. Here is how it works:</p>
<h3>Step 1. Install WordPress Plugin  🔌</h3>
<p>From your WordPress dashboard, navigate to the Plugins menu and click on the “Add New” button. Search for the OttoKit plugin, then click “Install Now” and “Activate”.</p>
<h3>Step 2. Connect your WordPress website ⚙️</h3>
<p>Once the plugin is installed, you will be redirected to the OttoKit settings page in your WordPress dashboard. There you will find a button to connect your WordPress website with the OttoKit platform. If you do not have an account on the platform, you can create it for free in less than 60 seconds. Or if you already have an account, just sign in with your login credentials.</p>
<p>All compatible plugins, such as WooCommerce, Fluent Forms, LearnDash, BuddyBoss, etc., will automatically connect to the OttoKit platform during this process. Yaay, you’re almost ready to start automating tasks on this website!</p>
<h3>Step 3. Connect other apps 🔗</h3>
<p>If you want to connect other apps and websites such as Google sheets, MailChimp, Twitter, Stripe, Trello, etc. you can do that now. Just select the apps you use, and follow the instructions to connect your accounts.</p>
<p>OttoKit already support hundreds of popular apps, and we’re adding more each week!</p>
<h3>Step 4. Choose a trigger 💣</h3>
<p>After you’ve connected your apps, you can set up triggers that will start a special task. A trigger is something that happens in one of your connected apps, like receiving a new order in your eCommerce platform.</p>
<h3>Step 5. Add actions ⚡</h3>
<p>Now you can choose what you want OttoKit to do whenever your chosen trigger is executed. Just pick the app and action you want to use. For example, you might want to pass the details of the customer who placed the order in your email marketing platform like MailChimp.</p>
<p>Now whenever the trigger happens, all the actions will be executed automatically. You can create similar automations to connect your favorite apps, automate mundane tasks, and discover new growth opportunities!</p>
<h3>SOME OF THE POWERFUL FEATURES  💪</h3>
<p>OttoKit is packed with advanced features that will help you streamline your processes and save time. Below are just some of the advanced features it offers:</p>
<h3>Canvas Builder 💙</h3>
<p>Our standout feature is our intuitive canvas editor in OttoKit. It lets you visually construct your automations by dragging triggers and actions onto the canvas. This makes it simple to visualize your workflow and make adjustments or expansions without coding.</p>
<h3>Multi-step automations 🎉</h3>
<p>You can make multi-step automations that link actions triggered by events. For instance, you could set up a customer welcome process with emails, course enrollment, and adding to a mailing list. This helps you automate tasks and save time.</p>
<h3>Integrations with WordPress plugins 🤘</h3>
<p>OttoKit works smoothly with popular WordPress plugins like Gravity Forms, WooCommerce, LearnDash, TutorLMS, FluentCRM, BuddyBoss, CartFlows, SureMembers, Elementor, and more. This allows users to automate actions such as post-purchase processes, website logins, form submissions, course enrollments, quiz completions, and specific score achievements, saving time and effort.</p>
<h3>Integrations with SaaS applications 🪩</h3>
<p>OttoKit connects with lots of apps, so you can link your favorites together. Want your CRM to talk to your email tool? Or your project manager to sync with your invoicing? OttoKit does it. With a few clicks, set up automations to save time and get more done.</p>
<h3>Automation between multiple WordPress sites 🔗</h3>
<p>Want to connect one WordPress website to another? For example, if you have WooCommerce installed on one site and LearnDash on another. And whenever someone buys a WooCommerce product, you might want to offer access to a related course which is on another WordPress installation. OttoKit makes it extremely easy.</p>
<h3>Schedule ⏱️</h3>
<p>The Schedule feature lets you choose when your automations happen. You can pick a time and date for a one-time event or set them to repeat regularly. For instance, you could send a Slack reminder every Friday or back up your website every night. This simplifies tasks that need to be done regularly, fitting your business schedule, whether it’s daily, weekly, monthly, or yearly.</p>
<h3>Conditions 🖖</h3>
<p>OttoKit’s Conditions feature allows you to personalize your automations by setting rules for when actions happen. This helps make your automations more precise, quick, and adaptable. You can use Conditions to do tasks like sending messages, updating lists, emailing again, posting on social media, and assigning jobs to team members.</p>
<h3>Filter 🎲</h3>
<p>This feature is handy in automations with many steps. It lets you decide if the automation keeps going or stops based on a condition. For example, if a customer hasn’t bought anything in 30 days, the automation continues. But if they have, it stops. This control helps you manage your automations better.</p>
<h3>Path 🎊</h3>
<p>The Path feature lets you make automations that can choose different actions depending on specific conditions. For instance, you can create an automation that sends one email if a customer’s purchase is big and another if it’s small. It helps automate decisions by creating different paths based on conditions.</p>
<h3>Delay ⌛</h3>
<p>OttoKit’s delay feature is handy for adding timing pauses between actions in automations. For instance, you can send a personalized email to customers 90 minutes after they buy something to make them feel valued. Later, you can send another email asking for a review after 15 days.</p>
<h3>Formatters 😎</h3>
<p>OttoKit Formatter helps you tidy up your data and do calculations easily. It has tools to format, extract, and calculate data the way you want. You can change dates, times, currency, do math, and more. It’s all done with a simple, visual interface.</p>
<h3>Custom APIs ➡️</h3>
<p>OttoKit can share information between your automations and other apps online using APIs. This means you can make something happen in another app when a task finishes in OttoKit. For example, you could make OttoKit send a message on Slack whenever someone orders from your website. Now, you can link your automations to any app that can get API requests fast and easy.</p>
<h3>Incoming Webhooks ⬅️</h3>
<p>OttoKit uses incoming webhooks to get data from other apps or sites, triggering automations. For example, when someone applies for a job on your site, OttoKit can send them a WhatsApp message by receiving application data through a webhook.</p>
<h3>Dynamic data mapping 🔥</h3>
<p>Dynamic Data Mapping in OttoKit lets you easily share info between apps. Say you run an online store with WooCommerce and want to send SMS with Twilio. It automatically links customer details like name, phone number, and order info from WooCommerce to Twilio.</p>
<h3>Detailed logs and history 📜</h3>
<p>OttoKit’s Detailed Logs and History feature helps you keep tabs on how well your automations are doing and fix any problems. It shows you exactly what happened at each step.</p>
<h3>WHO CAN BENEFIT FROM OTTOKIT?</h3>
<p>Any individual or organization that wants to automate repetitive tasks and connect different apps can greatly benefit from using OttoKit.</p>
<ul>
<li>
<p><strong>eCommerce entrepreneurs</strong> can use OttoKit to automate customer notifications, engagement, marketing, shipping tracking, and more. It can also help them integrate their eCommerce store with other business systems such as accounting and customer support.</p>
</li>
<li>
<p><strong>eLearning businesses</strong> can use OttoKit to automate various tasks, such as sending reminders to students or sending emails to people who fail a quiz.</p>
</li>
<li>
<p><strong>Web design agencies</strong> can use OttoKit to automate notifications, project management, and other tasks.</p>
</li>
<li>
<p><strong>Marketing teams</strong> can use OttoKit to automate tasks such as customer segmentation and email campaigns.</p>
</li>
<li>
<p><strong>Social media marketers</strong> can use OttoKit to automate notifications, social media updates, and more. It can also help them easily connect their clients’ websites to other systems.</p>
</li>
<li>
<p><strong>Small business owners</strong> can use OttoKit to connect their business systems and automate key tasks.</p>
</li>
<li>
<p><strong>Startups</strong> can use OttoKit to automate various tasks, such as customer sign-ups, billing, and project management.</p>
</li>
<li>
<p><strong>HR teams</strong> can use OttoKit to automate onboarding, offboarding, payroll, and other tasks.</p>
</li>
<li>
<p><strong>Social media managers</strong> can use OttoKit to automate content creation, reporting, and other tasks.</p>
</li>
<li>
<p><strong>Accounting firms</strong> can use OttoKit to automate data entry, document management, and other tasks.</p>
</li>
</ul>
<p><em>The list could go on and on!</em></p>
<p>There is no limit to the types of businesses and organizations that can benefit from using OttoKit. From automating marketing and customer service tasks to integrating business systems, OttoKit can make a huge difference in any organization’s workflow.</p>
<p>Even if you are an individual, OttoKit can be highly beneficial. It can be used to automate mundane tasks such as setting notifications, reminders and tracking.</p>
<h3>SOME OF THE WORDPRESS PLUGINS OTTOKIT SUPPORTS:</h3>
<ul>
<li>WooCommerce</li>
<li>SureMembers</li>
<li>Spectra</li>
<li>Presto Player</li>
<li>FluentForms</li>
<li>FluentCRM</li>
<li>CartFlows</li>
<li>BuddyBoss</li>
<li>Gravity Forms</li>
<li>GiveWP</li>
<li>LearnDash</li>
<li>Lifter LMS</li>
<li>MemberPress</li>
<li>Elementor Pro</li>
<li>Tutor LMS</li>
<li>Wishlist Member</li>
<li>WPForms</li>
<li>AffiliateWP</li>
<li>Restrict Content Pro</li>
<li>Beaver Builder</li>
<li>Divi Builder</li>
<li>Bricks Builder</li>
<li>Easy Digital Downloads</li>
<li>myCred</li>
<li>The Events Calendar</li>
<li>MasterStudy LMS</li>
</ul>
<h3>SOME OF THE POPULAR APPS:</h3>
<ul>
<li>SureCart</li>
<li>Google Sheets</li>
<li>WhatsApp</li>
<li>ActiveCampaign</li>
<li>ConvertKit</li>
<li>Circle</li>
<li>Gmail</li>
<li>Google Drive</li>
<li>MailChimp</li>
<li>Slack</li>
<li>Stripe</li>
<li>PayPal</li>
<li>Twitter</li>
<li>Mailerlite</li>
<li>Mailgun</li>
<li>Sendinblue</li>
<li>SMTP</li>
<li>Twilio</li>
<li>TypeForm</li>
<li>Vimeo</li>
</ul>
<p>These are just some of the WordPress plugins and apps that are popular among OttoKit users.</p>
<p>If you have apps that are not yet integrated with OttoKit, please <a href="https://ideas.ottokit.com/boards/requests" rel="nofollow ugc">submit a request for integration here.</a> We are releasing new integrations every week!</p>
<p>And if you are a developer, and would like to integrate your plugin or app — we have robust APIs which make it extremely easy to integrate any WordPress plugin or application with OttoKit.</p>
<p><a href="https://ottokit.com/contact-us/" rel="nofollow ugc">Please get in touch with us</a> and we would be happy to help.</p>
<h3>BRANDING GUIDELINE</h3>
<p>OttoKit® is a registered trademark. Please use the following format when mentioning the OttoKit anywhere.</p>
<ul>
<li>OttoKit [correct]</li>
<li>Otto Kit [incorrect]</li>
<li>Ottokit [incorrect]</li>
</ul>
<h3>CONNECT WITH OUR TEAM AND COMMUNITY</h3>
<p><a href="https://www.facebook.com/groups/ottokithq" rel="nofollow ugc">Join our Facebook group community:</a> Learn the tricks and techniques that other OttoKit users are using to grow their business. Also, get exciting insider information on upcoming feature releases.</p>


OttoKit: All-in-One Automation Platform


Unlike other platforms that are often too technical (heavy on auth, webhooks, and complex nodes), OttoKit feels much closer to day-to-day business needs. I used it to transform my workflows, and I was impressed by the clearer UI and lighter setup.



It is quick to adopt, reliable, and requires very little maintenance, perfect for small teams who want power without complexity.


Turned my workflows into easy automations – Power without complexity!

Experience the power of automation within WordPress: Connect 1,500+ apps, automate manual tasks, and unlock your full potential. Get started now!

GSheetConnector for Core Lite vs OttoKit: All-in-One Automation Platform