1. Home
  2. Docs
  3. Modules
  4. Google Sheets

Google Sheets

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.

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

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 providing all of 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

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 already exist in your Google Drive).
  3. Select the specific sheet of the spreadsheet. (i.e. Sheet1 or Sheet2)).
  4. 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).
  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
Sheet synchronisation with weForms

Walk-through of the module

Was this article helpful to you? Yes 1 No