Generate a daily competitor intelligence briefing with OpenAI and Gmail

by Akshay Chug ✓ · 69 views · created 2026-04-07 · Market Research, AI Summarization

What this workflow does

This workflow has 11 nodes and runs on a schedule (every 24 hours). Along the way it connects Gmail and Google Sheets. It also calls api.openai.com over HTTP.

How it runs

Trigger: On a schedule (every 24 hours).

1. Configure Competitors and Settings (Code): runs custom JavaScript code
2. Fetch Competitor Page (HTTP Request): calls an HTTP API
3. Extract Text and Build AI Prompt (Code): runs custom JavaScript code
4. AI Analyze Competitor (HTTP Request): calls api.openai.com (POST)
5. Parse AI Response (Code): runs custom JavaScript code
6. Aggregate and Build Briefing Prompt (Code): runs custom JavaScript code
7. AI Generate Final Briefing (HTTP Request): calls api.openai.com (POST)
8. Format HTML Email (Code): runs custom JavaScript code
9. Send Email Briefing (Gmail): uses Gmail
10. Log to Google Sheets (Google Sheets): append

Services it uses

GmailGoogle Sheets

HTTP calls to: api.openai.com

Before you upgrade to n8n 3.0

Nodes used (5)

• Schedule Triggern8n-nodes-base.scheduleTrigger
• Coden8n-nodes-base.code
• HTTP Requestn8n-nodes-base.httpRequest
• Gmailn8n-nodes-base.gmail
• Google Sheetsn8n-nodes-base.googleSheets

From the author

Overview Know what your competitors are doing every morning before your first meeting. This workflow visits each competitor website daily, uses OpenAI to analyse it for strategic signals, and emails your team a consolidated executive briefing automatically.…

View the original on n8n.io → Check your own copy