In order for datapipe to download and transform a Google Sheet file. The following setup must be done or obtained.
Identify the Google Sheet ID, see here
Enable Google Sheet sharing, see here and do either of the following:
Turn on "Public" sharing
Turn on "Anonymous" sharing
Turn on private sharing to datapipe service email account