kitio.aiGoodlookup vs Power Formulas
A side-by-side look at pricing plans, free tiers, features, pros and cons, updated for 2026. Goodlookup has the lower starting price: about $1 a month, against $17 for Power Formulas.
At a glance
Best for
Category
Pricing model
Starting price
Free plan
Made by
Based in
Rating
Key features
- Semantic text matching
- VLOOKUP-style function
- Match confidence scores
- Topic clustering
- Google Workspace add-on
- =AI() formula for LLMs
- =API() JSON import
- =SQL() database queries
- No-code formula builder
- Scheduled refreshes
| Feature | Goodlookup | Power Formulas |
|---|---|---|
| Best for | Semantic lookup function for matching text in Google Sheets | AI, API and SQL formulas inside Google Sheets |
| Category | Data & analytics | Data & analytics |
| Pricing model | Paid | Freemium |
| Starting price | $15/yr | $199/yr |
| Free plan | No | Yes |
| Made by | Goodlookup | Power Formulas |
| Based in | – | – |
| Rating | No ratings yet | No ratings yet |
| Key features |
|
|
Pricing compared
Goodlookup has the lower starting price: about $1 a month, against $17 for Power Formulas.
Free plan
Cheapest paid plan
Top plan
Free trial
4 plans
Starter
Free
- 30-day free trial
- 100 automatic refreshes per month after
- Basic API and SQL formulas
- Formula builder
Pro
$199/yr
- Unlimited formula refreshes
- Hourly or daily refresh schedules
- AI, AI_IMAGE and AI_VISION formulas
Team
$499/yr
- License for 5 users
- Google Workspace license
Enterprise
$899/yr
- Unlimited users
- Google Workspace license
Prices in USD, checked Oct 29, 2026 or later. Plans change often, so confirm on each tool's site before you buy.
Pros and cons
Goodlookup
- Low yearly price
- Familiar lookup-style syntax
- Matches synonyms and related terms
- Works only in Google Sheets
- No free tier
- Sparse documentation on the site
Power Formulas
- Works inside Google Sheets
- AI, API and SQL in one add-on
- Supports several model providers
- AI formulas need the paid Pro plan
- Paid plans are billed yearly
- Google Sheets only
Which one should you choose?
Choose Goodlookup if you want:
- Low yearly price
- Familiar lookup-style syntax
- Matches synonyms and related terms
Watch out: works only in google sheets.
Choose Power Formulas if you want:
- Works inside Google Sheets
- AI, API and SQL in one add-on
- Supports several model providers
Watch out: ai formulas need the paid pro plan.
Goodlookup vs Power Formulas FAQ
What is the difference between Goodlookup and Power Formulas?
Goodlookup: Semantic lookup function for matching text in Google Sheets. Power Formulas: AI, API and SQL formulas inside Google Sheets. Both are data & analytics tools.
Is Goodlookup or Power Formulas cheaper?
Goodlookup has the lower starting price: about $1 a month, against $17 for Power Formulas.
Do Goodlookup and Power Formulas have free plans?
Goodlookup: No. Power Formulas: Yes.
Who makes Goodlookup?
Goodlookup is made by Goodlookup.
Who makes Power Formulas?
Power Formulas is made by Power Formulas.
Which should I choose, Goodlookup or Power Formulas?
Choose Goodlookup if you value low yearly price and familiar lookup-style syntax. Choose Power Formulas if you value works inside google sheets and ai, api and sql in one add-on.