Write google scrips to automate mail management.
$250-750 USD
Paid on delivery
Spec:
Solution to automate personalised subscribed email feed with Google
Apps / Drive / Gmail etc.
Overview:
I have customer specific content that I need to automatically send in
emails at pre-set times periodically throughout the day.
Components:
A series of HTML and or plain text files on Google Drive
A co-ordinating Google Sheet which will contain amongst other things:
- Send date & time / send Yes/No flag
- Client email address
- Email subject
- Google Drive File ID (or whatever is required to identify the
content to be sent)
- Progress / Log
Script 1: Scheduled process to query the sheet and send HTML or plain
text emails via Gmail using the body contained in the referenced file.
Script 2: Manually triggered process to upload HTML or Text files
containing email body per customer per date
Other details:
I have a manual process currently with no automation. I have the
customer specific email body content that needs to be sent and this
can be generated for the next x days / months. I plan to generate
these files as new clients come on-board, and re-generate then as
changes are required. The upload script should facilitate the
uploading of these files to the client folder, maintaining the
reference integrity for later sending. I would expect basic logging,
resuming, error handling and summary reporting
Project ID: #9619235
About the project
10 freelancers are bidding on average $574 for this job
I have been developing php and mysql programs for 10 years. I have developed and managed some web sites. So I think I can do it so that you satisfy. I am looking forward to being hired by you. I hope to meet you la More
Hello, As per the description, you are looking for an automation script which will send a set of content to specific group of recipient automatically at pre-defined intervals. Do you want ti to be in php or dot net? More
Hi, can help. Progress / Log must be in the same spreadsheet (in another sheet) where all other components is set up? Do you want run script manually from spreadsheet menu? Regards, Viktor
Hello Sir, We are an Indian development company here. we have checked your posted details here and want more clarification in it, so message us to discuss on it more then we will able to move on it. Thanks
I am gure of Apps script, latest project was modification of spreadsheets via talking to an external system via SOAP. please read my reviews. I am 100% completion rate person.
Dear Client, It's nice to see your requirement for writing google apps script to automate email sending mechanism. I have been working extensively on google apps acript for automation related to Google Docs, She More