I'm not sure how to do this. I asked ChatGPT and it seems I need to have a Google Cloud Console access so I can get some credentials which will allow me to upload to a GDrive folder. Not sure if this is correct.
What we need to do is read data from a db already in GCP then run a query which will place it on a spreadsheet. Everyday this will be updated.