Google Sheet

Transform semi-structured Google Sheet data

Requirements

In order for datapipe to download and transform a Google Sheet file. The following setup must be done or obtained.

  1. Identify the Google Sheet ID, see here

  2. Enable Google Sheet sharing, see here and do either of the following:

    1. Turn on "Public" sharing

    2. Turn on "Anonymous" sharing

    3. Turn on private sharing to datapipe service email account