Em Andamento

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

Habilidades: Google Cloud Platform, Javascript

Veja mais: 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

Acerca do Empregador:
( 3 comentários ) London, United Kingdom

ID do Projeto: #20019106

Concedido a:

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 em 7 dias
(264 Comentários)
7.2

7 freelancers estão ofertando em média £34 para esse trabalho

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 em 1 dia
(58 Comentários)
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 Mais

£18 GBP em 1 dia
(0 Comentários)
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 Mais

£18 GBP in 7 dias
(1 Comentário)
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/ Mais

£28 GBP em 1 dia
(0 Comentários)
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 Mais

£38 GBP in 2 dias
(0 Comentários)
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 em 1 dia
(0 Comentários)
0.0