Just in case anyone else needs to run a process reading/writing data between google docs and google sheets.
Requires a project set up on google cloud platform with Google Drive API, Google Docs API and Google Sheets API enabled.
User credentials to be downloaded as credentials.json via:
Credentials>>Create credentials>>OAuth Client ID, Desktop App, identifying client name>>Create
credentials.json goes in folder ./gcp_secrets/