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.

Enable google sheets

Authenticating Google Sheets

Again, navigate to- wp-admin → weForms → Settings →  click on Authenticate Google Sheets

Authenticate google sheets to integrate with weForms

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.

Give all the permission to integrate with weForms

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.

Google drive access code to integrate with weForms

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.

Configuration of google sheet to integrate with weForms

Submit a Demo Form

Here you go! Just save the page & open in preview mode and submit a demo form like below.

Form submission integrated with weForms

Hello Sheet! Your submitted data is here

Sheet synchronisation with weForms

Walk-through of the module