BACKGROUND: I work in a small construction business. On a regular basis, I get emailed time sheets that I use to attach to / write invoices with.
Would it be possible to
- Send an automatic received receipt exclusively to emails that send time-sheet type image or PDF attachments.
Label the Gmail with 1 or 2 separate labels like "time-sheets" and "downloaded"( read next part )
send the attachment to a specific google drive folder.
What I actually do
- I have Gmail filters that automatically label emails as "timesheets."
- I do a search in my Gmail for:
to:[email protected] has:attachment
- I then look at attachments to make sure they are in fact actually time-sheets
- Then I give a one-word email reply "Received."
- I download the file to my specific Google drive folder.
- Then I label the email as: "Downloaded"
Ideas I've tried or entertained:
A chrome-app that cache's ALL attachments with a specific label to a Google drive folder.
Problem is that I can't distinguish If it is an older email I've already invoiced or a new one that needs to be invoiced.
Ask subcontractor's / employees to use a specific string in their subject line like "#time-sheets" help better identify emails at specifically time sheets rather than any attachment.
Have subcontractors enter information into a Google form in place of a time sheet, that populates a spreadsheet ... that generates an invoice.
Problem: I need a builders signature on every time sheet to validate work performed by employees / subcontractors.*
Use a PDF form and websites like HelloSign & Acrobat's version of that.
Problem: I really don't know where to learn how to make these, or if they will properly solve my problem of automating received receipts and depositing said PDF's into a Google drive folder.