{"product_id":"n8n-workflow-monitor-competitors-with-firecrawl-openai","title":"n8n Workflow: Monitor Competitors with Firecrawl \u0026 OpenAI","description":"\u003ch3\u003eKeep an eye on competitors automatically—Google Sheets in, Firecrawl + OpenAI insights out, and a PDF report emailed on schedule\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow monitors competitor websites end-to-end: it pulls competitor URLs from Google Sheets, scrapes each site using the Firecrawl API, analyzes the content with OpenAI, logs results back to Google Sheets, generates an HTML report, converts it to a PDF via \u003cstrong\u003ehtml2pdf.app\u003c\/strong\u003e, and sends the report through \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduled monitoring:\u003c\/strong\u003e Runs on a schedule to keep competitive intelligence up to date.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads competitor URLs from Google Sheets:\u003c\/strong\u003e Loads URLs from a specified column (e.g., a column named “Url”).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScrapes each competitor with Firecrawl:\u003c\/strong\u003e Iterates through competitors and retrieves site content using the Firecrawl API.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAnalyzes content with OpenAI:\u003c\/strong\u003e Sends scraped text to OpenAI to generate a structured competitive intelligence report using a defined schema.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates Google Sheets + creates a report:\u003c\/strong\u003e Appends a summary row to Google Sheets and renders a styled HTML report.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eConverts HTML to PDF:\u003c\/strong\u003e Uses \u003cstrong\u003ehtml2pdf.app\u003c\/strong\u003e to generate a PDF from the HTML output.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmails the PDF via Gmail:\u003c\/strong\u003e Attaches the PDF when available and continues to the next competitor.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators tracking competitor messaging, positioning, and site changes over time.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building scheduled competitive intelligence workflows with n8n.\u003c\/li\u003e\n  \u003cli\u003eTeams who want a repeatable “scrape → analyze → report” pipeline without manual reporting.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes \/ tools:\u003c\/strong\u003e set, html, gmail, sticky note, http request, google sheets\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Sheets (OAuth), Firecrawl API (HTTP Bearer Auth), OpenAI (API credentials), html2pdf.app (HTTP header auth), Gmail (OAuth)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFlow behavior:\u003c\/strong\u003e loops through competitors, scrapes with Firecrawl, analyzes with OpenAI, logs results to Google Sheets, generates HTML + PDF, and emails via Gmail.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46153935519923,"sku":"N8N-20325","price":68.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/pHTpa4Tw72Jhn44iQ3oeD_Zrh5hpiu.png?v=1790931751","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-monitor-competitors-with-firecrawl-openai","provider":"N8N Commerce","version":"1.0","type":"link"}