{"product_id":"n8n-workflow-live-web-research-reports-with-openai-gmail","title":"n8n Workflow: Live Web Research Reports with OpenAI \u0026 Gmail","description":"\u003ch3\u003eGet live web research delivered to email—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow turns a form-submitted research request into a fully structured report: it performs two live Google searches via the \u003cstrong\u003eSerper API\u003c\/strong\u003e, analyzes sources with \u003cstrong\u003eOpenAI\u003c\/strong\u003e, then emails the finished research and logs it to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCollects your research request\u003c\/strong\u003e via an n8n form (topic, target audience, report goal, and optional focus).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns two live Google searches\u003c\/strong\u003e using the \u003cstrong\u003eSerper API\u003c\/strong\u003e: one broad topic search and one targeted “expert insights\/data” search to gather recent sources.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMerges, deduplicates, and formats results\u003c\/strong\u003e into a numbered source list for downstream analysis and citation.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses OpenAI\u003c\/strong\u003e to extract structured research intelligence, including key findings, data points, expert positions, credibility notes, gaps, contradictions, and a confidence score.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses OpenAI again\u003c\/strong\u003e to write a multi-section, professional research report tailored to the requested audience and goal.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends the report by email\u003c\/strong\u003e through \u003cstrong\u003eGmail\u003c\/strong\u003e to your configured recipient.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends a new row\u003c\/strong\u003e to a Google Sheets “\u003cstrong\u003eResearch Log\u003c\/strong\u003e” tab for tracking.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eRapid market research briefs for SaaS operators (features, competitors, pricing\/positioning signals).\u003c\/li\u003e\n  \u003cli\u003eCustomer-facing content support: generate research-backed articles tailored to a specific audience.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers or analysts using n8n to standardize how research requests are executed and documented.\u003c\/li\u003e\n  \u003cli\u003eInternal decision support—collect sources, surface contradictions\/gaps, and email a consistent summary.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eForm Trigger\u003c\/strong\u003e to receive the research request.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHTTP Request\u003c\/strong\u003e to query the \u003cstrong\u003eSerper API\u003c\/strong\u003e (two search passes).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCode\u003c\/strong\u003e and \u003cstrong\u003eset\u003c\/strong\u003e nodes to merge, deduplicate, and format sources.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI\u003c\/strong\u003e steps to extract structured intelligence and generate the final report.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e to email the report.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e OAuth2 to append results to the “Research Log” tab.\u003c\/li\u003e\n  \u003cli\u003eIncludes a \u003cstrong\u003eSticky Note\u003c\/strong\u003e for workflow clarity.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eSetup:\u003c\/strong\u003e Add Serper API key, OpenAI credentials, Gmail sender\/recipient details, and Google Sheets OAuth2 with a tab named “Research Log” matching the expected header.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46072075747507,"sku":"N8N-19808","price":67.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/18R-Phs9o3X7PtsFXxW_f_gXVZdde3.png?v=1790067805","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-live-web-research-reports-with-openai-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}