1. Home
  2. Docs
  3. WPForms GSheetConnector PRO
  4. Google Sheet Tab Configuration

Google Sheet Tab Configuration

Once its Integrated as per the above instruction,

You can select the Contact Form you want to link with GSheet, click on edit and navigate to Google Sheet Pro tab.

select tab name Google Sheet Tab Configuration

Now you will see all the sheets from your account in the dropdown, you can select the sheet name where you want to save the fields. (make sure you have to create the google sheet manually from your google account if you create a sheet after authorizing with google, you need to click below to fetch sheets again, where it indicates, Not showing Sheet Name, Tab Name, and Sheet URL Link? Click here to fetch it.)

After Selecting Sheet Name, you will get see the tab name in the second dropdown. Go ahead and select the tab name too.

Another way to integrate

If you want to integrate Google sheet manually, unable to check the box of Enable Manually adding of sheet name and tab name.

Once you will enable it, the Google sheet integrate interface will change. Now you have to add Google Sheet Name, Sheet tab Name, Sheet ID, and Tab ID manually.

google sheet setting in gsheet connector

In this process, you have to fill up all the fields manually.

Copy Sheet name and Tab name, paste in their filed, after that, Copy Sheet ID and Tab ID, paste it in GSheet Connector WPForms.

google sheet and tab id

  • After connecting Google Sheet with add-on, now you have to set up Field List.

Field list Google Sheet Tab Configuration

Now, you need to configure FieldList.

Version 2.2 Update (We have Decrypted these settings, so you’ll see new settings)

WPForms Google Sheet Settings Google Sheet Tab Configuration

Go to the appropriate form Settings >> GSheetConnector Pro and Select “On” to Enable Settings

WPForms Google Sheet New Settings Google Sheet Tab Configuration

  • You can create New Sheet From the settings

WPForms Google Sheet Enable Feed Google Sheet Tab Configuration

  • If an already sheet exists, you can select your sheet

GSheetConnector Feed Settings Google Sheet Tab Configuration

  • Now Select the fields required in Sheet as a headers

Form Settings Select Field Values Google Sheet Tab Configuration

  • After selecting fields Enable Show Header Management and arrange your headers in the order you want and don’t forget to tick update headers for this Submission then only Headers will be passed in the sheet, Otherwise, sheet headers will not update.

WPForms Header Management Google Sheet Tab Configuration

Smart Tags Settings

WPForms Smart Tags Google Sheet Tab Configuration

  • We have also enabled other features, like Freeze Headers, and Free Header Color, Odd/Even Rows Color as well

WPForms GSheet Freeze Color Google Sheet Tab Configuration

How can we help?