We'll create fresh WordPress site with WPForms Google Sheet Connector installed. You have 20 minutes to test the plugin after that site we'll be deleted.
This is an Addon Plugin of WPForms, A bridge between your WordPress based WPForms and Google Sheets. It helps to record the entries in real-time.
When a visitor submits the form on your website from the frontend using WPForms, upon the form submission, such responses/filled entries are also sent to Google Sheets.
Compatible with WPForms Lite and PRO Versions
Homepage | Documentation | Support | Demo | Premium Version
Get a rid of making mistakes while adding the sheet settings or adding the headers manually to the sheet column. We have Launched the WPForms Google Sheet Connector Pro version with more automated features.
β Custom Google API Integration Settings
β Allowing to Create a New Sheet from Plugin Settings
β Custom Ordering Feature / Manage Fields to Display in Sheet using Enable-Disable / Edit the Fields/ Headers Name to display in Google Sheet.
β Using all the Smart Tags Fields in Headers
β Syncronize Existing Entries for WPForms PRO users
β Freeze Header Settings
β Header Color and Row Odd/Even Colors.
Refer to the features and benefits page for more detailed information on the features of the WPForms Google Sheet PRO Addon Plugin
Google Sheet URL to Check submitted Data
Step: 1 – In Google Sheets
β Log into your Google Account and visit Google Sheets.
β Create a new Sheet and name it.
β Rename or keep default name of the tab on which you want to capture the data.
β Copy Sheet Name, Sheet ID, Tab Name and Tab ID (Refer Screenshots)
Step: 2 – In WordPress Admin
β Navigate to WPForms > Google Sheet > Integration Tab.
β Authenticate with Google using new “Google Access Code” while clicking on “Get Code”
β Make Sure to ALLOW Google Permissions for Google Drive and Google Sheets and then copy the code and paste in Google Access Code field, and Hit Save & Authenticate.
β Then, Navigate to GoogleSheet Form Settings Tab Selected respective WPForm from the dropdown with which you want to connect with Google Sheet.
β Now copy and paste the Google Sheets sheet name and tab name into respective input fields, and submit.
Step: 3 – Arranging Columns in Sheet
β In the selected Google sheet, enter column names in first row (as a header) as per the Label, Copy and Paste the form field label from the WPForms to Google Sheet (e.g. “Name”, “Email”, “Comment or Message”, “date” etc).
β Lastly Test your WPForms and verify that the data shows up in your Google Sheet.
πWPForms Forms Google Sheet Connector Introduction Video
β 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.