Find Jobs
Hire Freelancers

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
Project ID: 10353234

About the project

3 proposals
Remote project
Active 8 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
Awarded to:
User Avatar
let's do it Hello, I have good experience dealing with Google apps script and looking to do this project for you. Regards.
$55 AUD in 1 day
4.8 (5 reviews)
3.9
3.9
3 freelancers are bidding on average $53 AUD for this job
User Avatar
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
$60 AUD in 1 day
5.0 (1 review)
2.4
2.4

About the client

Flag of AUSTRALIA
Sydney, Australia
5.0
22
Payment method verified
Member since Mar 24, 2014

Client Verification

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.