Loading...
Loading...
Generate AI-powered text, images, and videos at scale directly in Google Sheets. Use the INSTARANK formula for instant results, or use the sidebar to generate full programmatic SEO datasets with hundreds of pages in one click.
Generate text, stock images, or AI-generated images and videos in any cell — just like a spreadsheet formula:
=INSTARANK("Write a meta description for " & A1)=INSTARANK("Hero photo of a dentist in " & B1, "image")=INSTARANK("Modern clinic in " & B1, "ai-image")Search for "InstaRank" in the Google Workspace Marketplace or install directly from the add-on menu in Google Sheets.
Allow the add-on to access your spreadsheets and connect to external services (AI providers).
Sign in with your InstaRank account. Zero-click Google SSO authenticates you automatically — no extra signup needed.
Tip: Your API keys sync automatically from your InstaRank dashboard, or you can configure them locally in the add-on settings.
Add your API keys for the AI providers you want to use (OpenAI, Claude, Gemini, Groq, DeepSeek, and video providers) in the Settings tab of the sidebar. Bring your own keys — no per-query charges from InstaRank.
=INSTARANK(prompt, type_or_provider, model, projectId)
The second parameter controls what the formula returns. Pass a type keyword for images, or a provider name for text with a specific AI.
| 2nd Parameter | Output | Source |
|---|---|---|
omitted or "text" | AI-generated text | Your default provider |
"image" or "stock-image" | Stock photo URL | Pexels / Pixabay |
"ai-image" or "dalle" | AI-generated image URL | DALL-E 3 ($0.04–$0.08) |
"openai" / "claude" / "gemini" / "groq" / "deepseek" | Text from that provider | Specified AI provider |
Videos are generated automatically by the dataset engine when a column header matches a video pattern (e.g. ai_video, kling_video).
=INSTARANK("Write a meta description for " & A1)Uses your default AI provider. Cell references auto-increment when filled down.
=INSTARANK("Professional dentist in " & B1, "image")Returns a stock photo URL from Pexels or Pixabay. Requires Pexels/Pixabay API key.
=INSTARANK("Modern dental clinic in " & B1, "ai-image")Generates a unique image with DALL-E 3. Standard: $0.04/image, HD: $0.08/image.
=INSTARANK("Write an H1 for " & A1, "openai", "gpt-4o")Target a specific provider and model for quality/cost control.
=INSTARANK("Write a service description for " & A1, "claude", "claude-opus-4-5", "project-id")Injects your InstaRank project's brand context into every generation.
=INSTARANK("Translate to Spanish: " & C2, "openai", "gpt-4o")Translate content into any language in-formula.
=INSTARANK("Summarize in 2 sentences: " & A2, "claude", "claude-opus-4-5")Summarize long content for meta descriptions or snippets.
Select a range of cells containing INSTARANK formulas and use the menu to process them all at once, respecting API rate limits automatically.
Backward compatible with legacy =IR() and =AI() syntax.
Configure an automatic fallback provider. If your primary provider fails or hits rate limits, the add-on seamlessly switches to your backup — no interruption, no lost data.
Free stock photos via Pexels and Pixabay. No image costs required.
"image" or "stock-image" paramContext-aware unique images with DALL-E 3.
"ai-image" or "dalle" paramVideos are generated automatically when a dataset column header matches a video pattern (e.g. ai_video, kling_video, promo_video). Add your API key for any provider in Settings.
Timeout handling: Video generation can take 1–5 minutes per clip. If a job exceeds the 5-minute window, the cell saves a PENDING: sentinel and you can resolve timed-out jobs later using Extensions → InstaRank → Resolve Pending Videos.
Two-phase generation that separates your data structure from your SEO content for cleaner, more scalable datasets.
Generate or import your core dimensions — cities, products, services — that form the structural foundation. Example: service_name + city.
AI generates targeted columns (titles, descriptions, H1s, body content) using the pillar values as context — ensuring every page is unique and relevant.
Generate column headers and AI prompts in a single pass without a separate pillar structure. Simpler to start with but less contextual than the pillar-based approach.
The sidebar's dataset generator automatically creates semantic column structures — no manual setup required.
Tell InstaRank what kind of pages you're building (e.g. "local dentist city pages"). The AI generates semantic column names tailored to that use case — things like page_title, meta_description, h1_heading, service_intro, feature_benefits.
Set exactly how many of each content type you want per page:
The add-on generates sample rows (5–10 rows) for your review before committing. Once approved, =INSTARANK() formulas are inserted into sample rows and filled down to all data rows automatically.
The variable system focuses on page body content only — it automatically excludes headers, footers, navigation, and site-wide elements. Every column maps to something that belongs inside a unique programmatic page.
Start from a pre-built pillar structure. Each template defines the dimension columns (pillar data) that drive your page variations.
For each template, the AI generates a complete set of SEO columns covering every part of the page body. Examples of what gets generated per page type:
Auto-detects language column patterns (Title_EN, Title_ES, Title_FR) and generates content for each language in a single pass. WordPress WPML/Polylang ready.
English, Spanish, French, German, Italian, Portuguese, Dutch, Polish, Swedish, Danish, Norwegian, Finnish, Czech, Romanian, Hungarian, Greek, Japanese, Chinese, Korean, Vietnamese, Thai, Arabic, Hebrew, Indonesian, Malay, Russian, Ukrainian + more.
Schedule content publication over days, weeks, or months to avoid SEO penalties from bulk publishing.
Generate custom images with DALL-E 3 (HD quality, multiple styles) and AI videos from 10 providers — Kling AI, Runway, Google Veo, OpenAI Sora, Pika, Adobe Firefly, Hailuo, Luma, Vidu, and Seedance. Video columns are auto-detected by header name (e.g. ai_video, kling_video). Inline cost estimates shown before generation.
Every generation is saved to the cloud automatically. Full restore lets you rebuild any past dataset in your current sheet with formatting. View headers, prompts, and sample data from any past generation. Never lose work — even if the original sheet is deleted.
Sample 5–10 rows before a full generation run. See actual costs, token usage, and estimated generation time before committing to hundreds of rows. Selection methods: first rows, random sample, or stratified.
Live progress bar updates every 500ms with the current phase and percentage: Generating → Writing Headers → Writing Prompts → Formatting. See which column is being generated and time remaining.
Generate location-based pillar data for 10+ countries including all US states. Location types: cities, towns, villages, suburbs, neighborhoods. Radius options from 10–500 km. AI-enhanced location enrichment included.
Parse and process spintax-formatted content ({option1|option2|option3}). Generate spintax-formatted variations with AI to maximize content uniqueness across large datasets.
Link your sheet to an InstaRank project with a Knowledge Base configured. The AI automatically injects your brand context, tone of voice, and guidelines into every generation — ensuring all content stays aligned with your brand. Works with both formula-based and dataset generation modes. Context is pre-cached for fast formula execution.
| 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. InstaRank does not charge per query.
After generating content with Google Sheets, audit and optimize your pages with InstaRank SEO Platform. 50+ automated checks to maximize rankings.
The second parameter of =INSTARANK() controls the output type. Omit it (or pass "text") for AI-generated text. Pass "image" for a free stock photo URL, "ai-image" for a DALL-E 3 generated image, or a provider name like "openai" / "claude" / "gemini" for text from that specific provider. Videos are generated automatically by the dataset engine based on column header names.
Open the InstaRank sidebar, describe your page type, and set how many text fields, image columns, and video columns you want. The AI generates semantic column headers specific to your use case, shows you a sample preview of 5–10 rows, and once approved, inserts =INSTARANK() formulas that are automatically filled down to all your data rows.
Yes, you bring API keys from the AI providers you want to use (OpenAI, Claude, Gemini, video providers, etc.). This gives you direct control over costs and usage — InstaRank does not charge per query or mark up API calls.
Yes. Configure multiple providers and specify which one to use in each INSTARANK formula, or set up automatic fallback so the add-on switches providers seamlessly if one fails or hits rate limits.
The cell shows an error message. You can retry individual formulas or use batch processing to retry all failed cells at once. For video generation, timed-out jobs store a PENDING: value that can be resolved later via the menu.
Yes. Export to CSV for use with other tools, or sync directly to your WordPress site via the InstaRank platform. All past datasets are saved to the cloud and can be fully restored at any time.
Install the add-on and create your first AI-powered dataset in minutes.