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
- Log in to your LLM API dashboard
- Click Create Key to Start
- Copy your new API key immediately — it will only be shown once
- Store the key securely (e.g., in a password manager or
.envfile)
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
- Install SheetAI from the Google Workspace Marketplace.
- Open a Google Sheet and go to Extensions → SheetAI → Settings.
- Enter:
- API Key: paste the key you copied from app.llmapi.ai/api-keys
- API Endpoint: https://api.llmapi.ai/v1
- Click "Save".
- 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?