I am afraid to say there is no API provided by Google which could be used in combination with the workflow @oole created in this thread: Google sheets Reader node read automatically a google spreadsheet file from Google Drive?
However I am still experimenting with IAM Service Account Credentials API. Can’t promise anything but IAM authentication might be the last option available.