WPMet Site Logo
  • Home
  • Plugins
    • ElementsKit
    • ShopEngine
    • GetGenie AI
    • MetForm
    • WP Social
    • WP Fundraising
    • Wp Ultimate Review
  • About
  • Blog
  • Support
  • Contact
  • My Account
WPMet Site Logo

Connecting WordPress Forms to Google Sheets: A Beginners Guide

AbeerHAbeerH Updated on: February 28, 2023 MetForm Tutorials 6 Min Read
Connect WordPress Forms to Google Sheets

An effective way of collecting customer information is through forms. WordPress forms are an easy solution for creating forms on your website. But managing and storing form data can be a challenge. That’s where integrating Google Sheets can help. When you connect WordPress forms to Google sheets, you can easily store, manage, and analyze your form data.

With this integration, every time a form is submitted on your WordPress website, the data will automatically be stored in a Google Sheet. By integrating your WordPress forms with Google Sheets, you can streamline your data collection process and gain valuable insights from the submissions. 

In just three simple steps, you can connect your WordPress forms to Google Sheets and start collecting and analyzing valuable customer data.

Contents hide
What is the significance of Connecting WordPress Forms to Google Sheets?
How to connect WordPress Forms to Google Sheets?
Step 1: Setting up a project in the Google Cloud console
Step 2: Enable Google Sheets API
Step 3: Integrate Google Sheets with MetForm
Google Sheet integration with Elementor Pro form using ElementsKit
In Conclusion

What is the significance of Connecting WordPress Forms to Google Sheets?

When you connect WordPress form to Google Sheets, it allows you to automatically collect and store form submissions in a spreadsheet. This eliminates the need to manually transfer data from the form to a spreadsheet, saving time and reducing the risk of errors.

Additionally, it allows multiple users to access the data at the same time and also can be helpful for backup and stressful recovery. Connecting WordPress Forms to Google Sheets allows for streamlined data management and improves the overall efficiency of data collection and organization.

Once the data is stored in a spreadsheet, it can be easily organized, sorted, and filtered, making it easy to find the information you need. Google Sheet integration with WordPress form can help you in various ways:

  • Data collection: By connecting WordPress forms to Google Sheets, all the forms data will be automatically collected and organized in a Google Sheet, making it easier to manage and analyze.
  • Real-time updates: As soon as someone submits a form on WordPress, the data will be instantly updated in the linked Google Sheet, giving you real-time access to your data.
  • Ensures accuracy: This eliminates the need for manual data entry and ensures the accuracy of the information collected.
  • Data Sharing: On Google Sheets, multiple people can access the same data at the same time, allowing for easier teamwork and collaboration.
  • Email list building: By collecting contact information through a form, you can easily build an email list that you can use for targeted marketing campaigns.
  • Easy backup and recovery: Data recovery in Google sheets is much easier and safe in Google Sheets. Even if you delete the Google sheet file, it can be recovered from Google Drive’s trash folder.

Overall, connecting a WordPress form to a Google Sheet can help you make better use of the data you collect and improve your overall business performance.

How to connect WordPress Forms to Google Sheets?

When it comes to connecting WordPress forms to Google Sheets, MetForm comes with the easiest way. You just have to integrate the Google credentials with MetForm in your WordPress site and will be able to export data to GoogleSheets.

Connecting WordPress forms to Google sheets with MetForm involves three major steps. The first step is setting up the Google cloud console platform for form integration. Secondly, enable the Google Sheet API, and finally, integrate MetForm with the Google API app.

Prerequisites:

We need you to have an account on the Google Cloud Platform. So if you don’t have an account, create one before starting the form integration procedure.

Required plugins:

  1. Elementor: Download Plugin
  2. MetForm Lite: Download Plugin
  3. MetForm Pro: Get Plugin

Step 1: Setting up a project in the Google Cloud console

Now you need to create an App on the Google cloud console to get the integration credentials for Google Sheets. The process includes creating a new project, then registering an App, and generating the credentials for integration.

Create a new project

First, log in to your Google Cloud console account and create a new project. Click on the drop-down at the top left corner, and on the popup click on the New Project.

Create new project on Google cloud console to connect WordPress forms to Google sheets

To create a new project, enter a Project name and location (if applicable), and click on the Create button.

Create project on Google cloud console

It may take a few seconds to create the project. Open the notification bar to check if the project has been created. Once the process is complete, click on the project you just created to open the project page.

select project on Google cloud console

App registration

After that, open the project dashboard, and under the API section, Go to APIs overview.

Open Oauth concent screen for App registration on Google Cloud Console

Next, open the OAuth consent screen from the sidebar. Then on the OAuth consent screen select the User Type to External and proceed by clicking on the “Create” button. 

On the next screen, enter your App information including your App name and User support email. You can also add the App logo and App domain information. Then enter the Authorized domains and Developer contact information, and click on Save and Continue. 

Register app in Google cloud console

Then proceed to the Scopes and Test Users tabs, which are optional. You may add information if desired, or leave them unchanged. then, click on the save button.

Finally, Publish the App from the OAuth consent screen.

Generate App credentials 

Now go to the Credentials, click on Create Credentials and select OAuth client ID. To create an OAuth client ID, choose Application type to “Web application” and enter a name.

Generate Oauth Client credentials

In order to proceed, you have to add an Authorized redirect URI. You will get this redirect URL from your WordPress dashboard if you have the MetForm plugin activated on your site.

Copy MetForm redirect URI from WordPress dashborad to connect WordPress forms to Google sheets

