Track competitor pricing in Airtable
Checking competitors' pricing pages by hand is tedious and always out of date.
3 stepsModerate
Claude DesktopClaude CodeFirecrawlAirtable
How it connects
Your AI reaches your apps through small connectors called MCP servers.
Your AI
Claude DesktopClaude Code
Connectors
FirecrawlAirtable
Your apps
FirecrawlAirtable
This setup is for product marketers, founders and sales teams who track competitor pricing. Claude uses Firecrawl to read each competitor's pricing page and writes plan names, prices and notable limits into an Airtable base. You end up with one table you can refresh whenever you want, with the source URL and check date on every row.
Set it up
3 steps. Open one for the details.
1Connect Firecrawl
Create a Firecrawl account, copy your API key and add the Firecrawl MCP server to Claude Desktop or Claude Code with the key in its environment settings. Ask Claude to scrape one pricing page and show the result as markdown to confirm it works. Firecrawl bills by usage credits, so check your plan before scraping many pages.
Tip: Pages that load prices with JavaScript usually still work, since Firecrawl renders the page before returning content.
2Connect Airtable
Create an Airtable base with a Competitors table (name, pricing URL) and a Plans table (competitor, plan, price, billing period, key limits, source URL, checked on). Generate a personal access token with read and write access to records and schema, scoped to that one base, and add the Airtable MCP server with it. Ask Claude to describe the base schema to confirm it can see the right tables.
Tip: Use single-select fields for billing period so the data stays consistent between runs.
3Refresh on demand
Ask Claude to scrape each URL in the Competitors table, extract the plans and update the Plans table, flagging rows where the price changed. Review the proposed changes before approving the writes. Run it again whenever you need fresh numbers, for example before a pricing review.
Tip: Ask Claude to put the old price in a comment or notes field when it updates a row, so you keep the history.
Then just ask
Things to say once it's connected. Click one to copy it.
Ask Claude Desktop…Claude Desktop
Good to know
What you need, what it won't do, and how to keep it safe.
What you need
- Firecrawl account and API key
- Airtable base and a personal access token scoped to it
- Claude Desktop or Claude Code
- List of competitor pricing URLs
Limits
- Prices behind logins, calculators or "contact sales" forms will not be captured.
- Page redesigns can change what Claude extracts, so spot-check after big changes.
- Refreshes happen only when you ask; there is no built-in schedule.
Keep it safe
- Respect each site's terms and robots rules.
- Scope the Airtable token to one base.
Questions
Straight answers before you start
Is scraping pricing pages allowed?
Public pricing pages are usually fine to read, but each site has its own terms and robots rules. Check them, keep the request volume low, and do not scrape pages behind a login.
What does it cost?
Firecrawl charges credits per page scraped, and Airtable's plan limits how many records a base can hold. A handful of competitors refreshed now and then stays small, but check both pricing pages for current numbers.
What if a price is shown only after picking a region or seat count?
Claude sees the default version of the page Firecrawl returns. Prices behind toggles, calculators or sales contact forms may be missing or show only one option, so mark those rows for manual checking.
Can this run on a schedule?
Not by itself. Claude runs the refresh when you ask in Claude Desktop or Claude Code; for a schedule you would need a separate automation that calls Claude or Firecrawl.
Tools in this setup
The products involved
