Google Sheets for 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.
If you like to integrate Google Sheets with weForms, please be a valuable subscriber of us, because it’s a Pro feature!
Enabling Google Sheets Integration
Please 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 giving all the necessary permissions. Please copy & paste the code to the ‘access code’ field and click on ‘Verify Code’ button.
Integrating Google Sheet with weForms
Now, 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 consist in your google drive).
- Select the specific sheet of the SpreadSheet. (Sheet1 or Sheet2 or else).
- Click the ‘Setup Sheet Header’ button(This will create the header row according to your form field if you use 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.
Hello Sheet! Your submitted data is here