Claude Models

Overview

Claude by Anthropic is known for its strong reasoning capabilities, safety features, and long context windows. SheetMagic supports all major Claude model families.

API Key: Get your API key at console.anthropic.com/settings/keys

Chat Models

Claude 4.5 Series (Latest)

Claude 4.1 Series

Claude 4 Series

Claude 3.7 Series

Claude 3.5 Series

Claude 3 Series

Model Tiers

Opus (Most Capable)

• Best for: Complex analysis, research, creative writing
• Context: 200K tokens
• Strengths: Nuanced reasoning, detailed outputs

Sonnet (Balanced)

• Best for: General tasks, content generation, coding
• Context: 200K tokens
• Strengths: Balance of quality and speed

Haiku (Fastest)

• Best for: Quick tasks, simple queries, high-volume operations
• Context: 200K tokens
• Strengths: Speed, cost-efficiency

Model Capabilities

Usage Examples

Basic Text Generation

=AITEXT("Write a detailed analysis of renewable energy trends")

Code Generation

=AITEXT("Write a Python function to calculate compound interest with monthly contributions")

Content Summarization

=AITEXT("Summarize this article in 3 bullet points: " & A1)

Translation

=AITEXT("Translate to Spanish: " & A1)

Key Features

Long Context Window

Claude models support up to 200K tokens of context, allowing you to:

• Process entire documents
• Analyze long-form content
• Maintain conversation history

Safety & Alignment

Claude is designed to be:

• Helpful and harmless
• Honest about limitations
• Resistant to jailbreaks

Constitutional AI

Claude uses Constitutional AI training, making it:

• More reliable for business use
• Better at following guidelines
• Less prone to harmful outputs

Configuration

Temperature

Controls creativity/randomness (0-1):

• 0: Deterministic responses
• 0.5: Balanced (default)
• 1: More creative

Max Tokens

Controls maximum response length. Claude supports large outputs up to the context limit.

Best Practices

1. Choose the Right Model

2. Leverage Long Context

Claude excels at processing long documents:

=AITEXT("Analyze this entire document and provide key insights: " & VISIT(A1))

3. Use Clear Instructions

Claude responds well to structured prompts:

=AITEXT("Task: Write a product description
Product: " & A1 & "
Tone: Professional
Length: 100 words
Include: Features, benefits, call-to-action")

4. Batch Processing

For high-volume tasks, use Haiku for cost efficiency:

// Configure SheetMagic to use claude-3-5-haiku
// Then process hundreds of cells efficiently

Pricing Considerations

Claude pricing is based on:

• Input tokens (your prompt)
• Output tokens (response)
• Model tier (Opus > Sonnet > Haiku)

Limitations

• No image generation: Claude doesn't create images
• No speech synthesis: No TTS capabilities
• No video generation: No video creation

For these features, use OpenAI, Gemini, or other providers.