Create a button in Google Sheets row to send email with the contents of the row in the email body

$30-250 AUD

In Progress

Posted

over 3 years ago

$30-250 AUD

Paid on delivery

We use a google form and google sheet to request and track parts in our factory which are defective and need to be re-manufactured. Each row has information about the part so the machine operator can make it. Once the part has been made, we would like a button on each row that the operator can press which prompts an email to be sent to the person who requested the part. The information in that row needs to be in the email body. The email message may be something like... Subject: Your redo for 'Project' 'Level' 'Unit' is complete and ready for dispatch (the Project, Level and Unit numbers would come from cells in the row) Body: Hi 'Requested by' Your redo item is complete and ready for dispatch. Details are: (here we would list the item details from the row)

Google Sheets

Project ID: 27488080

About the project

6 proposals

Remote project

Active 4 yrs ago

Looking to make some money?

Email address

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

6 freelancers are bidding on average $85 AUD for this job

@finecodervw

Hi, As I understand you would like email functionality in Google Sheets. Keen to work on this project. Please suggest suitable to discuss further on the requirement. Recently completed Google Sheets/Google Maps based projects with good feedback. https://www.freelancer.com/projects/google-maps-api/Goolge-Maps-personal-Pins/details https://www.freelancer.com/projects/google-sheets/need-help-with-google-sheets/details https://www.freelancer.com/projects/javascript/Advanced-Google-sheet-app-script/details https://www.freelancer.com/projects/excel/Google-Sheet-Formula-24741350/details Let me introduce myself as an expert in Google spreadsheets and Google docs. I am well versed with scripting in Google spreadsheets using Apps script, writing custom functions in Google spreadsheets, creating charts, custom functions, linking spreadsheets etc. I would be happy to answer any queries that you may have. Looking forward to working with you. Thanks

$50 AUD in 1 day

5.0

(4 reviews)

2.8

@jasonpham188

Based on what you request, this is simple function that I can complete within 1 day with small budget for you.

$30 AUD in 1 day

0.0

(0 reviews)

0.0

@DenKar

Hello! There's no way of embedding a button PER ROW, but being honest, this functionality would be a little weird. So the common route would be either having one single button working for the currently selected row, or having this action as a menu option, or maybe inside a sidebar. So here I am, competent enough to implement what you want. Just drop me a line and lets discuss about the details. Sincerely, -DEN!

$100 AUD in 2 days