What is Power Formulas?
Power Formulas is a Google Sheets add-on that integrates artificial intelligence, APIs, and SQL databases directly into your spreadsheets. Instead of switching between ChatGPT, your database client, and Google Sheets, you can run AI prompts, fetch live API data, and query SQL databases using simple spreadsheet formulas like =AI_TEXT(), =API(), and =SQL(). The tool is designed for marketers, data analysts, ecommerce operators, and business professionals who want to automate data enrichment, bulk content generation, and reporting workflows without writing code.
Key Features
AI-Powered Text Generation (=AI_TEXT / =AI)
The core formula connects your spreadsheet to large language models including GPT-5, GPT-4o, Claude 4, Claude 3.5 Sonnet, Gemini 2.5 Pro, and Cohere Command R+. You can prompt these models directly in a cell to generate product descriptions, classify data, summarize text, translate content, or answer questions at scale across thousands of rows.
AI Image Generation (=AI_IMAGE)
Generate images directly in Google Sheets using OpenAI's DALL-E 3 and DALL-E 2 models. Provide a text prompt in a cell, and the formula returns an image, making it useful for bulk creative asset generation, product visualizations, and marketing content.
API Integration (=API)
Connect any spreadsheet to external APIs and import JSON data directly into cells. This enables real-time data from sources like social media platforms, ecommerce marketplaces, CRM systems, and financial data providers without needing middleware or custom scripts.
Database Queries (=SQL and =SQLTABLE)
Run SQL queries on MySQL, Oracle, and Microsoft SQL Server databases right from Google Sheets. Pull live data into your spreadsheet or push data from sheets back to your database. The =SQLTABLE formula automatically formats query results into a proper table layout.
No-Code Formula Builder
A graphical interface walks you through building formulas step by step. Select the formula type, fill in parameters through form fields, and the builder generates the correct formula syntax ready to paste into your sheet. No memorization of function signatures required.
Scheduled Refreshes
Paid plans support hourly and daily automatic data refreshes. Set up a formula once and let it update on a schedule, keeping reports, dashboards, and data pipelines current without manual intervention.
Pricing
Power Formulas offers four pricing tiers with clear annual billing:
- Starter: Free forever. Includes a 30-day trial of Pro features, then limited to 100 automatic refreshes per month. Basic formula access (API, SQL) and community support.
- Pro: $199 per year. Unlimited formula refreshes, scheduled hourly/daily refreshes, access to all formulas (AI, AI_IMAGE, AI_VISION), formula builder, and live chat plus email support.
- Team (5 users): $499 per year. Everything in Pro plus a license for 5 users in your Google Workspace.
- Enterprise (Unlimited users): $899 per year. Everything in Team with unlimited users across your Google Workspace organization.
Important note: Power Formulas does not include AI API credits. Users must bring their own API keys from OpenAI, Anthropic, Google AI, or Cohere and pay those providers directly for usage. Google Sheets service quota limits also apply.
Who Should Use Power Formulas?
This tool is ideal for professionals who spend significant time in Google Sheets and want to layer AI capabilities on top of existing workflows. Marketers can bulk-generate ad copy, email subject lines, and SEO meta descriptions. Ecommerce operators can enrich product catalogs with AI-generated descriptions and categorization. Data analysts can classify, extract, and summarize unstructured text directly in their analysis spreadsheets. Sales teams can enrich lead lists and generate personalized outreach content at scale.
Affiliate Program
As of mid-2026, Power Formulas does not appear to operate a public affiliate or partner program. The official website has no affiliate signup page, and the Terms of Service mention affiliates only in the context of third-party cookies on the marketing website. The product is distributed through the Google Workspace Marketplace, and a lifetime deal was previously available on GrabLTD (now archived). If you are looking to promote Power Formulas, the primary channel is direct referral to the Google Workspace Marketplace listing or the official website.
AI Models Supported
Power Formulas supports a wide range of AI providers and models, all connected via your own API keys:
- OpenAI: GPT-5, GPT-4, GPT-4o, GPT-3.5-turbo, and all current OpenAI models. Image generation via DALL-E 3 and DALL-E 2.
- Anthropic: Claude 4, Claude 3.7, Claude 3.5 Sonnet, Claude 3 Opus, Claude 3 Sonnet, Claude 3 Haiku.
- Google AI: Gemini 2.5 Pro, Gemini 2.5 Flash, Gemini 2.0 Pro.
- Cohere: Command R+, Command R, Command, Command Nightly, Command Light, Command Light Nightly.
Integration and Setup
Installation is straightforward through the Google Workspace Marketplace. After installing the add-on, you configure your API keys once in the add-on settings panel. The Formula Builder helps construct your first formulas, and documentation is available on the Power Formulas website covering each formula type with examples. The free Starter plan lets you test core functionality before committing to a paid subscription.
