Skip to content

Instantly share code, notes, and snippets.


Michael MacMillan MacMillanSearch

View GitHub Profile
MacMillanSearch / adding_stat_reports_to_google_sheets.js
Last active December 12, 2022 16:21
Adding Stat Reports to Google Sheets using App Scripts
View adding_stat_reports_to_google_sheets.js
function onOpen() {
var ui = SpreadsheetApp.getUi();
ui.createMenu('Manual Update')
.addItem('Import Keywords', 'importKws')//Copy to add additional functions
var SEARCH_QUERY = " subject:Download your STAT report: " //stat report email address and subject
var COMPANY_NAME = "MacMillan Search" //company name variable that we put in parentheses when we create the report in Stat