Find Jobs
Hire Freelancers

Basic Google Sheets Script to Email Spreadsheet when change is made

£10-20 GBP

In Progress
Posted almost 5 years ago

£10-20 GBP

Paid on delivery
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
Project ID: 20019106

About the project

4 proposals
Remote project
Active 5 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
4 freelancers are bidding on average £43 GBP for this job
User Avatar
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
5.0 (108 reviews)
6.3
6.3
User Avatar
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 always believe in Long Term Relationship. Hope we will do the same. I am good at Google App Script, I will be using that to mail you the data. I will be happy to help you out. Kindly discuss with me to start the project immediately. Thanks Roljobs
£38 GBP in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
London, United Kingdom
5.0
4
Payment method verified
Member since Jan 6, 2016

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.