Formidable Forms

Formidable Forms

  • Features
  • Pricing
  • Resources
    • Docs & Support
    • Blog
    • Community
  • Solutions
    • Web Applications
    • Calculators
    • Surveys
    • Directories
    • Payments
    • Contact forms
  • Login
  • Get Formidable Forms

Google Spreadsheet Forms

Last Updated: October 18, 2022

Knowledge Base → Add-Ons → Other Integrations → Google Spreadsheet Forms

Send your Formidable Forms data to Google Spreadsheet when a user submits the form on your site. Each form has its own Google Spreadsheet, and the data is added to the selected sheet as a new row.

Formidable Forms is the best WordPress Form Builder plugin. Get it for free!
Subscribe on YouTube

Download and Install

  1. If you still need to do so, install and activate Formidable Forms.
  2. In your WordPress admin, go to Formidable → Add-Ons and click the Install button for the Google Spreadsheet WordPress plugin.

Set up Google API Integration

Step 1: Create Google API project

  1. Go to the Google Cloud Platform Console. Select an existing project or create a new project.
  2. After opening the project, it will redirect you to the APIs & Services dashboard. Or you can click the menu icon at the top left corner of the screen and select APIs & Services.
    Google Spreadsheet - API Services
  3. Click + Enable APIS and Services.
    Google Spreadsheet - Enable API Services
  4. Search for the following APIs in the Library and enable each by clicking the Enable button.
    • Google Sheets API
    • Google Drive API

    Google Spreadsheet - Search API Services

Step 2: Setup OAuth Consent Screen

  1. After enabling all the required APIs, go to APIs & Services → OAuth Consent Screen.
    Google SpreadSheet - Oauth Consent Screen
  2. Select External as the User type. Click the Create button.
    Google SpreadSheet - Oauth Consent External
  3. Under App information, add an Application Name and User support email.
    Google SpreadSheet - Oauth App Information
  4. Under the App domain, add a Website URL as your Application home page.
    Google SpreadSheet - Oauth App Domain
  5. Add an Authorized Domain.
    Google SpreadSheet - Oauth Authorized Domains
  6. Under Developer contact information, add an email address in the field. Click the Save and continue button at the bottom of the page.
    Google SpreadSheet - Oauth Developer Contact
  7. Under Scopes, click the Save and continue button at the bottom of the page.
    Google SpreadSheet - Oauth Scope
  8. Under Test Users, click the Add Users button and insert the email address of the test user associated with a Google account. Your app will start in testing mode and will only be available to users you add to the list of test users. Click the Save and continue button at the bottom of the page.
    Google SpreadSheet - Oauth Test Users
  9. Under Summary, click the Back to Dashboard button at the bottom of the page to redirect you to the newly created app.
    Google SpreadSheet - Oauth Summary
  10. (Optional) Publishing your app will require submitting it to Google for verification. If you do not verify your app, it will be identified to users by its redirect location or client data.
    Google SpreadSheet - Oauth Publish App

Step 3: Get OAuth Client ID

  1. Go to APIs & Services → Credentials. Click Create Credentials and select OAuth Client ID from the dropdown to generate the keys.
    Google Spreadsheet - Create Credentials
  2. Select the Web Application from the Application type dropdown.
    Google SpreadSheet - Oauth Application Type
  3. Use your website URL as the Authorized redirect URI in this field. Be sure to include the trailing slash at the end of your URL.
    Google SpreadSheet - Oauth Authorized Redirect URI
  4. Click the Create button.
  5. In the popup window, copy your Client ID and Client Secret keys.
    Google SpreadSheet - Oauth Client ID Secret

Step 4: Save project keys in settings

  1. After generating the project keys, go to Formidable → Global Settings → Google Sheets tab.
  2. Paste your Client ID and Client Secret ID on this page.
    Google SpreadSheet - Global Settings
  3. Click the Authorize button to complete the connection.

Create a Google Spreadsheet Form

Now that you have added the project keys to your Formidable settings, it is time to create your Google Spreadsheet form.

  1. First, create a form in the same way as other Formidable Forms.
    Create Google SpreadSheet Form
  2. Go to your form Settings → Actions & Notifications and click the Google Sheets icon.Google SpreadSheet Form Action Icon
  3. Give your Google Sheets action an Action Name for easy reference. This name will only be seen in the back end.
    Google SpreadSheet Form Action
  4. Choose when this action should be triggered: Entry is created, Entry is imported.
  5. In the Select File dropdown, choose the Google Sheets file where you want to send the form data. Add a column header in the selected Google Sheet to map your form fields to those headers.
  6. If you have multiple sheets in your file, you can choose which sheet the form data should go to in the Select Sheet dropdown.
  7. Under the Map Sheet Headers section, map your form fields to the sheet headers.
  8. Click the Update button to save your settings.

Send existing entries

If you have existing entries in your form, click the Send existing entries button to append all the existing form entries to the selected Google sheet. To avoid errors, remember to map the sheet headers to form fields before sending the data.
Google SpreadSheet - Send Existing Entries

Note: Proceed with caution when performing this action, as it will export all existing entries to the selected Google sheet and may cause duplication.

Limitations

The Google Sheets add-on doesn't currently support two-way sync. The information is one-way from Formidable to Google Sheets.

Related articles

  • Best WordPress Google Sheets Plugins 7 Best WordPress Google Sheets Plugins [Sheets Made Easy!]
    Read More
    How to Send a WordPress Form to Google Sheets How to Send a WordPress Form to Google Sheets [1 Plugin Solution!]
    Read More
    The Best WordPress Table Plugins 7 Best WordPress Table Plugins (Compared)
    Read More
  • WordPress forms Zapier WordPress Forms for Zapier: The Ultimate Integration
    Read More
    How to export form entries in WordPress How to Export Form Entries in WordPress
    Read More
  • Download and Install
  • Set up Google API Integration
    • Step 1: Create Google API project
    • Step 2: Setup OAuth Consent Screen
    • Step 3: Get OAuth Client ID
    • Step 4: Save project keys in settings
  • Create a Google Spreadsheet Form
    • Send existing entries
  • Limitations
  • Related articles
Categories
×

Categories

  • Installation & Getting Started
  • Account Management
  • Forms
  • Entries
  • Views
  • Styles
  • Importing & Exporting
  • Add-Ons
  • Extend Formidable Forms

Using WordPress and want to get Formidable Forms for free?

Get Formidable Forms Lite Now

You do not have permission to view this form.

This article may contain affiliate links. Once in a while, we earn commissions from those links. But we only recommend products we like, with or without commissions.

Take on bigger projects Right Now

Get the tools you need to revolutionize your workflow and architect a masterpiece. Build the most advanced WordPress forms and actually use the data you collect in meaningful ways.

Get the most advanced WordPress form plugin and the only form builder with integrated Views.

Get Formidable Forms Now

Resources

  • Community
  • Affiliates
  • Contact
  • Free Online Form Builder

Top Features

  • Application Builder
  • Calculator Forms
  • Surveys & Polls
  • Quiz Maker
  • Form Templates
  • Application Templates
  • Directories
  • Donation Plugin

Company

  • About Us
  • Giving Back
  • Careers
  • Newsletter
  • WP Tasty
  • Nutrifox

Copyright © 2023 Strategy11, LLC. Formidable Forms® is a registered trademark Strategy11, LLC.
Privacy Policy | Terms of Service | Sitemap

Join 300,000+ using Formidable Forms to create form-focused solutions fast. Get Started See User Reviews