Hi Community,
I hope you are doing well.
I need suggestions or referrals to create a data pipeline. My source is Google Drive and Google Sheets, and I want to read data from Drive and load it to Google Cloud Storage (GCS). I created a service account, but company policies restrict granting it access to Drive files. I've explored two approaches using user authentication, but I prefer a solution using service account authentication.
Approach 1: Cloud function code triggered to load Google Sheets data using user authentication. Approach 2: External table creation using GSheets URI and export query to GCS with Cloud Scheduler. it also using User Authentication
Can you suggest an Google service or approach that leverages service account authentication for both Drive and Google Sheets?
LinkedIn
Twitter
