Introduction
Â
SheetAI is a powerful Google Sheets add-on that brings advanced AI capabilities directly into your spreadsheets. It supports multiple AI models, including GPT-4, Claude, Gemini, and X AI, enabling you to automate tasks, generate content, analyze data, and much more – all without leaving Google Sheets.
With SheetAI, you can:
- Generate content, summaries, and ideas
- Classify and tag data
- Extract and fill information
- Create structured tables and visuals
Quick Start
Getting started with SheetAI is as simple as 1-2-3:
- Install SheetAI from the Google Workspace Marketplace ‣
- Create a new Google Sheet and launch SheetAI from the Extensions menu
- Start using SheetAI functions in your spreadsheet
SheetAI Core Functions
- =SHEETAI_MODELS() - Get support model list
- =SHEETAI(prompt, response_token, temperature, model, cache, use_translation, target_language, api_key) – Generate AI responses directly in a cell. where E6 is the cell which contains the license key
- =SHEETAI_BRAIN(prompt, cache) – Store, retrieve, or delete information.
- =SHEETAI_LIST(prompt, response_token, temperature, model, cache, api_key) – Generate multiple AI responses in consecutive cells. where C7 is the cell which contains the license key
- =SHEETAI_CLASSIFY(text, categories, response_token, temperature, model, cache, api_key) – Categorize or classify text/data. where C8 is the cell which contains the license key
- =SHEETAI_EXTRACT(text, to_extract, response_token, temperature, model, cache, api_key) – Extract specific information from text.
- =SHEETAI_FILL(range, inputs, response_token, temperature, model, cache, api_key) – Fill missing data based on patterns/context.
- =SHEETAI_IMAGE(imgdesc, heightWidth, temperature, cache, provider, api_key)– Generate images from prompts.
- =SHEETAI_SUMMARIZE(text, response_token, temperature, model, cache, api_key) – Summarize text into concise, detailed, or bullet-point formats. where C8 is the cell which contains the license key
- =SHEETAI_TABLE(prompt, response_token, temperature, model, cache, api_key) – Generate structured tables with AI. where C8 is the cell which contains the license key
- =SHEETAI_TAG(text, tags, response_token, temperature, model, cache, api_key) – Automatically tag or label content.
- SHEETAI_API(url, method, headersJson, bodyJson, keyPath) - Generate response using your own api key where B16 is the cell which contains the API key
- =SHEETAI_PJSON(B1,"url") - Fetch particular value from Json where B1 is the cell which contains JSON
