Skip to content

Instantly share code, notes, and snippets.

View reidjs's full-sized avatar
:shipit:
TODO: write a clever status

Reid JS reidjs

:shipit:
TODO: write a clever status
View GitHub Profile
@reidjs
reidjs / email-drafter.js
Created September 14, 2022 16:28 — forked from katydecorah/email-drafter.js
Draft emails in Gmail from a Google spreadsheet and a Google doc template: https://katydecorah.com/code/google-sheets-to-gmail-template/
// What is the Google Document ID for your email template?
var googleDocId = "abcd0000abcd0000abcd0000abcd0000";
// Which column has the email address? Enter the column row header exactly.
var emailField = 'Email';
// What is the subject line?
var emailSubject = 'You\'re bringing {Type}!';
// Which column is the indicator for email drafted? Enter the column row header exactly.
var emailStatus = 'Date drafted';
/* ----------------------------------- */