This module inserts Webform submissions as new rows in Google Spreadsheets.

Requires Webform 4 and a little bit of configuration.

The Drupal 6 version of this module has been removed as it relied on the Google Docs API which was decommissioned by Google in April, 2015. The Drupal 7 version has been refactored to work with the Google Drive API.

Configuration

  1. Go to https://console.developers.google.com and create a new project.
    • Give it a name.
    • Enable the Drive API under "APIs & auth" » "APIs".
    • Create a new `OAuth client ID` under "APIs & auth" » "Credentials"
      1. The type is `Web Application`
      2. The origin is your full URL, e.g. `https://www.example.com`
      3. The authorized redirect is `[the full URL from step ii]/webform_to_gdocs/oauth2callback` with a newline at the end.
      4. Note that it may take several minutes before your redirect URL propagates across Google's network in order for the next step to work.
  2. On the admin page (`admin/config/content/webform/gdocs`), enter the client details that you were given in step iii.
  3. Click the authorize button and follow the instructions to authorize your site.

Once configured, you'll be able to administer any existing or new Webforms by visiting a form and clicking the "Google Docs" tab.

Project information

Releases