Technical Documentation

Complete installation guide and usage instructions for SheetPro AI

Table of Contents

1. Installation Guide

Step-by-step installation

2. Configuration

API keys and settings

3. Usage Guide

Functions and examples

Installation Guide

Prerequisites

  • ✓ A Google™ account with access to Google Sheets™
  • ✓ API keys from at least one AI provider (Google Gemini™ recommended for free usage)
  • ✓ Modern web browser (Chrome, Firefox, Safari, Edge)

Step-by-Step Installation

1

Access Google Workspace™ Marketplace

Open any Google Sheets™ document and follow these steps:

1. In Google Sheets™, click on "Extensions" in the menu bar 2. Select "Add-ons" → "Get add-ons" 3. Search for "SheetPro AI" in the marketplace 4. Click on the SheetPro AI extension

Alternative: Visit the Google Workspace™ Marketplace directly and search for "SheetPro AI"

2

Install the Extension

Complete the installation process:

1. Click "Install" button on the SheetPro AI page 2. Review the permissions requested 3. Click "Continue" to proceed 4. Select your Google™ account 5. Click "Allow" to grant necessary permissions

Permissions Required: SheetPro AI needs access to your Google Sheets™ to provide AI functionality and make external API calls to AI providers.

3

Post-Installation Setup

After installation, configure your AI providers:

1. In any Google Sheets™ document, click "Extensions" 2. Select "SheetPro AI" → "Settings" 3. Add your API keys for desired AI providers 4. Test the connection with a simple function like =GEMINI_2_5_FLASH_PREVIEW("Hello") 5. Start using AI functions in your spreadsheets!

Success: You can now use AI functions directly in your Google Sheets™!

Configuration & API Setup

API Keys Configuration

🆓 Google Gemini™ (Recommended - Free)

Get your free Google Gemini™ API key:

1. Visit: https://aistudio.google.com/apikey 2. Sign in with your Google™ account 3. Click "Create API Key" 4. Copy the generated key 5. Paste it in SheetPro AI Settings → Google Gemini™ API Key

Free Tier: 500-1500 requests per day, no cost

Optional: Additional AI Providers

OpenAI (GPT-4o, GPT-4o mini)

Get API key: OpenAI Platform

Pay-per-use pricing

Claude (Anthropic)

Get API key: Anthropic Console

Pay-per-use pricing

DeepSeek

Get API key: DeepSeek Platform

Very affordable pricing

Perplexity

Get API key: Perplexity Account

Web search enabled AI

Complete Usage Guide

Basic AI Functions

Google Gemini™ Functions (Free)

=GEMINI_2_5_FLASH_PREVIEW("Analyze this data and provide insights") =GEMINI_2_5_PRO_PREVIEW("Translate to French: " & A1) =GEMINI_2_0_FLASH("Summarize the key points from " & B1:B10) =GEMMA_3_27B("Generate a creative story about AI")

OpenAI Functions

=GPT_4O("Analyze market trends for " & A1) =GPT_4O_MINI("Quick summary: " & B1) =GPT_4O_SEARCH_PREVIEW("Latest news about " & C1) =GPT_4O_MINI_SEARCH_PREVIEW("Current price of " & D1)

Claude Functions

=CLAUDE_OPUS_4("Strategic analysis of " & A1:A10) =CLAUDE_SONNET_4("Creative writing task: " & B1) =CLAUDE_HAIKU_4("Quick analysis: " & C1)

Structured Output Functions

=GEMINI_2_5_FLASH_PREVIEW_LIST("Top 10 benefits of " & A1) =GPT_4O_TABLE("Create comparison table for " & B1 & " vs " & C1) =CLAUDE_SONNET_4_LIST("List steps to implement " & D1)

Use _LIST suffix for bullet points, _TABLE suffix for structured tables

Advanced Usage Examples

Data Analysis

=GEMINI_2_5_PRO_PREVIEW("Analyze this sales data and identify trends: " & A1:D20)

Analyzes a range of sales data and provides insights

Content Generation

=GPT_4O("Write a product description for: " & A1 & " with features: " & B1:B5)

Generates marketing content based on product information

Combining with Google Sheets™ Functions

=IF(A1>100, GPT_4O("High value analysis: " & A1), GEMINI_2_5_FLASH_PREVIEW("Standard analysis: " & A1))

Uses conditional logic to choose different AI models based on data values

AI Chart Generation

Using the Sidebar

1. Open the SheetPro AI sidebar: Extensions → SheetPro AI → Charts

2. Select your data range

3. Choose an AI model

4. Describe what kind of chart you want

5. Click "Generate Chart"

Example Chart Requests:
  • • "Create a bar chart showing sales by month"
  • • "Generate a pie chart of expense categories"
  • • "Make a line chart showing growth trends"
  • • "Create a scatter plot with trend line"

Troubleshooting

Common Issues & Solutions

  • "Loading..." error: Check your API key is correctly entered
  • "Unknown function" error: Ensure the extension is properly installed
  • "API limit exceeded": You've reached your provider's usage limit
  • "Network error": Check your internet connection
  • "Invalid API key": Verify your API key is active and correct

Getting Help

If you need assistance:

Trademark Notice: Google™, Google Sheets™, Google Workspace™, Google APIs™, Google Gemini™, and Google API Services™ are trademarks of Google LLC. SheetPro AI is not affiliated with Google LLC.