We receive an email with a PDF attachment. I need just the DATE ENTERED column taken off of this and matched to my google sheet database. I would like to have it 100% automated if possible. Meaning once the email is received, which is usually every 2 or 3 days at random times, it would automatically download the PDF file, somehow run a script that pulls that data from just one column, and imports it into my google sheet. The identifier on the Work Order Detail is the ACCOUNT NUMBER which would map to existing files in our google sheet database.
Hours to be determined
Less than 1 month< 1 monthProject LengthDuration
I am looking for a mix of experience and value