Needed: Google Workspace API programmer to help create some automations between my Google Workspace email and Google Drive.
When I receive an email which contains an invoice or receipt within the email body or as an attachment, I would like your help to create an automation like:
When an email is sent from X[@][login to view URL] to Y[@][login to view URL] and the first word in the subject line = Z, then save the email body as a pdf and upload the pdf and any attached files to [Z drive folder]".
Some further rules will need to be applied to the destination folder since I would like a destination folder structure like:
Root Folder >
Folders for Month-Year (eg: December-2021) >
Paid / Not Paid
Backstory: Instead of using Dex or some other SaaS, our accountant wants to use Google Drive to store receipts and invoices. I want to automate sending him these receipts by forwarding them to a single email and the automations do the proper sorting and filing of the content into the desired folders based on the key words I put in the subject line.