Google Sheets

With the Google Sheets add-on, you can now send your contact form data directly to Google Sheets. You can quickly set it up by following the steps portrayed in the images below and get going instantly.

Installation #

  1. Firstly, you need to purchase the Everest Forms Pro plugin.
  2. After the successful purchase, you will get the plugin zip file under your WPEverest account page.
  3. Now, you can download the Everest Forms Pro plugin and Everest Forms Google Sheets addon from there.
  4. Through your WordPress Dashboard, visit Plugins -> Add New -> Upload and then choose the downloaded zip file and then install and activate it.
  5. Now you are ready to use this add-on for your site.

To connect Google Sheets with the Everest Forms, we need to follow these steps.
1. Authenticating Google Sheets
3. Connecting Form with the Spreadsheet.

Authenticating Google Sheets #

The first part is to authenticate Google Sheets with your site. Browse to the Integration part of Everest Forms and click on Google Sheets. Everest Forms > Settings > Integration > Google Sheets

After you click on the settings icon, you will see a button “Authenticate with Google Account” as shown in the screenshot below. Click on it.

After you click on it, a different window will open where you will be asked to choose your Google Account. Select the account and allow the permissions to integrate with Google Sheets.

Once you have selected the account and allowed the permissions, the access code will be generated. You need to copy and paste it in the settings as shown in the screenshot below. After pasting it, click on the “Verify Access Code” button.

The authentication should be completed successfully and now you can move to the second part of the tutorial.

Connecting Form with Spreadsheet #

The second part is to set up which form needs to send data to the spreadsheet. For that, you must go to the Integration Part of your form.
Go to Everest Forms > All Forms > (click on the form you want to embed sheets) > Integration > Google Sheets > Connect New Spreadsheet

After you click on it, you will be asked to enter a nickname for the connection. You can enter anything that you want. In my case, I have named it “Spreadsheet Integration“. After that you will see on the right, you will be asked to enter the “Google Spreadsheet ID” and “Google Spreadsheet Nickname“.

You can get your Google Spreadsheet ID from the URL of the spreadsheet in which you want to send the form data.
1. Visit docs.google.com/sheets and create a sheet.
2. Copy the spreadsheet ID from the URL. You only have to copy the highlighted part of the URL as shown in the screenshot below.

Now, after entering the ID and giving a name, click on “Connect Google Spreadsheet” and connection should establish fine showing you the field names if available.

You need to map your contact form fields with the spreadsheet fields, save the changes, and that’s all. The form data will be sent to Google Sheets whenever the form is submitted.

Powered by BetterDocs