danielcranney · November 1, 2024 10:19
diff --git a/04 - connect to Google sheet.js b/04 - connect to Google sheet.js
 // Logs emails from threads labeled "unsubscribed" to a Google Sheet
 function logUnsubscribes() {
  var label = GmailApp.getUserLabelByName('unsubscribed'); // Fetch the "unsubscribed" label from Gmail
  var threads = label.getThreads(); // Get all threads with this label
  var sheet = SpreadsheetApp.open(DriveApp.getFileById('REPLACE_WITH_GOOGLE_SHEET_ID')); // Open the target Google Sheet
 }
	// Logs emails from threads labeled "unsubscribed" to a Google Sheet
	function logUnsubscribes() {
	var label = GmailApp.getUserLabelByName('unsubscribed'); // Fetch the "unsubscribed" label from Gmail
	var threads = label.getThreads(); // Get all threads with this label
	var sheet = SpreadsheetApp.open(DriveApp.getFileById('REPLACE_WITH_GOOGLE_SHEET_ID')); // Open the target Google Sheet
	}