Hi everyone, someone can I help me with an example of how to move a .csv file from gmail to Cloud Storage?
Frecuently I receive emails with a .csv attachment and I need to create an ETL to move these files from gmail to cloud storage.
Currently, I already have a flow with Microsoft AuTomate that reads gmail and saves the .csv in drive to later move it with google colab to cloud storage, but I would like to do it directly in google
While attempting to find an answer to your primary query, the codelab "Empower Your Gmail Inbox with Google Cloud Functions" may be of assistance.
By using this codelab, it would be feasible to run a cloud function whenever a gmail account received an email.
It would be required to modify the codelab for the primary objective you want to accomplish before saving it in cloud storage.
Meltano (https://meltano.com/) has a tap for extracting csv attachment in gmail : https://hub.meltano.com/extractors/tap-gmail-csv
You can combine it with the GCS loader.