Title: Caldera Forms Google Sheets Connector Author: WesternDeal Published: 14 ਅਕਤੂਬਰ 2020 Last modified: 11 ਸਤੰਬਰ 2023 --- ਪਲੱਗਇਨਾਂ ਖੋਜੋ ![](https://ps.w.org/gsheetconnector-caldera-forms/assets/banner-772x250.png?rev =2408249) This plugin **hasn’t been tested with the latest 3 major releases of WordPress**. It may no longer be maintained or supported and may have compatibility issues when used with more recent versions of WordPress. ![](https://ps.w.org/gsheetconnector-caldera-forms/assets/icon-128x128.jpg?rev=2399438) # Caldera Forms Google Sheets Connector [WesternDeal](https://profiles.wordpress.org/westerndeal/) ਵੱਲੋਂ [ਡਾਊਨਲੋਡ ਕਰੋ](https://downloads.wordpress.org/plugin/gsheetconnector-caldera-forms.zip) * [ਵੇਰਵਾ](https://pan.wordpress.org/plugins/gsheetconnector-caldera-forms/#description) * [ਸਮੀਖਿਆਵਾਂ](https://pan.wordpress.org/plugins/gsheetconnector-caldera-forms/#reviews) * [ਸਥਾਪਤੀਕਰਨ](https://pan.wordpress.org/plugins/gsheetconnector-caldera-forms/#installation) * [ਵਿਕਾਸ](https://pan.wordpress.org/plugins/gsheetconnector-caldera-forms/#developers) [ਸਹਿਯੋਗ](https://wordpress.org/support/plugin/gsheetconnector-caldera-forms/) ## ਵੇਰਵਾ [Caldera Forms Closure](https://calderaforms.com/2021/03/the-future-of-caldera-forms), No more updates on this plugin Due to Caldera Forms being sunset/retired on December 31, 2021 You are welcome to continue using the plugin. We have updated the Google Integration method, Therefore you can still use the plugin if you are still using the [Caldera Forms](https://github.com/CalderaWP/Caldera-Forms/releases) [Homepage](https://www.gsheetconnector.com/) | [Documentation](https://www.gsheetconnector.com/docs) | [Support](https://www.gsheetconnector.com/support) | [Demo](https://calderasheets.gsheetconnector.com/) | [Premium Version](https://www.gsheetconnector.com/caldera-google-sheet-connector-pro) This plugin is a bridge between your [WordPress](https://wordpress.org/) [Caldera Forms](https://wordpress.org/plugins/caldera-forms/) forms and [Google Sheets](https://www.google.com/sheets/about/). 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. #### 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 Caldera Forms Google Sheet Connector using [API version 4.0](https://developers.google.com/sheets/api) 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](https://www.youtube.com/@gsheetconnector) #### 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. ## ਸਕਰੀਨਸ਼ਾਟ * [[ * 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. ## ਸਥਾਪਤੀਕਰਨ 1. Upload `gsheetconnector-caldera-forms` to the `/wp-content/plugins/` directory, OR `Site Admin > Plugins > New > Search > GsheetConnector Caldera Forms > Install`. 2. Activate the plugin through the ‘Plugins’ screen in WordPress. 3. Use the `Admin Panel > Caldera Forms > Google Sheets` screen to connect to `Google Sheets` by entering the Access Code. You can get the Access Code by clicking the“ Get Code” button. Enjoy! ## ਅਕਸਰ ਪੁੱਛੇ ਜਾਂਦੇ ਸਵਾਲ ### Why isn’t the data send to spreadsheet? Caldera Forms Submit is just Spinning. Sometimes it can take a while of spinning before it goes through. But if the entries never show up in your Sheet then one of these things might be the reason: 1. Wrong access code ( Check debug log ) 2. Wrong Sheet name or tab name 3. Wrong Column name mapping ( keep in mind that not to use capital letters, number as initial and special characters like underscores, double or single code, space etc. You can only use small letters and hyphen. ) Please double-check those items and hopefully getting them right will fix the issue. ### How do I get the Google Access Code required in step 3 of Installation? * On the `Admin Panel > Caldera forms > Google Sheets` screen, click the “Get Code” button. * In a popup Google will ask you to authorize the plugin to connect to your Google Sheets. Authorize it – you may have to log in to your Google account if you aren’t already logged in. * On the next screen, you should receive the Access Code. Copy it. * Now you can paste this code back on the `Admin Panel > Caldera forms > Google Sheets` screen. ## ਸਮੀਖਿਆਵਾਂ ![](https://secure.gravatar.com/avatar/22d46285ccedeb67663831836b51fe94b6c736ffaf9ded1f3e7302747df53dc9? s=60&d=retro&r=g) ### 󠀁[Excellent Plugin – Works Perfectly](https://wordpress.org/support/topic/excellent-plugin-works-perfectly-12/)󠁿 [swatimodi](https://profiles.wordpress.org/swatimodi/) 24 ਫਰਵਰੀ 2021 Thanks for the awesome plugin, it works perfectly and simple to setup, This plugin is simple and effective! [ Read all 1 review ](https://wordpress.org/support/plugin/gsheetconnector-caldera-forms/reviews/) ## ਯੋਗਦਾਨੀ ਤੇ ਵਿਕਾਸਕਾਰ “Caldera Forms Google Sheets Connector” is open source software. The following people have contributed to this plugin. ਯੋਗਦਾਨੀ * [ WesternDeal ](https://profiles.wordpress.org/westerndeal/) * [ Abdullah Kaludi ](https://profiles.wordpress.org/abdullah17/) [“Caldera Forms Google Sheets Connector” ਦਾ ਆਪਣੀ ਭਾਸ਼ਾ ਵਿੱਚ ਅਨੁਵਾਦ ਕਰੋ।](https://translate.wordpress.org/projects/wp-plugins/gsheetconnector-caldera-forms) ### ਵਿਕਾਸ ਕਾਰਜ ਵਿੱਚ ਰੁਚੀ ਰੱਖਦੇ ਹੋ? [Browse the code](https://plugins.trac.wordpress.org/browser/gsheetconnector-caldera-forms/), check out the [SVN repository](https://plugins.svn.wordpress.org/gsheetconnector-caldera-forms/), or subscribe to the [development log](https://plugins.trac.wordpress.org/log/gsheetconnector-caldera-forms/) by [RSS](https://plugins.trac.wordpress.org/log/gsheetconnector-caldera-forms/?limit=100&mode=stop_on_copy&format=rss). ## ਤਬਦੀਲੀ-ਚਿੱਠਾ #### 1.3 (14-08-2023) * Resolved Vulnerability Issues: Applied necessary fixes for improved protection against potential threats. #### 1.2 (29-04-2023) * Vulnerabilities issue resolved. #### 1.1 (28-11-2022) * New Google Integration method implemented using web app. * Code Optimization * Display Connected Email with Google API. #### 1.0 * First public release * Integrated Caldera Forms with Google sheets. ## ਮੈਟਾ * Version **1.3** * Last updated **3 ਸਾਲ ਪਹਿਲਾਂ** * Active installations **100+** * WordPress version ** 6.0 ਜਾਂ ਇਸ ਤੋਂ ਉੱਚਾ ** * Tested up to **6.3.8** * Language * [English (US)](https://wordpress.org/plugins/gsheetconnector-caldera-forms/) * Tags * [caldera forms](https://pan.wordpress.org/plugins/tags/caldera-forms/)[contact forms](https://pan.wordpress.org/plugins/tags/contact-forms/) [google sheet](https://pan.wordpress.org/plugins/tags/google-sheet/)[Google Sheets Integrations](https://pan.wordpress.org/plugins/tags/google-sheets-integrations/) * [Advanced View](https://pan.wordpress.org/plugins/gsheetconnector-caldera-forms/advanced/) ## ਦਰਜਾਬੰਦੀ 5 out of 5 stars. * [ 1 5-star review ](https://wordpress.org/support/plugin/gsheetconnector-caldera-forms/reviews/?filter=5) * [ 0 4-star reviews ](https://wordpress.org/support/plugin/gsheetconnector-caldera-forms/reviews/?filter=4) * [ 0 3-star reviews ](https://wordpress.org/support/plugin/gsheetconnector-caldera-forms/reviews/?filter=3) * [ 0 2-star reviews ](https://wordpress.org/support/plugin/gsheetconnector-caldera-forms/reviews/?filter=2) * [ 0 1-star reviews ](https://wordpress.org/support/plugin/gsheetconnector-caldera-forms/reviews/?filter=1) [Your review](https://wordpress.org/support/plugin/gsheetconnector-caldera-forms/reviews/#new-post) [See all reviews](https://wordpress.org/support/plugin/gsheetconnector-caldera-forms/reviews/) ## ਯੋਗਦਾਨੀ * [ WesternDeal ](https://profiles.wordpress.org/westerndeal/) * [ Abdullah Kaludi ](https://profiles.wordpress.org/abdullah17/) ## ਸਹਿਯੋਗ ਕੁਝ ਕਹਿਣਾ ਹੈ? ਮਦਦ ਚਾਹੀਦੀ ਹੈ? [ਸਹਿਯੋਗ ਫੋਰਮ ਦੇਖੋ](https://wordpress.org/support/plugin/gsheetconnector-caldera-forms/) ## ਦਾਨ ਦਿਉ Would you like to support the advancement of this plugin? [ ਇਸ ਪਲੱਗਇਨ ਨੂੰ ਦਾਨ ਦਿਉ ](https://www.paypal.me/WesternDeal)