Skip to content

Instantly share code, notes, and snippets.

Avatar

Michael MacMillan MacMillanSearch

View GitHub Profile
@MacMillanSearch
MacMillanSearch / adding_stat_reports_to_google_sheets.js
Last active Sep 1, 2022
Adding Stat Reports to Google Sheets using App Scripts
View adding_stat_reports_to_google_sheets.js
//menu
function onOpen() {
var ui = SpreadsheetApp.getUi();
ui.createMenu('Manual Update')
.addItem('Import Keywords', 'importKws')//Copy to add additional functions
.addToUi();
}
var SEARCH_QUERY = "from:noreply@getstat.com 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