Google Sheets

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

Related: Google Analytics Integration

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:

1. Enable/Disable the Google Sheets.
2. Select google SpreadSheet (File must consist in your google drive).
3. Select the specific sheet of the SpreadSheet. (Sheet1 or Sheet2 or else).
4. Click the ‘Setup Sheet Header’ button(This will create the header row according to your form field if you use in a blank sheet).
5. 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

Walk-through of the module