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.
You can use a connection like this to more easily share form submissions in one place. A common use case may be populating a spreadsheet for an event registration. With all form submissions in one place, you can easily share the data without having to add someone to your WordPress site.
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. You now have enabled your WordPress Google Sheets integration with weForms.