Convert Natural Language to Web Searches with GPT-4.1 mini and Log in Google Sheets

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.