Power Formulas is a Google Sheets™ add-on that provides custom formulas to integrate AI, API, and SQL capabilities directly into spreadsheets. The =AI_TEXT() formula connects sheets to large language models from providers such as OpenAI (ChatGPT, GPT-5), Gemini, and Claude, enabling advanced analysis, predictions, and automation. The =API() formula allows users to connect to any external API and import JSON data for real-time updates. The =SQL() and =SQLTABLE() formulas enable connections to various databases to execute queries and synchronize data. A no-code formula builder lets users create custom formulas through a point-and-click interface without writing code.
Key Benefits
- Connects Google Sheets to major AI models like GPT-5, Gemini, and Claude
- Enables API and SQL integration directly in spreadsheets
- Includes a no-code formula builder for non-technical users