GPT for Sheets
Bring ChatGPT and other AIs directly into Google Sheets to automate bulk text processing and assist you with formulas
Generate or rewrite content at scale (listings, ads, social posts)
Translate in multiple languages in bulk
Analyze free-form feedback (reviews, surveys)
Bulk review (quality check, score, revise)
Prepare, enrich, and segment unstructured data in a few clicks
Get help on spreadsheet formulas
GPT functions: Prompt directly
from cells
- Reference cells and ranges in your prompts.
- Run a prompt in bulk by simply dragging a formula over rows or columns.
- Ideal for custom tasks where detailed control is more important than processing large volumes at once.
Use dynamic cell and range references in your prompts
Reference cells and ranges in your prompts to dynamically pull data from specific cells or ranges in your spreadsheet. This means your prompt can automatically adapt based on the content of those cells, allowing you to work with changing or live data without manually inputting values each time.
Drag to apply in bulk
Apply the same prompt across many rows or columns at once, simplifying repetitive tasks without needing to input them manually one by one.
Select your favorite model
Choose from a broad range of models from OpenAI, Anthropic, Perplexity or Ollama. You can even connect to an OpenAI assistant to bring your own knowledge.
Cache
When enabled, results are stored encrypted, avoiding extra costs and loss of results due to auto-refreshes. Safe mode caches results in cells or automatically replaces formulas with their results. Avoids timeout for slower models.
Use in formulas or even Apps Script
GPT for Sheets allows you to combine GPT functions with regular spreadsheet functions such as IF or CONCATENATE, or custom scripts for more complex and tailored solutions.
Set custom instructions
Give precise spreadsheet-level instructions to guide the model on style, tone, format and other important details of the output you want.
Bulk tools: High-volume prompting from the sidebar
- Fast bulk-prompting of up to 360 requests per minute.
- Reliable processing over hundreds of thousands of rows.
- Easy-to-use interface, no need to write formulas.
7 available tools
Custom prompt, Translate, Classify/Categorize, Extract, Reformat, Search the web, Prompt images (Vision).
Easy UI
Bulk tools are accessible from the sidebar, with a clean, straightforward, and easy-to-navigate interface which allows you to run prompts with just a few clicks.
Results directly in cells
The results of your prompts are written directly in cells, meaning no auto-reload issues, no need for caching, easier further edits and painless moving data around.
Track your progress and stop any time
Once you’ve launched a run, track its progress from the sidebar. Stop your run immediately in one click if you need.
Prompt History
Quickly access a list of your recent prompts from the History page, so you can quickly reapply them without needing to start from scratch.
Reliable at very high volume
Bulk tools can quickly handle hundreds of thousands of rows, ensuring the process remains stable and accurate at scale.
Per-run custom instructions
You can set custom instructions to define specific guidelines or constraints for your run, ensuring that the results match your expectations.
Google Sheets formula assistant
Easily generate new formulas or explain existing formulas, directly in Google Sheets.Describe what you want to do in natural language to generate a formula
Simply tell the formula assistant what you want to do, like summing certain cells or applying conditions, and it will automatically generate the right formula for you that you can directly use in your sheet. No need to know the exact functions - just describe your goal.
Explain existing formulas
If you’re not sure what a formula does, paste it in, and the assistant will explain its components and function in plain terms.
Reliable at high speed
| Requests per minute | Requests per hour | Requests per day | |
|---|---|---|---|
| GPT Functions | 120 | 7200 | 172,800 |
| Bulk tools | 360 | 21600 | 518,400 |
- Up to 120 requests per minute with GPT functions
- Up to 360 requests per minute with bulk tools
- Up to 200k rows with bulk tools
Privacy and security
- Talarian is ISO 27001 certified
- GDPR compliant
- Bring your own API keyBy using your own API key, your usage is bound by the terms you negotiated with your AI provider. We don’t store any of your inputs and outputs.
Supported Models in GPT for Sheets
OpenAI
- gpt-4o
- gpt-4o-mini
- gpt-3.5-turbo-instruct
- gpt-4-turbo
- gpt-4
- Fine-tuned models
- Assistants
Gemini
- gemini-1.5-flash
- gemini-1.5-pro
Perplexity
- llama-3.1-sonar-small-128k-online
Anthropic
- claude-3-haiku
- claude-3.5-sonnet
- claude-3-opus
Mistral
- mistral-large
How is it different from ChatGPT.com or Gemini?
- GPT for Sheets lets you use AI directly in Google Sheets
- The GPT for Sheets UI is made for bulk processing tabular data
- GPT for Sheets offers AI from many providers
- GPT for Sheets is fast and reliable for hundreds of thousands of prompts
