In this video I make form scratch a real time and up to date Crypto tracker in Google Sheets that you can use in your own projects!
Here is the Formula I spoke about: =VALUE(SUBSTITUTE(SUBSTITUTE(INDEX(IMPORTDATA(” “price:”,””), “”””, “”))
Here is the notification script:
function readCell() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName(“Sheet1”);
var value = sheet.getRange(“C5”).getValue();
if(value (more than )50) sendEmail(value);
};
function sendEmail(value) {
var email = “email@gmail.com”;
var subject = “Auto Alert Notification, Value of cell C5 is now ” + value+” (greater than 50)”;
var body = “This is an automated generated email, Value of cell C5 is now ” + value + ” (greater than 50)”;
var oauthConfig = UrlFetchApp.addOAuthService(“google”);
oauthConfig.setAccessTokenUrl(”
oauthConfig.setRequestTokenUrl(”
oauthConfig.setAuthorizationUrl(”
oauthConfig.setConsumerKey(“anonymous”);
oauthConfig.setConsumerSecret(“anonymous”);
MailApp.sendEmail(email,subject,body);
};