📄 Google Sheet

/**
 * Linkup API configuration
 */
const API_ENDPOINT = 'https://api.linkup.so/v1/search';

/**
 * Creates the menu item
 */
function onOpen() {
  const ui = SpreadsheetApp.getUi();
  ui.createMenu('Linkup')
    .addItem('Settings', 'settings')
    .addToUi();
}

/**
 * Shows the settings dialog to configure the API key
 */
function settings() {
  const ui = SpreadsheetApp.getUi();
  const response = ui.prompt(
    'Settings',
    'Please enter your Linkup API Key (visit https://app.linkup.so/sign-up to get your free API key)',
    ui.ButtonSet.OK_CANCEL
  );

  if (response.getSelectedButton() === ui.Button.OK) {
    const apiKey = response.getResponseText();
    if (apiKey) {
      PropertiesService.getUserProperties()
        .setProperty('LINKUP_API_KEY', apiKey);
    } else {
      ui.alert('Please enter a valid Linkup API key');
    }
  }
}

/**
 * Returns the Linkup API key
 */
function getApiKey() {
  return PropertiesService.getUserProperties().getProperty('LINKUP_API_KEY');
}

/**
 * Returns the active cell
 */
function getActiveCell() {
  return SpreadsheetApp.getActiveRange().getA1Notation();
}

/**
 * Returns cells cache
 */
function getCache() {
  return PropertiesService.getScriptProperties().getProperty('LINKUP_DATA')
      ? JSON.parse(PropertiesService.getScriptProperties().getProperty('LINKUP_DATA')) : {}
}

/**
 * Overrides cells cache
 */
function saveCache(cache) {
  PropertiesService.getScriptProperties()
    .setProperty('LINKUP_DATA', JSON.stringify(cache));
}

/**
 * Clears the cache of the active cell
 */
function deleteCellCache() {
  const cache = getCache();
  const activeCell = getActiveCell();

  if (cache[activeCell]) {
    delete cache[activeCell];
    saveCache(cache);
  }
}

/**
 * Triggered on cell edit
 */
function onEdit(e) {
  if (e.oldValue) {
    deleteCellCache();
  }
}

function askLinkup(query, include_sources) {
  if (!query) return 'Please provide a search query';

  const activeCell = getActiveCell();
  const apiKey = getApiKey();
  const cache = getCache();
  console.log("api kEY=", apiKey)
  console.log("cache =", cache)

  // Check if this search has been cached
  const existingEntry = cache[activeCell];
  if (existingEntry
      && existingEntry.query === query
      && existingEntry.include_sources === include_sources) {
    return existingEntry.response;
  }

  const options = {
    method: 'post',
    headers: {
      Authorization: `Bearer ${apiKey}`,
      'Content-Type': 'application/json',
    },
    payload: JSON.stringify({
      q: query,
      depth: 'standard',
      outputType: 'sourcedAnswer',
    }),
    muteHttpExceptions: true,
  };

  try{
    const response = JSON.parse(
      UrlFetchApp.fetch(API_ENDPOINT, options).getContentText()
    );
    if (response.answer) {
      cache[activeCell] = { query, response };
      saveCache(cache);
    }
    return response;
  } catch (error) {
    throw new Error(`Failed to process request: ${error.message}`)
  }
}

/**
 * Searches the Linkup API with the given query and returns the answer.
 * @param {string} query The search query.
 * @customfunction
 */
function LINKUP(query, includeSources=false) {
  const response = askLinkup(query, includeSources);
  const answer = response.answer || 'No answer found';

  if (!includeSources) {
    return answer;
  }

  if (response.sources && response.sources.length > 0) {
    return `${answer}\nSources: ${response.sources.map(({ url }) => url).join(':')}`
  } else {
    return `${answer}\nNo sources available`;
  }
}

=LINKUP("your query")

=LINKUP(B14)

=LINKUP("your query", TRUE)

=LINKUP(B14, TRUE)