1. Home
  2. Docs
  3. WPForms GSheetConnector Free
  4. How to Connect a Google Sheet with WPForms?

How to Connect a Google Sheet with WPForms?

To Connect Google Sheet and WPForms

Successfully Install WPForms and¬†GSheetConnector-WPForms Plugin then Activate the plugin through the ‘Plugins’ Screen in WordPress.

  • Use the Admin Panel > WPForms > Google Sheet screen to Add do Integration Google Access Code.
wpforms gsheet menu
  • Here you will need to integrate WPForms plugin with your Google account. Simply click on ‚ÄúGet Code‚ÄĚ button to get access code for authentication.
WPforms Get Google Access Code
  • By clicking on the get code button it will redirect you to your Gmail account. Sign in and you will get a message to allow create, edit, delete and view your Google Sheets.
permission 1
permission 2
permission 3 1 How to Connect a Google Sheet with WPForms?
  • By clicking on the Allow button you will get your access code. You can copy code and enter the code in the textbox and save it. After saving code you will see message in green that Access code saved. But do check debug log for invalid access code.
WPforms Check Deactivate Log
  • Go to Google Drive, Create a New Google Sheet and Add Google Sheet Title and Google Sheet Tab Name.
Wpforms Google Sheet
  • After integration you will lead to¬†GoogleSheet Form Settings tab. In GoogleSheet Form Settings tab there is a dropdown for select form in which you will see listing of all the forms of WPForms. You will have to select one form which you want to connect with your Googlesheet.
WPforms googlesheet Form Setting
  • After select form you will see Google Sheet Settings.
  • From the Respective Google Sheet copy-paste the “Google Sheet Title“, “Google Sheet Tab Name“, “Google Sheet ID” and “Google Tab ID” on the Google Sheets Tab in the WPForm.
google sheet setting in gsheet connector
  • You Will get Google Sheet ID and Google Tab ID from Your Google Sheet Slug (URL).
google sheet and tab id

Provide Google Sheets Column Header

  • In the Google sheets tab, provide column names in row 1. Like the first column is “Name”. For each further column, copy-paste the Form label from the WPForms form (e.g. “Name”, “Email”, “Comment-or-Message”, etc).
  • The fields name should be with a specific format like if the WPForms field label is “Comment or Message” your google sheet column name should be “Comment-or-Message” same with all the labels (e.g Firstname Lastname = “Firstname-Lastname”, zip code = “zip-code”, etc).
  • Lastly, Test your WPForms and verify that the data shows up in your Google Sheet.
  • You must pay very careful attention to your naming. This plugin will have unpredictable results if names and spellings do not match between your Google Sheets and WPForms settings.
  • Also while inputting the WPForm field label to Google Sheet follow the rules if there is an empty space between the label name it will not send the WPForm data to Google Sheet.
WPforms Google Sheet

Still not using WPForms Google Sheet Connector?

Setup takes less than 5 minutes includes importing from all old entries! using Click to Sync

Download FREE Version

How can we help?