Michael MacMillan MacMillanSearch
MacMillanSearch
/ adding_stat_reports_to_google_sheets.js
Last active
December 12, 2022 16:21
Adding Stat Reports to Google Sheets using App Scripts
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| //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 | |