I would like to write a script in Google Scripts (link: [login to view URL])
The script will search for a very specific email in my Gmail inbox. It will then take the Excel attachment out of that email and convert it into a google doc spreadsheet file. The file will be saved in a specific folder within Google Drive.
All of the files saved into a Google Drive folder from Par 1 will have a specific set of columns (Employee ID, Employee Name, Department, Hire Date). The script will create or update a summary file that will compare the 2 most recently downloaded data files and will create a sheet that has the following columns (Employee ID, Employee Name, Department, Hire Date (old), and Hire Date (new).
Please email me with any questions and I can walk through the details.
Hi I'm Jonathan, I already have a Google Script that iterates over all of the mail in your gmail inbox and pull out the Excel attachments. These files are then added to a specific folder within google drive. All that Daha Fazla
Bu iş için 3 freelancer ortalamada $112 teklif veriyor
Hi, This work is not that simple as you have anticipated for. I can make Google Apps Script for you. I need some pecimen emails to work on. Thanks.