Firecrawl Web Search Agent → Google Sheets Logger with OpenRouter + n8n
Most teams craft search operators by hand and copy results into spreadsheets.
This workflow automates query generation, multi-operator searches, scraping, and logging — from a single webhook call.
Benefits
- Auto-generate Firecrawl queries from natural language (OpenRouter Agent)
- Use pro operators: site:, inurl:, intitle:, exclusions, related
- Run parallel searches (site match, in-URL, exclusions, YouTube/intitle)
- Append titles/URLs/results to Google Sheets automatically
- Return results to the caller via webhook response
- Optional scraping of markdown + full-page screenshots
How It Works
- Webhook receives a natural-language search request
- OpenRouter-powered Agent converts it to a Firecrawl query (+ limit)
- Firecrawl Search runs with scrapeOptions (markdown, screenshot)
- Parallel queries:
site:
, inurl:
, negative filters, YouTube intitle:automation
- Collect results (title, url, data fields) from each call
- Append rows to Google Sheets (one per result)
- Respond to the webhook with the aggregated payload
- Ready to chain into alerts, enrichment, or CRM sync
Who Is This For
- Researchers and content teams building source lists
- Growth/SEO teams needing precise operator queries
- Agencies automating discovery, monitoring, and logging
Setup
- Connect OpenRouter (select your LLM; e.g., GPT-4.1-mini)
- Add Firecrawl API key and endpoint (
/v1/search
)
- Connect Google Sheets (Document ID + Sheet/Tab)
- Set webhook path and allow POST from your app
- Define default
limit
(fallback = 5) and scrapeOptions
ROI & Monetization
- Save 3–6 hours/week on manual searching & copy/paste
- Offer as a $500–$2k/month research automation for clients
- Upsell alerts (cron/webhook) and data enrichment for premium retainers
Strategy Insights
In the full walkthrough, I show how to:
- Prompt the Agent to produce flawless
site:/inurl/intitle/-exclusions
- Map Firecrawl
data
fields cleanly into Sheets
- Handle rate limits, empty results, and retries
- Extend with dedupe, domain filtering, and Slack/Telegram alerts
Check Out My Channel
For more advanced AI automation systems that generate real business results, check out my YouTube channel where I share the exact strategies I use to build automation agencies, sell high-value services, and scale to $20k+ monthly revenue.