File Source: Google Drive (file name: varies, but let's say Data.csv)
File Destination: Google Cloud Storage bucket (bucket name: data)
Automation tool: Power Automate
File Overwrite: Yes if file name already exists
Automation Cadence: Weekly
Is this possible? I don't see a GCP or GCS connector in Power Automate. But can I use a HTTP PUT/POST action? I'm not clear on my next steps.
I found these 2 pages about uploading objects using REST api and JSON api: https://cloud.google.com/storage/docs/uploading-objects#rest-upload-objects and https://cloud.google.com/storage/docs/json_api/v1/objects/insert but I'm not sure how to translate the information into Power Automate HTTP action inputs. The REST api requires an access token which makes sense to me, but the JSON api doesn't mention it at all, so how would the POST action tell my "data" bucket apart from potentially another organisation's "data" bucket if there's no identifier?
My Power Automate flow is currently sitting like this:
Any help would be appreciated.