function getGoogleAutocompleteSuggestions(keyword) {  try {    // Construct the URL for the API request    const apiUrl = `https://www.google.com/complete/search?q=${encodeURIComponent(keyword)}&cp=11&client=gws-wiz&xssi=t&gs_pcrt=undefined&hl=en&authuser=0`;    // Make the HTTP GET request    const response = UrlFetchApp.fetch(apiUrl);    let content = response.getContentText();    // Clean up the response to remove invalid JSON prefix ")]}'\n"    content = content.replace(/^\)\]\}'/, "").trim();    // Parse the cleaned content into a JSON object    const json = JSON.parse(content);    // Extract the suggestions    const suggestions = json[0].map(item => {      // Decode unicode characters and remove HTML tags      return item[0]        .replace(/\\u([0-9a-fA-F]{4})/g, (_, code) => String.fromCharCode(parseInt(code, 16)))        .replace(/<\/?[^>]+(>|$)/g, ""); // Strip HTML tags    });    return suggestions;  } catch (error) {    console.error("Error fetching or processing autocomplete suggestions:", error);    return [];  }}function printSuggestion(keywordCell, startCell) {  // Get the active sheet  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();  // Get the keyword from the input cell  var keyword = sheet.getRange(keywordCell).getValue();  // Call the getGoogleAutocompleteSuggestions function to fetch suggestions  var suggestions = getGoogleAutocompleteSuggestions(keyword);  // If suggestions are found, print them horizontally starting from the specified cell  if (suggestions.length > 0) {    var range = sheet.getRange(startCell).offset(0, 0, 1, suggestions.length);    range.setValues([suggestions]);  // Set the suggestions in a single row  } else {    Logger.log("No suggestions found.");  }}// Function to print suggestions for each keyword in the selected rangefunction printSuggestionsForRange() {  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();  // Get the currently selected range (vertical range of keywords)  var selection = sheet.getSelection();  var range = selection.getActiveRange();  var keywords = range.getValues(); // This returns a 2D array  // Get the first cell to the right of the selected range (ensure it is within bounds)  var firstRow = range.getRow();  // The first row of the selection  var firstColumn = range.getColumn();  // The first column of the selection  var lastRow = range.getLastRow(); // The last row of the selection  // Get the next column to the right of the selected range  var nextColumn = firstColumn + 1;  var numColumns = sheet.getMaxColumns();  if (nextColumn > numColumns) {    // If out of bounds, alert the user    Logger.log("Error: The selection is at the edge of the sheet. There is no next column.");    return;  }  // For each keyword in the range, call the printSuggestion function  for (var i = 0; i < keywords.length; i++) {    var keyword = keywords[i][0]; // Get the keyword value from the row    var currentOutputCell = sheet.getRange(firstRow + i, nextColumn); // Output starts in the next column in the same row    // Call printSuggestion to print suggestions horizontally    printSuggestion(keyword, currentOutputCell.getA1Notation());  }}// Modified printSuggestion to work with cell rangefunction printSuggestion(keyword, startCell) {  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();  var suggestions = getGoogleAutocompleteSuggestions(keyword); // Fetch suggestions  if (suggestions.length > 0) {    // Create a range starting from the given startCell and set the values    var range = sheet.getRange(startCell).offset(0, 0, 1, suggestions.length);    range.setValues([suggestions]); // Print suggestions in a horizontal row  } else {    Logger.log("No suggestions found for: " + keyword);  }}// Function to add a custom menu to the sheetfunction onOpen() {  var ui = SpreadsheetApp.getUi();  ui.createMenu('Autocomplete Suggestions')    .addItem('Print Suggestions for Range', 'menuPrintSuggestionsForRange')    .addToUi();}// Menu function to call printSuggestionsForRangefunction menuPrintSuggestionsForRange() {  printSuggestionsForRange();}