How to integrate Caldera Forms to Google Sheets| 3 Minutes Solution

Caldera Forms, Google Sheets / By

Overview

Advanced Form Integration plugin allows you to integrate Caldera Forms to Google Sheets. When a user fills a form on your website, the plugin will send the data to your selected sheet that will create a new row. It uses secure OAuth 2.0 authentication and the latest Google Sheets API V4. One form can be connected to multiple sheets and multiple forms can be connected to a single sheet too. This plugin gives you the flexibility to map each form field to any sheet column. Additionally, data flow can be controlled using conditional logic.

2 Sample Contact Forms

Supported Features

  • Create a new row

Requirements

  • The feature requires a Pro license. BUY NOW!
  • Make sure that the Pro version of the Advanced Form Integration plugin is installed and activated. You should have got the links in the email after purchase. You can also download it anytime by logging into the user dashboard.
  • Read plugin documentation for Caldera Forms and Google Sheets. It is not required but helpful for a better understanding.

Google Sheet Authentication

Before start, you need to authorize your Google Sheets account. Go to WordPress admin area, click AFI > Settings and select the Google Sheets tab. Detailed instructions are there. A video instruction also included for your help. This can take a few minutes to set up and need only on the first time.

Create New Integration

Once authorization is done you can start creating new integration. Click on Add New under AFI menu, New Integration page will appear.

Title

A default title will be auto-generated with an auto incremental number. You can rename it to something related to the task. It will help you to quickly recognize the correct one when there is multiple integrations setup.

Trigger

Select Caldera Forms in From Provider dropdown. Caldera Forms plugin must be installed and activated otherwise you won’t see it listed. After selecting Caldera Forms, all forms built under Caldera Forms will be fetched and auto-populated in the Form/Task Name dropdown. Select the form that you want to integrate.

Caldera Forms
Caldera Forms – Trigger setup

Action

Select Google Sheets in Platform dropdown. Select task.

Google Sheets – Action Setup

Map Fields

Available spreadsheets list will be auto-populated. Select the desired one. You can have multiple tabs in the sheet, select the correct one from the dropdown. Now the plugin will fetch table headers (titles) and you can map which form field data want to send on which column. In Google Sheets table titles must be placed in the very first row otherwise the plugin can’t fetch them. Skip columns that you don’t want to map. Finally, click the Save Integration button.

Google Sheets – Table Titles Must Be On First Row

Frequently asked questions

Troubleshooting

Still need help?

Reach our support team at [email protected]