Follow for free plugins, new theme releases and theme news
Plugin Description
This plugin is a bridge between your WordPress Caldera Forms forms and Google Sheets.
When a visitor submits his/her data on your website via a Caldera Forms, upon form submission, such data are also sent to Google Sheets.
It allows to add new processor to Caldera Forms, that enables sending of submitted forms to Google Sheets.
Homepage | Documentation | Support | Demo | Premium Version
Check Live Demo
Demo URL: https://calderasheets.gsheetconnector.com/
Google Sheet URL to Check submitted Data
https://docs.google.com/spreadsheets/d/1ooBdX0cgtk155ww9MmdMTw8kDavIy5J1m76VwSrcTSs/edit#gid=118751258
Google API
Integration of Caldera Forms Google Sheet Connector using API version 4.0
You required to simply add Sheet Name, Sheet ID, Tab Name, Tab ID and arrange columns manually in Google Sheet
How to Use this Plugin
In Google Sheets
* Log into your Google Account and visit Google Sheets.
* Create a new Sheet and name it.
* Rename the tab on which you want to capture the data.
In WordPress Admin
* Create or Edit the Caldera Forms form from which you want to capture the data. Set up the form as usual in the Form and Mail etc tabs. Thereafter, go to the new “Google Sheets” tab.
* On the “Google Sheets” tab, copy-paste the Google Sheets sheet name and tab name into respective positions, and hit “Save”.
In Google Sheets
* In the Google sheets tab, provide column names in row 1. The first column should be “date”. For each further column, copy paste mail tags from the Caldera Forms(e.g. “your-name”, “your-email”, “your-subject”, “your-message”, etc).
* Test your form submit and verify that the data shows up in your Google Sheet.
Videos to help you get started with Caldera Forms Google Sheets Connector
How to Install, Authenticate and Integrate Caldera Forms with your Google Sheet.
Check Video on YouTube Channel
Caldera Forms & add-ons will be sunset/retired, refer more
https://calderaforms.com/2021/12/2-important-announcements-for-caldera-forms/
Important Notes
- You must pay very careful attention to your naming. This plugin will have unpredictable results if names and spellings do not match between your Google Sheets and form settings.
Screenshots
Google Sheet Integration without authentication
Permission page if user is already logged-in to there account.
Permission popup-1 after logged-in to your account.
Permission popup-2 after logged-in to your account.
Copy Access code and paste in Integration tab.
After successful integration – Displays “Currently Active”.
Adding googlesheet processor in Caldera Forms
Google Sheet settings page with input box Sheet Name, Sheet Id, Tab Name, Tab Id.
Google Sheet headers with Special Mail Tags.
