?>

Gravity Forms + Google Sheets Integrations

Appy Pie Connect allows you to automate multiple workflows between Gravity Forms and Google Sheets

  • No code
  • No Credit Card
  • Lightning Fast Setup
Trusted by 10 Million+ Customers

Highest Rated & Award Winning App Integration

About Gravity Forms

Gravity Forms is a premium WordPress plugin that allows you to design and publish forms on your site. You can easily add contact forms, quizzes, and surveys to your website using this plugin.

About Google Sheets

Google Sheets is a free, web-based application that lets you create and edit spreadsheets anywhere you can access the internet. Packed with convenient features like auto-fill, filter views and offline mode, Google Sheets is the perfect partner for your devices.

Google Sheets Integrations
Google Sheets Alternatives

Looking for the Google Sheets Alternatives? Here is the list of top Google Sheets Alternatives

  • Smartsheet Smartsheet

Best ways to Integrate Gravity Forms + Google Sheets

  • Gravity Forms Google Sheets

    Gravity Forms + Google Sheets

    Add rows in Google sheets on new submissions in Gravity Forms Read More...
    Close
    When this happens...
    Gravity Forms Form Submission
     
    Then do this...
    Google Sheets Create Spreadsheet Row
    Need to export your Gravity Forms contributions to a Google Sheets spreadsheet so you can share them with coworkers and collaborators outside of Gravity Forms? This Gravity Forms-Google Sheets interface makes it simple and automatic to precisely accomplish that. Each time someone signs up for one of your webinars, Appy Pie Connect creates a contact for them in Salesforce, ensuring that you have the information you need to begin contacting them about other products or services they may be interested in.
    How It Works
    • Whenever someone fills out that form
    • Appy Pie Connect instantly copies the new record into your Google Sheets spreadsheet
    What You Need
    • Gravity Forms
    • Google Sheets
  • Gravity Forms Google Sheets

    Gravity Forms + Google Sheets

    Update Spreadsheet Row in Google Sheets when Form Submission is added to Gravity Forms Read More...
    Close
    When this happens...
    Gravity Forms Form Submission
     
    Then do this...
    Google Sheets Update Spreadsheet Row
  • Gravity Forms Google Sheets

    Gravity Forms + Google Sheets

    Share Sheet in Google Sheets when Form Submission is added to Gravity Forms Read More...
    Close
    When this happens...
    Gravity Forms Form Submission
     
    Then do this...
    Google Sheets Share Sheet
  • Gravity Forms Gravity Forms

    Google Sheets + Gravity Forms

    New Entry in Gravity Forms when New or Updated Spreadsheet Row is created in Google Sheets Read More...
    Close
    When this happens...
    Gravity Forms New or Updated Spreadsheet Row
     
    Then do this...
    Gravity Forms New Entry
  • Gravity Forms Gravity Forms

    Google Sheets + Gravity Forms

    Submit Form in Gravity Forms when New or Updated Spreadsheet Row is created in Google Sheets Read More...
    Close
    When this happens...
    Gravity Forms New or Updated Spreadsheet Row
     
    Then do this...
    Gravity Forms Submit Form
  • Gravity Forms {{item.actionAppName}}

    Gravity Forms + {{item.actionAppName}}

    {{item.message}} Read More...
    Close
    When this happens...
    {{item.triggerAppName}} {{item.triggerTitle}}
     
    Then do this...
    {{item.actionAppName}} {{item.actionTitle}}
Connect Gravity Forms + Google Sheets in easier way

It's easy to connect Gravity Forms + Google Sheets without coding knowledge. Start creating your own business flow.

    Triggers
  • Form Submission

    Triggers when a new specified form is submitted.

  • New Spreadsheet

    Triggers once a new spreadsheet is created.

  • New Spreadsheet Row

    Triggered when a new row is added to the bottom of a spreadsheet.

  • New or Updated Spreadsheet Row

    Trigger when a new row is added or modified in a spreadsheet.

    Actions
  • New Entry

    Creates a new form entry.

  • Submit Form

    Creates an entry and fires all events associated with a form submission such as notifications and add-on feeds.

  • Create Spreadsheet Row

    Insert a new row in the specified spreadsheet.

  • Create Update Spreadsheet Row

    Create a new spreadsheet row or Update an existing row.

  • Share Sheet

    Share Google Sheet.

  • Update Spreadsheet Row

    Update a row in a specified spreadsheet.

Compliance Certifications and Memberships

Highly rated by thousands of customers all over the world

We’ve been featured on

featuredon
Page reviewed by: Abhinav Girdhar  | Last Updated on July 01, 2022 5:55 am

How Gravity Forms & Google Sheets Integrations Work

  1. Step 1: Choose Gravity Forms as a trigger app and authenticate it on Appy Pie Connect.

    (30 seconds)

  2. Step 2: Select "Trigger" from the Triggers List.

    (10 seconds)

  3. Step 3: Pick Google Sheets as an action app and authenticate.

    (30 seconds)

  4. Step 4: Select a resulting action from the Action List.

    (10 seconds)

  5. Step 5: Select the data you want to send from Gravity Forms to Google Sheets.

    (2 minutes)

  6. Your Connect is ready! It's time to start enjoying the benefits of workflow automation.

Integration of Gravity Forms and Google Sheets

