Email a picture from Google drive using Google sheet
$30-250 AUD
Completed
Posted about 8 years ago
$30-250 AUD
Paid on delivery
Hi All!
I would like to be able to place an image from google drive into an the body of an email, and then send this email (body) using gmail (coded by google script).
- The picture will be in my google drive.
- The name of the picture will be one of the cell in the sheet (i.e [login to view URL] in AD2)
- Your code will verify that the name of this file exist (by matching the cell with google drive - if it there is match, proceed, otherwise it returns error)
- If there is a match, your code will extract the image and puts in the body of the email (The body of the email is in another cell in the sheet)
Notes:
- You will be a given a code base that already sends email from google sheet using app script. Hence you would have to add the functionality of "extracting the picture from google drive and add it to the body of the email " to the existing codebase")
- The existing code code picks up the body of the email in one cell in the sheet as well as the subject of the email in another.
A few little problem to fix in my current code base:
As of now, the subject of the email is picked up from column K and the body of the email is picked up form column L. I would like the change that to Subject Email = Column AB2 and Body of the Email = AC2
Deadline:
I have talked to a few devs ( who have looked at the code base and the sheet), it should not take long ( 2 hours max). It is a pretty urgent project and I d like it to be ready before Sunday 1st of May - 1 pm (Sydney time).
Codebase/existing google sheet
[login to view URL]
Looking forward to having a chat with interested bidders and get working!
Ps: if you are a legit bidder and you have read it to this far, please start your enquiry with "let's do it".
Cheers
Andrea
Let's do it
I have excellent command on Google Sheets. I have completed complex projects before involving Userforms, Macros, formulas, graphs etc. For instance
- Build a reservation system
- A system to extract data from Google Forms and mail from gmail and do some processing
- Twitter functionality like retweet, auto-tweet, and so on