public static void Run([TimerTrigger("0 0 0 * * *")] TimerInfo myTimer, ILogger log) { log.LogInformation($"C# Timer trigger function executed at: {DateTime.Now}"); List <InventoryAvaible> lowInventor = ReadLowInventoryDB(); if (lowInventor.Count > 0) { // send Email string json_lowInventor = JsonConvert.SerializeObject(lowInventor); UtilsQuerys uq = new UtilsQuerys(); UserAdmin user = uq.getUserAdmin(); string sendgridApi = Environment.GetEnvironmentVariable("SENDGRID_API_KEY"); string fromEmail = Environment.GetEnvironmentVariable("FROMEMAIL"); string fromUser = Environment.GetEnvironmentVariable("FROMUSER"); var adminEmail = user.email; var adminName = user.fullName; var client = new SendGridClient(sendgridApi); var from = new EmailAddress(fromEmail, fromUser); var subject = "Alarm we need more supplies"; var to = new EmailAddress(adminEmail, adminName); //var plainTextContent = json_lowInventor; StringBuilder strHtml = uq.getTemplateEmail("low_supplies", json_lowInventor); string htmlContent = strHtml.ToString(); var msg = MailHelper.CreateSingleEmail(from, to, subject, " ", htmlContent); Task <Response> response = client.SendEmailAsync(msg); response.Wait(); var rep = response.Result; } else { log.LogInformation($"We have enough supplies!! "); } }