Power Formulas is a Google Workspace add-on designed for Google Sheetsβ’ that encapsulates AI, API, and SQL capabilities into spreadsheet formulas. Users can invoke mainstream large language models like OpenAI ChatGPT, GPT-5, Gemini, and Claude via AI-related formulas within Sheets. They can also use =API() to fetch JSON data, =SQL() to connect to databases and execute queries, and leverage the formula builder to lower the barrier to writing complex formulas.
Its core value lies in integrating external intelligence and real-time data into spreadsheet workflows. For AI, the website mentions support for formulas like AI_TEXT, AI, AI_IMAGE, and AI_VISION, which can be used for text analysis, predictions, automated tasks, and image/vision processing. For APIs, it supports connecting to any API and importing JSON. For SQL, it supports connecting to databases, executing SQL queries, and syncing data. Paid plans also offer hourly/daily scheduled refreshes, making it suitable for automated operational reports, data monitoring, batch text processing, and lightweight data analysis.
Pricing is straightforward: Starter is free forever, includes a 30-day trial, and after the trial offers 100 auto-refreshes per month, supporting basic formulas and the formula builder. Pro is $199/year, unlocking all formulas, unlimited refreshes, and scheduled refreshes. Team is $499/year, including 5 Workspace users. Enterprise is $899/year, supporting unlimited users. It's important to note that third-party service costs are not included in the subscription; when using AI formulas, you need to provide API keys from providers like OpenAI and bear the API call costs yourself.
Pros include deep integration with Google Sheets, allowing users to complete AI generation, external API connections, and database queries without leaving the spreadsheet; the formula builder is friendly to non-technical users; and the licensing model for Team and Enterprise editions is clear. Limitations are also apparent: it is essentially an integration layer, so AI output quality depends on third-party models, prompts, and data quality; it is also subject to Google Sheets service quotas. The website does not disclose details such as a Chinese interface, specific database types supported, or payment methods.
The terms state that the add-on logs usage analytics but does not collect personal identification information; although it may request full spreadsheet access, it declares that it will not send spreadsheet text to third parties without the user's knowledge or direct control, nor does it claim intellectual property rights over user content. The free version relies on community support, while paid versions offer live chat and email support. It is suitable for data analysts, operations, growth, finance professionals, and teams reliant on Google Workspace.
The website provides no information regarding access, payments, or local compliance in mainland China. Actual availability depends on the accessibility of Google Sheets, OpenAI/Gemini/Claude APIs, and the network environment, making overall feasibility unknown. If access to Google or overseas model services is restricted, consider local alternatives such as Feishu Bitable AI, DingTalk Yida, or WPS AI Spreadsheets.
β This review is compiled from public sources and does not constitute a purchase recommendation. Verify all facts on the vendor's official site. Verify on powerformulas.co official site.
powerformulas.co is an Unknown AI Apps provider. TG4G tracks its product information, an overall rating of 8.0/10, and a China-accessibility score of Workable. Click "Visit Official Site" to reach powerformulas.co directly.