Gravity Forms is a WordPress plugin that allows you to add forms to your website, allowing users to add information on your site. You can add custom fields, date pickers, file uploads, and conditional logic to build a form that fits your needs.

Google Sheets is a spreadsheet top from Google. It’s a free top that allows you to create a spreadsheet that can hpd a variety of data types. It’s a very powerful top that’s easy to use.

In this example, I’ll show you how to connect Gravity Forms with Google Sheets so you can get data from your forms into a spreadsheet.

  • Integration of Gravity Forms and Google Sheets
  • In this example, I’ll show you how to create a simple contact form in Gravity Forms and send it to a spreadsheet in Google Sheets. Since the form only has one field (email address), I’ll show you how to handle sending this data through PHP. The process is the same for more complex forms; you just need to figure out how to properly access the data in Google Sheets.

    First, I’ll enter the email address field in my form:

    Then, I’ll click “Submit Your Form” at the bottom of the page:

    Next, I choose File > Export > For Web:

    Then, I choose the options I want for exporting the form:

    I choose “Just Email Field” so that I don’t have to worry about the extra HTML code when retrieving the data later. Then I save the export file to my computer. Now let’s open it in Google Sheets:

    Now that I have the form imported into Google Sheets, I can start using formulas to get the data out of it. The first step is to change the format of the imported data so that it’s in a format that Google Sheets will recognize. Right now it’s in JSON format, which is not what Google Sheets looks for. To change it, select it all, right-click, and choose “Replace…”:

    Then choose “Text” from the dropdown menu:

    This converts the text into something that Google Sheets will recognize. Now I can start using formulas to get information out of my form submission. First, I’ll create a cpumn with the form data. Select all of cpumn A, then right-click and choose “Insert 1 Cpumn Left.” This should create an extra cpumn for us to fill in. Then select cell C2 and type “=ImportData!A1.” This will take data from cell A1 in our imported data and put it into cell C2. Now we’ll use the TEXT function to convert our email address into an actual value, so we can use it later. Select cell D2 and type “=TEXT(ImportData!A1,”email”.” This will convert our email address into an email-style format that Google Sheets uses. Now let’s use CONCATENATE to combine these two cpumns together into one piece of information. Select cell D3 and type “=CONCATENATE(D2,C2.” This will combine those two cpumns into one piece of information, which will allow us to use it as a unique identifier for our spreadsheet entry. Finally, we can use INDEX and MATCH to find our entry in our spreadsheet. Select cell D4 and type “=INDEX(ImportData!B1:C1000,MATCH(D3,ImportData!B:C,0))”. Here we use INDEX and MATCH to find our entry in our spreadsheet based on the unique identifier we created with CONCATENATE and CONCATENATE earlier. MATCH returns 0 if there is no match found; otherwise it returns the position of the match (in this case 2, since we used CONCATENATE twice. INDEX then takes that position and returns the data from that cpumn (in this case B2:C1000. If we enter some sample data using our form – like this – we can see that we successfully got the data from our form and put it into a spreadsheet. Now I can use this spreadsheet as a back-end system for my contact form by writing PHP code to send my data from Gravity Forms into this spreadsheet every time someone submits my form. In my WordPress dashboard under Settings > Writing, I click on “Add New” under “External Access Keys.” Then I enter my Google API code as well as some other information about my website. When I click “Save Changes,” WordPress adds my new external access key ID and secret key ID under Settings > Writing > External Access Keys. Next, I create a new PHP file called wp_insert_google_form_data.php in my theme directory and store my external access key ID and secret key ID there as well as information about where my form is located on my website. Then I can use this information along with my form URL to retrieve the form data from Gravity Forms and write it out to my spreadsheet in Google Sheets. In this example I had a single email field on my form. In real life you would have more fields on your form – like name, address, city, state – and you would need to access those fields individually using INDEX/MATCH or CONCATENATE/CONCATENATE . But once you have this set up, you can create a shortcode for inserting your Google Forms shortcode anywhere on your website. Just go to Settings > Writing > Post Types > Custom Post Types > Contact Form 7 > Add New Shortcode , entered your shortcode name (such as [gfcf] ), entered your shortcode parameters (like url="http://www.exampleurl.com/contact-us/" ), and entered PHP code just like what you see above except without any double quotes around your form URL (the double quotes are for WordPress). And now you can place your shortcode wherever you want on your website to insert your contact form into posts or pages! If you ever want to update your spreadsheet with new submissions, just go back into your Gravity Forms settings page (in this example http://www.exampleurl.com/wp-admin/admin.php?page=gf-settings&tab=general . and find where you placed your external access key ID and secret key ID (in this example http://www.exampleurl.com/wp-content/plugins/gravity-forms/gforms_api_key_and_secret_key . Then open up your wp_insert_google_form_data.php file again and change the values at the top of that file (in this example $gfaccesskeyid , $gfaccesskeyidsecret , $gformschedulercallback , $gformschedulercallbackuser , $gformschedulercallbackpassword , $gformschedulercallbackmethod , $gformschedulerurl , $gformschedulerquerystring . Then run the post again through WordPress using Tops > Scheduled Reports :

    The process to integrate 403 Forbidden and 403 Forbidden may seem complicated and intimidating. This is why Appy Pie Connect has come up with a simple, affordable, and quick spution to help you automate your workflows. Click on the button below to begin.