Find Jobs
Hire Freelancers

Google App Script to work with Mandrill API to send Auto Emails

$30-250 USD

Closed
Posted about 4 years ago

$30-250 USD

Paid on delivery
Hi, I need to send auto e-mails to some of our customers based on the data on specific cells in my Google Spreadsheet. I do not want to send the emails from gmail account. I have another domain for the email which is not gmail. So I need to use mandrill api to use our own domain. The summary of this project is: 1- Auto emails to the customers in the spreadsheet 2- These auto emails would be triggered at a time in a day and based on an information on specific cells. And also it should be OK when I want to send 3- Email's domain should be another email which is not gmail as I will tell. I have mandrill account with verified domain and APIs Thank you
Project ID: 23461691

About the project

7 proposals
Remote project
Active 4 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
7 freelancers are bidding on average $217 USD for this job
User Avatar
Hi there, I will be happy to help you with this. I have checked Mandrill API reference and examined the endpoint used to send emails. The script will run using a time driven trigger within a specific time, like between 1am to 2am daily, read the data from the spreadsheet and send the emails based on a specific criteria, as we will discuss together, using the API endpoint. I have the required experience and worked with various APIs using Google script. I will be happy to address any of your questions! Sincerely, Mohamed
$150 USD in 7 days
5.0 (43 reviews)
5.6
5.6
User Avatar
Hi, I'm an experienced Google Apps Script developer. I've written several Google Apps Scripts for Google Sheets for fetching information from the Web APIs. So far I've implemented eBay, Walmart, Houzz, QuickBooks Online, Amazon MWS, BigCommerce, and Oxford Dictionaries APIs in Google Sheets using Google Apps Scripts. I can automate for you the operation of sending emails to your customers using the cell information you desire via your Mandrill account using their API. I can also set a trigger in Google Apps Script which will get triggered at a particular time which you will specify. I can also create a custom menu for you through which you can send an email to a particular customer whenever you want. So, if you'd like to discuss your project with me then feel free to send me a message even when I'm offline. I usually reply back within a few minutes when I'm online and within a few hours when I'm offline.
$150 USD in 5 days
4.9 (31 reviews)
5.8
5.8
User Avatar
Greetings! I am placing the current avarage price now and we can discuss it later. I am available to start work immediately and will be glad to discuss further details via chat if you still search for someone. Have over 10 years of experience as Web Expert and exstensive knowledge in javascript, software architecture, google app engine, google maps api. Best Regards! Toma :)
$196 USD in 7 days
5.0 (16 reviews)
5.2
5.2
User Avatar
A custom PHP script running as a CRON job on your webhosting server could be periodically executing your custom scenario as well as give you the option to trigger the execution manually. The PHP script would 1. Access your Google Spreadsheet using the PHP client library of the Google Sheet API. oAuth authentication will be required. 2. Access a configured Google Sheet of your Spreadsheet and read configured cells 3. Prepare the data for the upload to your Mandrill account 4. Access your Mandrill account using the official Mandrill PHP client and send one or more transactional messages with or without your prepared templates Please contact me - with the PHP version you want to support - a sample of your Spreadsheet with all relevant information It is possible to deploy the script to your server and configure all relevant details. The project is possible to complete within 3 days upon acceptance. shopify, google sheets and amazon aws s3 integration ==================================================== A PHP script for dropshipping of online shopify orders, inserting new rows to google sheets, notifying the merchant and the supplier with e-mails; accessing amazon aws s3 buckets to fetch necessary fulfillment data, deploying the solution on a created, configured amazon ec2 instance. PHP, GoogleSheets Api, Amazon Aws S3 Api, Amazon EC2, Shopify Api
$86 USD in 3 days
5.0 (7 reviews)
5.3
5.3

About the client

Flag of TURKEY
istanbul, Turkey
0.0
0
Payment method verified
Member since Dec 9, 2017

Client Verification

Other jobs from this client

CRM Building
$750-1500 USD
Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.