LLM API
GuidesData Analysis

SheetAI Integration

Connect SheetAI to LLM API for AI-powered capabilities

SheetAI brings AI capabilities directly into Google Sheets. It provides formulas and functions powered by language models for text generation, classification, extraction, and more.

SheetAI supports custom API keys for model access.

Prerequisites

  • An LLM API account with an API key
  • SheetAI installed or accessible

Setup

Get Your LLM API Key

  1. Log in to your LLM API dashboard
  2. Click Create Key to Start
  3. Copy your new API key immediately — it will only be shown once
  4. Store the key securely (e.g., in a password manager or .env file)

LLM API is an OpenAI-compatible gateway that gives you access to dozens of AI models through a single API key and endpoint.

Configure LLM API in SheetAI

  1. Install SheetAI from the Google Workspace Marketplace.
  2. Open a Google Sheet and go to Extensions → SheetAI → Settings.
  3. Enter:
  4. Click "Save".
  5. Use =SHEETAI() formulas in your spreadsheet.

Test the Integration

Verify that SheetAI can successfully communicate with LLM API by sending a test request. All requests will now be routed through LLM API.

SheetAI formulas work with LLM API to bring AI capabilities to your spreadsheet workflows.

Benefits of Using LLM API with SheetAI

  • Multi-Provider Access: Use models from OpenAI, Anthropic, Google, and more through a single API
  • Cost Control: Track and limit your AI spending with detailed usage analytics
  • Unified Billing: One account for all providers instead of managing multiple API keys
  • Caching: Reduce costs with response caching for repeated requests

View all available models on the models page.

How is this guide?