Google Sheets for WordPress contact forms with weForms add-on allows you to integrate/synchronize google sheets with weForms. If you integrate a sheet with a specific form, the data from your form fields will automatically save on the sheet after every successful submission.
Enabling Google Sheets Integration
Navigate to– wp-admin → weForms → Modules → Enable Google Sheets integration.
Authenticating Google Sheets
Again navigate to- wp-admin → weForms → Settings → click on Authenticate Google Sheets
Verify Google Account to Integrate with weForms
Allow weForms to access your Google Drive folders and files to link or integrate.
You’ll get a access code after providing all of the necessary permissions. Please copy & paste the code to the ‘access code’ field and click on ‘Verify Code’ button.
Integrating Google Sheet with weForms
Navigate to wp-admin → weForms → All Forms → edit/create a form → Integrations.
The numbers indicates:
- Enable/Disable the Google Sheets.
- Select Google Spreadsheet (File must already exist in your Google Drive).
- Select the specific sheet of the spreadsheet. (i.e. Sheet1 or Sheet2)).
- Click the ‘Setup Sheet Header’ button (This will create the header row according to your form field if you use it in a blank sheet).
- Save form.
Submit a Demo Form
Here you go! Just save the page, open in preview mode, and submit a demo form like below.