1. Home
  2. Docs
  3. WPForms GSheetConnector P...
  4. Plugin Setting

Plugin Setting

Integration of WPForms with Google Sheet:

After successfully completing the integration with Google using your preferred method and configuring the necessary permissions as described in the last article, proceed to your WPForms Google Sheet dashboard – Form Setting. From there, select the specific Contact Form that you intend to configure for use with Google Sheets. This will allow you to set up the desired form-to-Google Sheets connection according to your requirements.

Fetch Sheets by clicking on “Click here to fetch it”.

WPForms Google Sheet Integration Settings

Go to Contact Form :

Go to WPForms dashboard – All Forms.

Edit Form that you want to configure with Google Sheet.

WPForms Google Sheet Integration Settings

Feed Setting :

Now go to Form Setting, In GSheetConnector Enable Setting: on.

WPForms Google Sheet Integration Settings.

Multi Sheet Connection :

Add New Feed if you want to connect with more than one Google Sheet.

Feel free to add as many feeds as you need to meet your requirements.

WPForms Google Sheet Integration Settings

Automatic adding Sheet Name & Tab Name :

Next, you will find both Manual and Automatic Selecting Methods for choosing the sheet you want to work with. If your sheets are not visible in the dropdown menu, you can click on the “Fetch Sheets” link below to retrieve them.

Select Google Sheet & Tab Name and scroll below to configure.

WPForms Google Sheet Integration Settings

Note: Use Manual Method if You have too much Google Sheets.

Manually adding Sheet Name & Tab Name :

In Manual Method You have to Manually Add Google Sheet Name, Google Sheet Id, Google Sheet Tab Name & Google Sheet Tab Id.

Add Manually Google Sheet Info like this.

Save & Submit Data.

WPForms Google Sheet Integration Settings

Form Field :

Enable the fields you wish to view in your Google Sheet by Enabling Fields or Check all to check all the fields.

You can also Rename it.

WPForms Google Sheet Integration Settings

Request Headers :

Smart Tags are Default Fields like date, time, etc.

Add smart tags like this :

  1. click on show smart tags
  2. select smart tag that you want to add.
  3. give name that you want to see in google sheet.
  4. you can add another smart tag like this.

WPForms Google Sheet Integration Settings

Custom Ordering :

In Custom Order Setting you can sort fields for Google Sheet.

WPForms Google Sheet Integration Settings

Freeze Header :

By enabling Freeze Header, Your header will be stuck to the top in Google Sheet.

WPForms Google Sheet Integration Settings

Background Colors :

By enabling Alternate Colors, you can get background colours

  • Header Color : Header Color is for background color for Header.
  • Odd Color : Odd Color is for background color for odd rows.

  • Even Color : Even Color is for background color for even rows.

WPForms Google Sheet Integration Settings

Sheet Sorting :

You can Sort Columns in Ascending & Descending order.

WPForms Google Sheet Integration Settings

Conditional Logic :

The most common use of conditional logic is to show or hide fields in google sheet depending on a user’s selection.

For example, we’ll ask users if they’d like to fill our demo form. However, we only want email address in “@gmail.com”, are they interested in “Pro Version” & Reference is “WP Repository”.

If you would like to know more about WPForms Conditional Logic.

WPForms Google Sheet Integration Settings

Sync to Google Sheet :

Sync to Google Sheet to sync all your entries to Google sheet.

WPForms Google Sheet Integration Settings

Note: You Should have Any Premium Version of WPForms to SYNC Entries with Google Sheet.

How can we help?