In Progress

Basic Google Sheets Script to Email Spreadsheet when change is made

I've got a google sheet I want a script to send active cells on a tab whenever the values change

I've created a basic version of the spreadsheet here.

[login to view URL]

So the tab "SH in 5 days" is automatically populated from the data in Sheet2. The data in "SH in 5 days" will always be formulas so the code needs detect formula outputs rather than pure cell values. As the date progresses, more data will appear or be deleted from this tab.

What I basically want is the code to use in google scripts to email an html table of the whole table. If the table is blank then send nothing (if A1 = 1 send the email, if A1 = "" send nothing). I am happy to set up the trigger if you can write the code.

Any more questions please ask

Skills: Google Cloud Platform, Javascript

See more: google apps script email verification, google apps script query spreadsheet, \ google sheets script\ , alert by email when input data on google spreadsheet meets given condition, send email when google sheet is updated, google sheets send email based on date, automatically email google spreadsheet, google sheets send email based on cell value, send email when value changes in google spreadsheet, google sheets send email when new row added, google sheets email trigger, \ google sheets\ script, google apps script email trigger, google sheets script, google sheets script editor, google sheets script functions, google sheets script permissions, google sheets script examples, google apps script share spreadsheet, google apps script attach spreadsheet

About the Employer:
( 3 reviews ) London, United Kingdom

Project ID: #20019106

Awarded to:

BaNgan

Hi, The trigger for the sheet will be onEdit to detect the value on column A (or cell A1 only? ) Thanks Ngan Le

£20 GBP in 7 days
(264 Reviews)
7.2

7 freelancers are bidding on average £34 for this job

gangabass

I can provide you a Google Script code that you can use onChange event. It will generate a HTML table from your tab and send it as email just like you want. I can complete it in less than a day for just £100.

£100 GBP in 1 day
(58 Reviews)
5.5
anjalisinghoffc3

Hello, After reading your offer this looks like a perfect fit for my skill sets. I have built a large number of creative designs /Development for different businesses. My name is shivangi tiwari and I am an India More

£18 GBP in 1 day
(0 Reviews)
0.0
evonsystems7

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned "I can do th More

£18 GBP in 7 days
(1 Review)
0.0
yousafkh9

Hi, I can fully automate this job exactly as you needed, though I will ask for few questions to clear my head. Here is my Experience details: [login to view URL]~01110eb9b9d95bb6be/ More

£28 GBP in 1 day
(0 Reviews)
0.0
freelancer596

Hi, We are a team of Enthusiastic Designers and Developers, who believes to work and think out of the box. We love to explore new things, Our Designers / Developers will make your projects satisfying your needs. We More

£38 GBP in 2 days
(0 Reviews)
0.0
rahulshinde781

I have experience in working with google sheet with google appengine and google appscipt. You will definitely get the quality work as you expected

£15 GBP in 1 day
(0 Reviews)
0.0