Use Anthropic's Claude API via Google Spreadsheets with AppScript

script.js

// REMINDER: Replace YOUR_API_KEY with your actual Anthropic API key

const ANTHROPIC_API_KEY = 'YOUR_API_KEY';
const ANTHROPIC_API_URL = 'https://api.anthropic.com/v1/messages';

/**
 * Generates a response using Claude via the Anthropic API.
 *
 * @param {string} prompt - The input prompt for Claude.
 * @return {string} The generated response from Claude.
 * @customfunction
 */
function generateClaude(prompt) {
  const options = {
    'method': 'post',
    'headers': {
      'Content-Type': 'application/json',
      'x-api-key': ANTHROPIC_API_KEY,
      'anthropic-version': '2023-06-01'
    },
    'payload': JSON.stringify({
      'model': 'claude-3-5-sonnet-20240620',
      'max_tokens': 4000,
      'messages': [
        {
          'role': 'user',
          'content': prompt
        }
      ]
    })
  };

  try {
    const response = UrlFetchApp.fetch(ANTHROPIC_API_URL, options);
    const json = JSON.parse(response.getContentText());
    return json.content[0].text;
  } catch (error) {
    return 'Error: ' + error.toString();
  }
}

/**
 * Adds a custom menu to easily reload the script.
 */
function onOpen() {
  var ui = SpreadsheetApp.getUi();
  ui.createMenu('Claude API')
    .addItem('Reload Script', 'reloadScript')
    .addToUi();
}

/**
 * Reloads the script to update any changes.
 */
function reloadScript() {
  SpreadsheetApp.getActive().toast('Script reloaded successfully!');
}