Gmail to Drive, Automatically Download .CSV file based on Label
Budget: $30 – $250 USD
Hello, I'd like to set up an automated system that will recognize inbound gmails (which qualify under a certain "Label" criteria), and then automatically save the attachment (will be a .csv file) to a specified folder within my google drive. I'd like for this to only happen one time on new emails received, and not ever again on the same email.
I'd then like for the specified google drive folder to automatically upload (will be daily) the .csv to a google sheet. I'd like for the google sheet to delete its contents on a daily basis as well so as to make room for the new, incoming, daily .csv file.
I've found a few information sources online that may be helpful to the contractor, but I'm not sure how to put them all together.
https://developers.google.com/apps-script/samples/automations/import-csv-sheets
https://support.google.com/mail/thread/4931894/automatically-save-gmail-attachments-on-google-drive?hl=en
https://github.com/ahochsteger/gmail2gdrive/blob/v2/Code.gs
Thanks so much for your interest
I'd then like for the specified google drive folder to automatically upload (will be daily) the .csv to a google sheet. I'd like for the google sheet to delete its contents on a daily basis as well so as to make room for the new, incoming, daily .csv file.
I've found a few information sources online that may be helpful to the contractor, but I'm not sure how to put them all together.
https://developers.google.com/apps-script/samples/automations/import-csv-sheets
https://support.google.com/mail/thread/4931894/automatically-save-gmail-attachments-on-google-drive?hl=en
https://github.com/ahochsteger/gmail2gdrive/blob/v2/Code.gs
Thanks so much for your interest