Webform GoogleSheets

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.