This module adds a Webform handler that automatically appends new Drupal Webform submissions as rows to a specified Google Sheets worksheet. It allows you to choose which data from your submissions is sent, handle complex field types, and format dates for easier review and reporting in Google Sheets.
Description
Webform Google Sheets adds a Webform handler that appends new Drupal Webform submissions to a selected Google Sheets worksheet using the Google Sheets API.
It is useful for teams that collect leads, applications, surveys, event registrations, support requests, or operational intake forms in Drupal but need the submitted data available in Google Sheets for review, reporting, handoff, or lightweight workflows.
➡Features
- Append each new Webform submission as a row in Google Sheets.
- Configure the integration per webform through Webform handlers.
- Connect through Google API Client using a Google service account or OAuth client.
- Select the target spreadsheet and worksheet from a Google Sheets URL.
- Choose which submission data and element values are sent.
- Support multi-value and composite Webform elements.
- Optionally preserve empty values or combine multi-value answers into one column.
- Convert submission timestamps into Google Sheets-friendly date/time values.
- Dispatch success and error events for custom integrations, logging, and monitoring.
Requirements
- Drupal 10.3 or Drupal 11
- Webform module (^6.0)
- Google API Client module (^4.0)
- Google Cloud Platform access with Google Sheets API enabled.
Documentation
Overview
How Webform submissions are added to the Google Sheet spreadsheet using the Google API PHP Client and a Google service account.
Install and configure
Step-by-step instructions for installing and configuring the Webform GoogleSheets module, including setting up the Google Sheets API, creating a service account, generating a private key, and configuring the Google API PHP Client module.
Configure webform
How to configure webform to append rows to Google Sheets spreadsheet using the handler provided by this module.
Troubleshooting
Resolve common issues with Webform GoogleSheets.