rvbautista

//This function will send email notifs to your active Google account to prompt you to send emails to the listed customers. 
//Taken from https://mccarthydanielle.medium.com/trigger-email-reminders-based-on-dates-in-google-sheets-9aa2060d7aa2
//Originally made by mccarthydanielle https://gist.github.com/mccarthydanielle/

//Test

function emailAlert() {
  // today's date information
  var today = new Date();
  var todayMonth = today.getMonth() + 1;

rvbautista

/**
 * Retrieves all the rows in the active spreadsheet that contain data and logs the
 * values for each row.
 * For more information on using the Spreadsheet API, see
 * https://developers.google.com/apps-script/service_spreadsheet
 */
function readRows() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var rows = sheet.getDataRange();
  var numRows = rows.getNumRows();

rvbautista

Forked and modified from ljones140's code for exporting calendar dates from google calendar to google sheets. Please link to this page if you like this. Thank you!

Modifications from original code:

• Automatically detects the Google account you use so no need to hardcode your email address
• Automatically scans cells B3 and D3 for the starting and end dates, respectively

This code is part of tutorial here:

===from ljones140's description