MacMillanSearch

var api_key = "YOUR_SERPAPI_KEY_HERE"; // Replace with your actual SerpAPI key
var fixedLocation = 'United States'; // Replace with your location

function onOpen() {
  var ui = SpreadsheetApp.getUi();
  ui.createMenu('SERP Update')
    .addItem('Update SERP Info', 'updateSerpInfo')
    .addToUi();
}

MacMillanSearch

// You must set SerpAPI private API Key
// https://serpapi.com/dashboard

var api_key = "YOUR_SERPAPI_KEY_HERE"; // Replace with your actual SerpAPI key
var fixedDomain = 'example.com'; // Replace with your domain
var fixedLocation = 'United States'; // Replace with your location

function onOpen() {
  var ui = SpreadsheetApp.getUi();
  // Create a menu with a name (e.g., 'SERP Update')

MacMillanSearch

//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