Webform GoogleSheets

Description

This module allows appending Webform submissions to Google Sheets.

Requirements

• Webform module (^6.0)
• Google API Client module (^4.0)
• Google Cloud Platform access with Google Sheets API enabled.

Installation

1. Execute composer require drupal/webform_googlesheets and enable Webform Google Sheets module.
2. Make sure Google API Client module is properly configured.
3. Create a new Google Sheet and copy its URL. Your URL must be in this format: https://docs.google.com/spreadsheets/d/1NwAk7YDnuGwzCsUeKFFad-XcYYdUBRh9RT9dEb2aR54/edit#gid=0
4. Go to Webforms list page (admin/structure/webform) and click Edit on desired Webform.
5. Click Emails/Handlers secondary tab and then click on Add handler button.
6. Click on Add handler button on Google Sheets row.
7. Fill in the form. Paste your Google Sheets URL in the required field. Select Google API Client. Select the fields you'd like to be appended to the spreadsheet.

Maintainers

elaman (http://ima.sh/)