SheetMagicSheetMagic
AI Providers

Google Gemini Models

Complete list of Google Gemini models supported by SheetMagic including Gemini 2.5, Imagen, and Veo

Overview

Google Gemini offers a comprehensive suite of AI models for text, image, and video generation. Gemini models are known for their multimodal capabilities and strong performance.

API Key: Get your API key at aistudio.google.com/app/apikey

Chat Models (Text Generation)

Gemini 2.5 Series (Latest)

Model IDNameFeatures
gemini-2.5-proGemini 2.5 ProMost capable, advanced reasoning
gemini-2.5-flashGemini 2.5 FlashFast, efficient
gemini-2.5-flash-liteGemini 2.5 Flash-LiteFree tier available

Gemini 2.0 Series

Model IDNameFeatures
gemini-2.0-flashGemini 2.0 FlashBalanced performance
gemini-2.0-flash-liteGemini 2.0 Flash-LiteFast, lightweight

Image Generation Models

Imagen 4 Series

Model IDNameDescription
imagen-4.0-ultra-generate-001Imagen 4 UltraHighest quality
imagen-4.0-generate-001Imagen 4Standard quality
imagen-4.0-fast-generate-001Imagen 4 FastOptimized for speed

Gemini Image

Model IDNameDescription
gemini-2.5-flash-imageGemini 2.5 Flash ImageIntegrated image generation

Usage with AIIMAGE

=AIIMAGE("A serene Japanese garden with cherry blossoms, photorealistic")

Video Generation Models

Veo Series

Model IDNameDescription
veo-3.0-generate-001Veo 3High-quality video generation
veo-3.0-fast-generate-001Veo 3 FastFaster video generation

Usage with AIVIDEO

=AIVIDEO("A drone shot flying over mountains at sunrise, cinematic quality")

Model Capabilities

Gemini 2.5 Pro

CapabilitySupport
Chat completionsYes
Multimodal inputYes
Code generationExcellent
Long context1M tokens
ReasoningAdvanced

Gemini 2.5 Flash

CapabilitySupport
Chat completionsYes
Multimodal inputYes
Code generationGood
Long context1M tokens
SpeedVery Fast

Gemini 2.5 Flash-Lite

CapabilitySupport
Chat completionsYes
Basic reasoningYes
Free tierYes
SpeedFastest

Free Tier Models

Google Gemini offers free tier access to certain models:

ModelFree Tier
gemini-2.0-flash-liteYes
gemini-2.0-flash-expYes
gemini-2.5-flash-liteYes

Free tier models have rate limits. For production use, ensure you have API credits available.


Key Features

Massive Context Window

Gemini 2.5 supports up to 1 million tokens of context:

  • Process entire codebases
  • Analyze lengthy documents
  • Handle complex multi-turn conversations

Multimodal Understanding

Gemini can process:

  • Text
  • Images
  • Audio
  • Video

Google Integration

Gemini benefits from Google's infrastructure:

  • Fast inference
  • Reliable uptime
  • Global availability

Usage Examples

Text Generation

=AITEXT("Explain quantum computing in simple terms")

Code Generation

=AITEXT("Write a React component for a responsive navbar with dropdown menus")

Image Generation with Imagen

=AIIMAGE("Professional product photography of a smartwatch, white background, studio lighting")

Video Generation with Veo

=AIVIDEO("Timelapse of a flower blooming, macro photography, 4K")

Configuration

Temperature

Controls creativity (0-2):

  • 0: Deterministic
  • 1: Balanced (default)
  • 2: Creative

Max Output Tokens

Set maximum response length based on your needs.


Best Practices

1. Choose the Right Model

Use CaseRecommended
Complex analysisGemini 2.5 Pro
Quick tasksGemini 2.5 Flash
Free tier usageGemini 2.5 Flash-Lite
Image generationImagen 4
Video generationVeo 3

2. Leverage Long Context

Use Gemini's 1M token context for large documents:

=AITEXT("Analyze this entire codebase and suggest improvements: " & VISIT(A1))

3. Multimodal Tasks

Combine text and image analysis:

=AITEXT("Describe this image and suggest marketing copy: " & A1)

4. Image Quality Selection

Quality NeedModel
Marketing materialsImagen 4 Ultra
General useImagen 4
Quick draftsImagen 4 Fast

Pricing Considerations

Google Gemini pricing varies by:

  • Model tier (Pro > Flash > Flash-Lite)
  • Input/output tokens
  • Image generation (per image)
  • Video generation (per second)

Free Tier Limits

  • Limited requests per minute
  • Lower priority during peak times
  • Suitable for testing and light usage

Comparison with Other Providers

FeatureGeminiOpenAIClaude
Max context1M tokens128K200K
Image genImagen 4DALL-E 3-
Video genVeo 3Sora 2-
Free tierYesLimitedNo
TTSNoYesNo