Saves the attachments from senders you nominate into a Google Drive folder, and labels the mail so nothing is filed twice.
Uses
Gmail
Google Drive
File email attachments into Google Drive
Run every hour.Run every hour.
Set senders to blank.Set senders to blank.Set driveFolderUrl to blank.Set driveFolderUrl to blank.Set filedLabel to Filed to Drive.Set filedLabel to Filed to Drive.Set filedLines to an empty list.Set filedLines to an empty list.
Split senders by , and save it as senderList.Split senders by , and save it as senderList.
For each sender in senderList:For each sender in senderList:Trim sender and save it as address.Trim sender and save it as address.
If address is emptyIf address is emptyYes
Skip to the next item.Skip to the next item.No
No steps
Set latestMatch to nothing.Set latestMatch to nothing.
If a step below fails, save the error as searchErrorIf a step below fails, save the error as searchErrorTry
GmailFind email matching 'from:address has:attachment'. Save it as latestMatch.Find email matching 'from:address has:attachment'. Save it as latestMatch.On error
Show in the output: Could not search mail from address - searchError as text.Show in the output: Could not search mail from address - searchError as text.Skip to the next item.Skip to the next item.Set latestMessageId to blank.Set latestMessageId to blank.If a step below fails, save the error as latestIdErrorIf a step below fails, save the error as latestIdErrorTry
Trim latestMatch.email.id and save it as latestMessageId.Trim latestMatch.email.id and save it as latestMessageId.On error
Change latestMessageId to blank.Change latestMessageId to blank.If latestMessageId is emptyIf latestMessageId is emptyYes
Show in the output: No mail with attachments from address to file.Show in the output: No mail with attachments from address to file.Skip to the next item.Skip to the next item.No
No steps
Set filedMatch to nothing.Set filedMatch to nothing.If a step below fails, save the error as filedSearchErrorIf a step below fails, save the error as filedSearchErrorTry
GmailFind email matching 'from:address has:attachment label:@filedLabel'. Save it as filedMatch.Find email matching 'from:address has:attachment label:@filedLabel'. Save it as filedMatch.On error
Show in the output: Could not check what has already been filed for address - filedSearchError as text.Show in the output: Could not check what has already been filed for address - filedSearchError as text.Skip to the next item.Skip to the next item.Set filedMessageId to blank.Set filedMessageId to blank.If a step below fails, save the error as filedIdErrorIf a step below fails, save the error as filedIdErrorTry
Trim filedMatch.email.id and save it as filedMessageId.Trim filedMatch.email.id and save it as filedMessageId.On error
Change filedMessageId to blank.Change filedMessageId to blank.If latestMessageId is filedMessageIdIf latestMessageId is filedMessageIdYes
Show in the output: The latest attachments from address are already in Drive.Show in the output: The latest attachments from address are already in Drive.Skip to the next item.Skip to the next item.No
No steps
Set downloaded to nothing.Set downloaded to nothing.If a step below fails, save the error as downloadErrorIf a step below fails, save the error as downloadErrorTry
GmailDownload the attachments on email latestMessageId. Save it as downloaded.Download the attachments on email latestMessageId. Save it as downloaded.On error
Show in the output: Could not download the attachments from address - downloadError as text.Show in the output: Could not download the attachments from address - downloadError as text.Skip to the next item.Skip to the next item.Set savedFromSender to 0.Set savedFromSender to 0.For each attachment in downloaded.documents:For each attachment in downloaded.documents:Set attachmentRef to blank.Set attachmentRef to blank.If a step below fails, save the error as referenceErrorIf a step below fails, save the error as referenceErrorTry
Trim attachment.document_ref and save it as attachmentRef.Trim attachment.document_ref and save it as attachmentRef.On error
Change attachmentRef to blank.Change attachmentRef to blank.If attachmentRef is emptyIf attachmentRef is emptyYes
Show in the output: Skipped an attachment from address because it was not stored and cannot be uploaded.Show in the output: Skipped an attachment from address because it was not stored and cannot be uploaded.Skip to the next item.Skip to the next item.No
No steps
Set attachmentName to attachment.Set attachmentName to attachment.If a step below fails, save the error as nameErrorIf a step below fails, save the error as nameErrorTry
Trim attachment.filename and save it as attachmentName.Trim attachment.filename and save it as attachmentName.On error
Change attachmentName to attachment.Change attachmentName to attachment.If attachmentName is emptyIf attachmentName is emptyYes
Change attachmentName to attachment.Change attachmentName to attachment.No
No steps
Set attachmentType to application/octet-stream.Set attachmentType to application/octet-stream.If a step below fails, save the error as typeErrorIf a step below fails, save the error as typeErrorTry
Trim attachment.content_type and save it as attachmentType.Trim attachment.content_type and save it as attachmentType.On error
Change attachmentType to application/octet-stream.Change attachmentType to application/octet-stream.If attachmentType is emptyIf attachmentType is emptyYes
Change attachmentType to application/octet-stream.Change attachmentType to application/octet-stream.No
No steps
Set saved to nothing.Set saved to nothing.If a step below fails, save the error as uploadErrorIf a step below fails, save the error as uploadErrorTry
Google DriveUpload file attachmentRef. Save it as saved.Upload file attachmentRef. Save it as saved.On error
Show in the output: Could not save attachmentName from address to Drive - uploadError as text.Show in the output: Could not save attachmentName from address to Drive - uploadError as text.Skip to the next item.Skip to the next item.Add 1 to savedFromSender.Add 1 to savedFromSender.Set savedLink to blank.Set savedLink to blank.If a step below fails, save the error as linkErrorIf a step below fails, save the error as linkErrorTry
Trim saved.upload_link and save it as savedLink.Trim saved.upload_link and save it as savedLink.On error
Change savedLink to blank.Change savedLink to blank.Set filedLine to attachmentName from address.Set filedLine to attachmentName from address.If savedLink isn't emptyIf savedLink isn't emptyYes
Change filedLine to filedLine - savedLink.Change filedLine to filedLine - savedLink.No
No steps
Add filedLine to the end of filedLines and save it as filedLines.Add filedLine to the end of filedLines and save it as filedLines.If savedFromSender is greater than 0If savedFromSender is greater than 0Yes
If a step below fails, save the error as labelErrorIf a step below fails, save the error as labelErrorTry
GmailAdd label filedLabel to email latestMessageId.Add label filedLabel to email latestMessageId.On error
Show in the output: Filed the attachments from address but could not label the email, so they may be filed again on the next run.Show in the output: Filed the attachments from address but could not label the email, so they may be filed again on the next run.No
Show in the output: No attachments from address were saved this time.Show in the output: No attachments from address were saved this time.If filedLines is emptyIf filedLines is emptyYes
Show in the output: Nothing new to file - the latest attachments from every sender are already in Drive..Show in the output: Nothing new to file - the latest attachments from every sender are already in Drive..No
Show in the output: Filed the length of filedLines as text attachment(s) into Drive:Show in the output: Filed the length of filedLines as text attachment(s) into Drive:
filedLines joined by a new line.