Open a new tab on your web browser and log in to your WordPress site. Navigate to your WordPress dashboard > MetForm > Settings > Google Sheet Integration. There you will find the redirect URI, copy that and go back to the Credentials page on the Google cloud console.

Create OAuth client ID for connecting WordPress forms to Google sheets

After adding the Authorized redirect URI, click on the “Create” button.

Once the OAuth client is created, you will get your Client ID and Client Secret on a popup window. Copy those credentials and move to the next step.

Copy OAuth client ID and client secret

Verify with App Credentials

Now, again navigate to WordPress dashboard > MetForm > Settings > Google Sheet Integration and paste the Google Client Id and Google Client Secret on the required field. Then click on the Save changes button.

After that, click on Generate Access Token in order to approve the access for the app.

Verify OAuth client credentials on WordPress dashboard

Step 2: Enable Google Sheets API

In the next step, go to the project dashboard on Google Cloud Console, and navigate to the API library of the current project. 

Find the Google Sheets API and open it. Then Enable the API.

Enable Google Sheets API

Step 3: Integrate Google Sheets with MetForm

The final step is to integrate the WordPress form into Google Sheets.

For an existing form, click on Edit under the form to open the form settings. Move to the Integration tab and enable the Google Sheet.

Integrate Google Sheets with MetForm

That’s it. Google sheet integration with MetForm is complete now. Now submit the data and your WordPress form will send those directly to Google sheets.

Data export from WordPress form to Google sheets

Let’s see how it works. For example, we will be showing two types of forms: 

  • General forms (such as event registration forms, feedback forms, etc.)
  • Quiz forms.

General Forms:

To send data to Google Sheets from WordPress forms like event registration forms, contact forms, and feedback forms, you can create a general form with MetForm.

For that, go to MetForm > Forms > Add new. Then in the “Create Form” popup, enter a Form name and choose the form type General Form.

MetForm has dozens of form templates available including templates:

  • Contact forms
  • Booking forms
  • Feedback forms
  • Subscription forms
  • Support forms
  • Event Registration form
  • Newsletter sign-up forms

And more.

You can choose one template and proceed by clicking on the “Edit Form” button. After that, as shown in Step 3, the Form Settings, enable Google Sheet integration to connect WordPress forms to Google Sheets.

Export data from WordPress form to Google Sheets:

WordPress Form Submission:

Submission in WordPress form after connecting with Google form

Exported data in Google Sheets:

Exported data in Google sheet from WordPress form

Quiz Form:

You can also create quiz forms using MetForm. For that, navigate to MetForm > Forms > Add new and select the form type “Quiz Form” and click on the Edit form button to design a quiz form. Also, don’t forget to enable Google sheets integration in the Form settings as shown in Step 3.

Export data from WordPress form to Google Sheets:

WordPress Quiz Form Submission:

Quiz form submission in WordPress after connecting to Google Sheet

Exported quiz data in Google Sheets:

Exported quiz form data in Google sheet

Google Sheet integration with Elementor Pro form using ElementsKit

There is another way to connect WordPress forms to Google Sheets. This method is particularly for Elementor Pro forms.

You can connect Elementor Pro forms to Google Sheets using ElemensKit. To do so, generate Google credentials (Client ID & Client Secret) for ElementsKit OAuth redirect URI. Then add the credentials in the ElementsKit > User Settings > Google Sheet For Elementor Pro Form and generate an access token.

After that, create an Elementor Pro form and the data will be sent to Google Sheets for each submission.

Read the documentation on integrating the Elementor Pro form with Google Sheets:

Learn how to integrate Elementor Pro form to Google Sheets with ElementsKit

In Conclusion

If you have followed the above steps, you should be able to connect WordPress forms to Google Sheets and the form submission data are seamlessly exported to Google Sheets.  

MetForm offers a range of convenient and ready-to-use features to meet everyone’s needs. Get MetForm Pro and have next-level experience in building WordPress forms!

  • Share :

GetGenie vs. NeuronWriter: Which AI Content Generator is Worth Picking?

Previous post

Top 7 WordPress AI Content Generators

Next post

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Get Subscribed Today!

WPMet Site Logo
© 2022, Wpmet. All Rights Reserved. Built with ElementsKit.

Company

About us
Contact us
Support
Blog
Collaborate
Documentation

Resources

Affiliates
Affiliate Area
Privacy Policy
Terms & Conditions
Refund Policy
Login/Register

Our Products

Elements Kit
ShopEngine
GetGenie Ai
Metform
WP Social
Wp Ultimate Review
Wp Fundraising

Follow Us

Payment systems accepted by Wpmet

Wpmet is not affiliated with or endorsed by Open Source Matters or the WordPress Project. The CMS logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.

We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies.
Opt out!.
Cookie SettingsAccept
Manage consent

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. These cookies ensure basic functionalities and security features of the website, anonymously.
CookieDurationDescription
cookielawinfo-checkbox-analytics11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional11 monthsThe cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy11 monthsThe cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.
Functional
Functional cookies help to perform certain functionalities like sharing the content of the website on social media platforms, collect feedbacks, and other third-party features.
Performance
Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.
Analytics
Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics the number of visitors, bounce rate, traffic source, etc.
Advertisement
Advertisement cookies are used to provide visitors with relevant ads and marketing campaigns. These cookies track visitors across websites and collect information to provide customized ads.
Others
Other uncategorized cookies are those that are being analyzed and have not been classified into a category as yet.
Vendor/Partner
SAVE & ACCEPT