Gravity Forms is one of the best contact form plugins for WordPress-powered websites and blogs. It is really easy to integrate Gravity Forms with several popular web applications and online services.
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
Gravity Forms + Google SheetsAdd rows in Google sheets on new submissions in Gravity Forms Read More...
Gravity Forms + Microsoft ExcelCreate rows on Excel on new Gravity Forms submissions Read More...
Gravity Forms + ZendeskCreate Zendesk tickets for new Gravity Forms submissions Read More...
Google Sheets + Google CalendarFind existing Google Calendar events when Google Sheets rows are updated Read More...
Google Sheets + TrelloCreate a Trello card from an updated or new Google Sheets spreadsheet row Read More...
It's easy to connect Gravity Forms + Google Sheets without coding knowledge. Start creating your own business flow.
Triggers when a new specified form is submitted.
Triggers once a new spreadsheet is created.
Triggered when a new row is added to the bottom of a spreadsheet.
Trigger when a new row is added or modified in a spreadsheet.
Creates a new form entry.
Creates an entry and fires all events associated with a form submission such as notifications and add-on feeds.
Insert a new row in the specified spreadsheet.
Share Google Sheet.
Update a row in a specified spreadsheet.
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.
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.