Skip to content

Instantly share code, notes, and snippets.

View coder0107git's full-sized avatar
🎯
Focusing...

Invalid Name coder0107git

🎯
Focusing...
View GitHub Profile
@coder0107git
coder0107git / file.gs.js
Last active August 19, 2023 22:25 — forked from yosida95/gist:4186224
Task Reminder with Google Apps Script
const USERS_SHEET_NAME = "users",
TASKS_SHEET_NAME = "tasks",
SPREADSHEET_URL = "https://docs.google.com/spreadsheets/d/abc123456/edit", /* TODO(Developer): Replace the spreadsheet ID */
/* Use `SpreadsheetApp.getActiveSpreadsheet()` if the Apps Script was created from a Google Sheet. */
spreadsheet = SpreadsheetApp.openByUrl(SPREADSHEET_URL);
const getEmailByNickname = (() => {
const usersSheet = spreadsheet.getSheetByName(USERS_SHEET_NAME);
let userEmailTable = {};