Google Sheets Add-on
Generate AI-powered SEO datasets directly in Google Sheets. Use the INSTARANK formula to create thousands of pages with content from multiple AI providers.
The INSTARANK Formula
Generate AI content directly in any cell with a simple formula:
=INSTARANK("Write a meta description for " & A1)Installation
Install from Google Workspace Marketplace
Search for "InstaRank" in the Google Workspace Marketplace or install directly from the add-on menu in Google Sheets.
Grant Permissions
Allow the add-on to access your spreadsheets and connect to external services (AI providers).
Connect Your InstaRank Account
Sign in with your InstaRank account. If you're already logged in, Zero-click SSO will authenticate automatically.
Tip: Your API keys can be synced from your InstaRank dashboard or configured locally in the add-on settings.
Configure AI Provider API Keys
Add your API keys for the AI providers you want to use (OpenAI, Claude, Gemini, etc.) in the add-on settings.
INSTARANK Formula
The INSTARANK formula is the core feature of the add-on. It allows you to generate AI content directly in cells with various options.
=INSTARANK("Your prompt here")Uses your default AI provider
=INSTARANK("Write a title for " & A1)References auto-increment when filling down or right
=INSTARANK("Your prompt", "openai")Options: openai, claude, gemini, groq, deepseek
=INSTARANK("Your prompt", "openai", "gpt-4o")Use a specific model from the provider
=INSTARANK("Your prompt", "openai", "gpt-4o", "project-id")Include business context from your InstaRank Knowledge Base
Batch Processing
Select a range of cells with INSTARANK formulas and use the menu to process them all at once, respecting API rate limits.
Supported AI Providers
OpenAI
- • GPT-4o (recommended)
- • GPT-4
- • GPT-3.5-turbo
Anthropic Claude
- • Claude 3.5 Sonnet
- • Claude 3 Haiku
Google Gemini
- • Gemini 1.5 Pro
- • Gemini 1.5 Flash
Groq & DeepSeek
- • Llama 70B / 8B (Groq)
- • Mixtral (Groq)
- • DeepSeek Chat / Coder
Provider Fallback
Configure automatic fallback to a secondary provider if your primary provider fails or hits rate limits.
Dataset Generation Approaches
Pillar-Based Approach
Generate foundational data first, then create SEO content based on that context.
Phase 1: Pillar Data
Generate or import your main dimensions (cities, products, services) that form the foundation of your pages.
Phase 2: SEO Content
AI generates targeted content (titles, descriptions, headers) using pillar data as context for consistency.
Classic Approach
Generate headers and prompts directly without foundational pillars. Simpler but less contextual than the pillar-based approach.
Built-in Templates
Local Business
- Local Services (City Pages)
- City + Service Specialty
- Real Estate Listings
E-commerce
- Product Pages (Basic)
- Product Variations
Content
- Article Listings
- Location-Based Articles
B2B / SaaS
- SaaS Comparison Pages
- Integration Pages
Advanced Features
Multi-Language
Generate content in 50+ languages. Auto-detect language columns (Title_EN, Title_ES) for WPML/Polylang integration.
Drip Publishing
Schedule batch publishing over time periods. Configure daily, weekly, or monthly intervals.
Stock Images
Search and insert images from Pexels and Pixabay directly into your datasets.
AI Image Generation
Generate custom images with DALL-E 3. Build prompts from pillar data with quality/style options.
Generation History
Track all generated datasets with restore capability. Never lose your work.
Location Generator
Generate location-based data including US states, international countries, and AI-enhanced locations.
Spintax Engine
Parse and process spintax variations. Generate spintax-formatted content with AI enhancement.
Knowledge Base
Link sheets to InstaRank projects. Inject business context into all AI generations automatically.
Plan Limits
| Plan | Max Pages | Max Columns | Price |
|---|---|---|---|
| Free | 10 | 20 | $0 |
| Pro | 1,000 | 60 | $19.99/mo |
| Agency | 10,000 | 150 | $59.99/mo |
Note: API costs for AI providers (OpenAI, Claude, etc.) are billed separately by each provider based on your usage.
Optimize Your Generated Pages
ProAfter generating content with Google Sheets, audit and optimize your pages with InstaRank SEO Platform. 50+ automated checks to maximize rankings.
- 50+ SEO checks
- AI-powered fixes
- Site-wide crawling
FAQ
Do I need my own API keys?
Yes, you'll need API keys from the AI providers you want to use (OpenAI, Claude, etc.). This gives you control over costs and usage.
Can I use multiple AI providers?
Absolutely! Configure multiple providers and specify which one to use in each INSTARANK formula, or set up automatic fallback.
What happens if a formula fails?
The cell will show an error message. You can retry individual formulas or use batch processing to retry all failed cells at once.
Can I export my datasets?
Yes! Export to CSV for use with other tools, or sync directly to your WordPress site via the InstaRank platform.
Start Generating Datasets
Install the add-on and create your first AI-powered dataset in minutes.