I've found an interesting sollutuion for me to apply for Software Test Engineer position at many different companies using Google Script, Google Document and Google SpreadSheet. First of all you will need to prepare a document with your CV in Google Docs. Then create a spreadsheet where you will store information about employers to whom you've sent and e-mail already. Name cells in the top row with next strings [Date sent, e-mail, Job Title, Company, Additional Info, email sent?]. Those are our 6 collumns in spreadsheet file. In a spreadsheet file go to Tools->Script Editor and prepare a Google Script function that will compose an e-mail and send it to employer with attached CV document (in openById method use document id that can be found by opening the document itself and looking at the URL of browser). In my case it looks like: function send_resume(email,jtitle,company){ You can change it to suite your needs. Now we need a function that will check our spreadsheet file for new entries and send CV to those that are new. var EMAIL_SENT = "EMAIL_SENT"; Now feel the document with information ("email sent?" column leave blank). And run the send() script from spreadsheet Tools -> Script Manager. The script will get all data from the spreadsheet in Range from 2-nd column of 2-nd row to 6 column of last not empty row. If 6 column of the row does not contain the "EMAIL_SENT" then cv will be sent to this recipient. That is a great feature for me, as I can easily compose, send and remember employers. And you can make it to run every day automatically. It will check the list and e-mail the CV with cover letter to every added recipient.
0 Comments
Leave a Reply. |
NoticeI have removed Russian content from my website and now will post articles in English only. This is not because of some politics, Russian speaking people you are great, but just it is very hard to support bilingual web site in Weebly. For those who read my articles as usual I ask to click on a single advertisement banner on my web site. This gives me some credits and is free of charge for you. Archives
August 2016
Categories
All
|