Power Formulas provides a series of advanced Google Sheets™ formulas that boost your spreadsheet productivity.

Power Formulas is designed to help you work smarter, not harder. With =API(), =SQL(), =AI_TEXT(), =AI_IMAGE(), you’ll be able to perform complex tasks in seconds. From automating data collection to creating powerful reports, our formulas will transform the way you work with Google Sheets™.

=AI_TEXT()

The =AI_TEXT() formula allows you to send a request to OpenAI's GPT-4 text generation API and return the result right in your spreadsheet. You can use the formula to do basically everything you can do with chatGPT, like asking questions, solving problems, and so on. 

Support the following models:
- GPT 4
- GPT 4 Turbo
- GPT 4o
- GPT-4o
- GPT-3.5-turbo
And all OpenAI models

Other AI models supported by Power Formulas
Anthropic:
    - Claude 3.5 Sonnet
    - Claude 3 Opus
    - Claude 3 Sonnet
    - Claude 3 Haiku
    - Claude 3.5 Sonnet
Cohere:
    - Command R+
    - Command R
    - Command
    - Command Nightly
    - Command Light
    - Command Light Nightly
       
Google AI:
    - Gemini 1.5 Pro
    - Gemini 1.5 Flash
    - Gemini 1.0 Pro
      
=AI_IMAGE()

Generate images in Google Sheets using OpenAI's DALL·E, a AI system that can create realistic images and art from a description in natural language. Currently support the DALL·E 3 and DALL·E 2 models.

=API()

The =API() formula allows you to connect your spreadsheet to any API endpoint. This means you can easily integrate data from a wide range of sources, including social media, eCommerce platforms, and more. You can also use it to directly import JSON data, making it simple to work with data in its raw format.

=SQL()

With the =SQL() formula, you can retrieve data from a variety of databases, including MySQL, Oracle, and Microsoft SQL Server, to Google Sheets™. The formula allows you to specify the database you want to connect to and the query you want to run. You can either pull data from a database or send Google Sheets™ data to a database using SQL queries.


Formula Builder

Power Formulas comes with a user-friendly Formula Builder that helps you build your formulas in a graphic user interface.

With the Formula Builder, you can select the formula you want to use from a list of categories, and type in the arguments in a form. The input fields are organized in a logical order, making it easy to understand what each parameter represents. The app will then generate the formulas so that you can copy and paste them into Google Sheets™.

Google Sheets™ is a trademark of Google LLC