Back to Templates

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

Created by

Created by: Meak || meak

Meak

Last update

Last update 3 days ago

Share


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

  1. Webhook receives a natural-language search request
  2. OpenRouter-powered Agent converts it to a Firecrawl query (+ limit)
  3. Firecrawl Search runs with scrapeOptions (markdown, screenshot)
  4. Parallel queries: site:, inurl:, negative filters, YouTube intitle:automation
  5. Collect results (title, url, data fields) from each call
  6. Append rows to Google Sheets (one per result)
  7. Respond to the webhook with the aggregated payload
  8. 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.