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.

Alex Agranov

<h4>Development Has Been Seized</h4>
Due to Caldera Forms being <a href="https://calderaforms.com/2021/03/the-future-of-caldera-forms" rel="nofollow ugc">sunset/retired</a> on December 31, 2021 development of this pluging has been seized too.
You are welcome to continue using the plugin “as is”. However please expect the plugin to stop functioning on October 3, 2022 (because it uses out-of-band OAuth flow that will be <a href="https://developers.googleblog.com/2022/02/making-oauth-flows-safer.html" rel="nofollow ugc">deprecated</a> by Google by that date).
I have personally migrated all my forms to <a href="https://wordpress.org/plugins/contact-form-7" rel="ugc">Contact Form 7</a> plugin with the following extensions:
<ul>
<li><a href="https://wordpress.org/plugins/cf7-conditional-fields" rel="ugc">Conditional Fields for Contact Form 7</a></li>
<li><a href="https://wordpress.org/plugins/contact-form-7-modules" rel="ugc">Contact Form 7 Modules</a></li>
<li><a href="https://wordpress.org/plugins/contact-form-cfdb7" rel="ugc">Contact Form 7 Database Addon – CFDB7</a></li>
<li><a href="https://wordpress.org/plugins/wpcf7-recaptcha" rel="ugc">ReCaptcha v2 for Contact Form 7</a></li>
</ul>
And created a plugin for integration with Google Sheets:
<ul>
<li><a href="https://wordpress.org/plugins/cf7-google-sheets" rel="ugc">Integration with Google Sheets for Contact Form 7</a>) </li>
</ul>
<h4>Overview</h4>
This plugin provides integration between <a href="https://wordpress.org/plugins/caldera-forms/" rel="ugc">Caldera Forms</a> and <a href="https://www.google.com/sheets/" rel="nofollow ugc">Google Sheets</a>. 
It adds new processor to Caldera Forms that enables sending of submitted forms to Google Sheets.
<h4>Upgrade Instructions</h4>
<blockquote>
Version 2.x of the plugin introduced some non-backward compatible changes. Follow the below instructions if you are upgrading from plugin version 1.x to 2.x.
</blockquote>
Version 1.x of the plugin used <a href="https://developers.google.com/sheets/api/v3" rel="nofollow ugc">Google Sheets API v3</a> that is shut down by Google. 
Version 2.x of the plugin switched to the latest <a href="https://developers.google.com/sheets/api" rel="nofollow ugc">Google Sheets API v4</a>.
Due to this change you MUST do the following after upgrading from version 1.x to 2.x:
<ul>
<li>generate your own OAuth2 credentials (if you didn’t do that before) and enter them in plugin Settings screen</li>
<li>re-connect plugin to Google Sheets by going to plugin Settings screen, clicking “Get Code”, going through the Google authorization pages, copy/pasting the generated Access Code and clicking “Save”</li>
<li>in all your Caldera Forms that use Google Sheets processor, update processor configuration to use Sheet ID (instead of Sheet Name); Sheet ID may be retrieved from your Sheet’s URL – e.g. for URL https://docs.google.com/spreadsheets/d/abc123456/edit#gid=0 the Sheet ID is “abc123456”</li>
</ul>
<h4>Connecting the Plugin to Google Sheets</h4>
After installing the plugin you must connect it to Google Sheets as described below.
Generating OAuth2 credentials
The simplest way to generate OAuth2 credentials is as follows:
<ul>
<li>Open the <a href="https://developers.google.com/sheets/api/quickstart/php" rel="nofollow ugc">Google Sheets API PHP Quickstart</a> page</li>
<li>Click Enable the Google Sheets API button in Step 1</li>
<li>If asked, enter project name and confirm that your use of Google APIs is in compliance with Tems of Service</li>
<li>On the page that appears, your OAuth2 “client ID” and “client secret” are displayed. Leave this page open, so that you can copy/paste values from it to the plugin configuration. Alternatively, copy the values to some clipboard. </li>
</ul>
If the above method doesn’t work for you, use the following procedure to generate OAuth2 credentials manually. Refer to <a href="https://youtu.be/wUY8Owt5zwc" rel="nofollow ugc">screencast</a> for visual assistance.
<ul>
<li>Open the <a href="https://console.developers.google.com/apis/library" rel="nofollow ugc">Google API Library</a></li>
<li>Click Select a project, then NEW PROJECT, enter a name for the project – e.g. “CalderaFormsGoogleSheets” – and click Create.</li>
<li>Make sure that created project is selected.</li>
<li>Search for “sheets” and click on Google Sheets API. Click ENABLE.</li>
<li>Open the <a href="https://console.developers.google.com/apis/credentials" rel="nofollow ugc">Google API Console Credentials page</a></li>
<li>On the OAuth consent screen:
<ul>
<li>For User Type select External and click CREATE</li>
<li>For Application Name enter “Google Sheets Integration for Caldera Forms”</li>
<li>For Scopes for Google APIs click Add Scope, select ../auth/spreadsheets scope and click ADD</li>
<li>Click Save</li>
</ul>
</li>
<li>On the Credentials screen, select Create credentials, then OAuth client ID
<ul>
<li>For Application type select Desktop app </li>
<li>For Name enter “Google Sheets Integration for Caldera Forms”</li>
<li>Click Create</li>
</ul>
</li>
<li>On the page that appears, your OAuth2 “client ID” and “client secret” are displayed. Leave this page open, so that you can copy/paste values from it to the plugin configuration. Alternatively, copy the values to some clipboard. </li>
</ul>
Authorizing plugin acess to Google Sheets
After generating OAuth2 credentials, use the following procedure to authorize plugin access to Google Sheets. Refer to <a href="https://youtu.be/rixQf4rFgiY" rel="nofollow ugc">screencast</a> for visual assistance.
<ul>
<li>Open a new page and go to plugin Settings screen (or to Admin Panel > Caldera Forms > Google Sheets screen)</li>
<li>For Google OAuth2 Client ID paste “client ID” from Google OAuth2 Credentials page </li>
<li>For Google OAuth2 Secret paste “client secret” from Google OAuth2 Credentials page</li>
<li>Click Get Code button – you will be redirected to Google Sheets authorization page</li>
<li>You will see This app isn’t verified screen – this is OK, because you are authenticating your own site
<ul>
<li>Click Advanced and then click Go to Google Sheets Integration for Caldera Forms (unsafe)</li>
</ul>
</li>
<li>In the Grant Google Sheets Integration for Caldera Forms permission screen click Allow</li>
<li>In the Confirm your choices screen click Allow</li>
<li>Copy generated “access code” to the clipboard</li>
<li>Paste “access code” into the Google Access Code in plugin Settings screen</li>
<li>Click Save</li>
</ul>
<h4>Using the Plugin</h4>
After successfully connecting the plugin to Google Sheets, do the following to configure your Caldera Form to send data to Google Sheets on form submission. Refer to <a href="https://youtu.be/HwfN-lfTqvs" rel="nofollow ugc">screencast</a> for visual assistance.
In Google Sheets
<ul>
<li>Create a new Google Sheet</li>
<li>Determine Sheet ID from the sheet’s URL – for example, in URL https://docs.google.com/spreadsheets/d/abc123456/edit#gid=0 the Sheet ID is “abc123456”</li>
<li>Name the tab where you want to capture the data with some simple name that doesn’t include space and/or special characters – e.g. “Sheet1” or “InputData”</li>
</ul>
If you wish to record all of your Caldera Form fields, proceed to the next step and enable “Automatically generate header” option in processor settings.
If you wish to record only selected fields create custom spreadsheet header in the first row as follows:
<ul>
<li>Enter “id” in the the first column</li>
<li>Enter “date” in the the second column</li>
<li>Enter slug names of your Caldera Form fields (that you want to record) in the following columns</li>
</ul>
In Caldera Forms
<ul>
<li>Add Google Sheets processor to your form</li>
<li>Configure the Sheet ID and Tab name</li>
<li>It is recommended to enable “Automatically generate header” checkbox, unless you created custom spreadsheet header in the previous step</li>
<li>Click “Save Form” to save processor settings</li>
<li>Submit a test form and verify that the data shows up in your Google Sheet</li>
</ul>
<h4>Automatic Header Generation</h4>
When “automatic header generation” is enabled, the plugin verifies spreadsheet header on each new form submission and adds new fields to it if needed. Note that it never deletes fields from the header – as this would also delete some submission data – though you can do it manually. You may also manually reorder columns as you wish.
<h4>Slug Names</h4>
<ul>
<li>Your slug names should contain only the following characters:
<ul>
<li>english letters “[A-Za-z]”</li>
<li>digits “[0-9]”</li>
<li>dash “-“</li>
<li>underscore “_”</li>
</ul>
</li>
<li>If your slug names contain capital letters, replace them with lowercase letters in Google Sheet header – e.g. for “SURNAME” slug use “surname” header</li>
<li>If your slug names contain underscores, replace them with dashes in Google Sheet header – e.g. for “name_english” slug use “name-english” header</li>
</ul>
<h4>Acknowledgements</h4>
The initial version of the plugin was based on <a href="https://wordpress.org/plugins/cf7-google-sheets-connector/" rel="ugc">CF7 Google Sheets Connector</a>

Google Sheets Integration for Caldera Forms

Josh from Caldera Forms here. I'm super excited that you built this. Just tested it out and it works, and I think a lot of people are going to love this!

Getting Caldera Forms data to Google Sheets, without having to do a CSV export and manual import is super useful. We will probably use this on our site soon.

5 Stars.

This Is Super Cool

Send your Caldera Forms data directly to your Google Sheets spreadsheet.

GSheetConnector for Core Lite vs Google Sheets Integration for Caldera Forms