Generate weekly AI equity research reports with Google Sheets, FMP, NewsAPI, OpenAI, and Gmail
Description This workflow automatically generates professional equity research reports for selected companies using financial data, market news, and AI analysis. It is designed for analysts, founders, and finance teams who want consistent, data-backed equity insights without manual research. On a weekly schedule, the workflow reads a list of companies from Google Sheets and processes only those marked as enabled. For each company, it collects five years of financial statements and recent market
At a glance
Generate weekly AI equity research reports with Google Sheets, FMP, NewsAPI, OpenAI, and Gmail is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Gmail, Google Sheets, OpenAI, Outlook. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- Gmail, Google Sheets, OpenAI, Outlook
- Modules
- 26
- Price
- Free
- Version
- v1.0

About this workflow
Description This workflow automatically generates professional equity research reports for selected companies using financial data, market news, and AI analysis. It is designed for analysts, founders, and finance teams who want consistent, data-backed equity insights without manual research. On a weekly schedule, the workflow reads a list of companies from Google Sheets and processes only those marked as enabled. For each company, it collects five years of financial statements and recent market news, calculates key financial signals, and uses AI to generate a structured SWOT analysis, risk assessment, and growth outlook. The final report is converted into a PDF, logged for tracking, and emailed automatically. ⚙️ What This Workflow Does (Step-by-Step) ⏰ Weekly Scheduler Runs the workflow automatically at a fixed weekly time. 📄 Load Company List from Google Sheets Uses Google Sheets as the control panel to decide which companies are analyzed. 🔁 Iterate Enabled Companies Processes each enabled company one at a time for stable execution. 📊 Fetch Financial Statements (FMP) Pulls income statement, balance sheet, and cash flow data for the last five years. 📰 Fetch Recent Market News Retrieves the latest company-related news headlines. 🧹 Normalize Financials & News Cleans and structures all data into a consistent format. 📐 Compute Financial & Market Signals Calculates revenue growth, margins, leverage, cash flow strength, and buyback signals. 🤖 AI SWOT Analysis Generates strengths, weaknesses, opportunities, and threats using only derived signals and news. 📈 AI Risk & Growth Outlook Identifies key risks and provides a 12–24 month growth outlook. 📝 Build Equity Research Report (HTML) Combines all insights into a clean, readable report layout. 📄 Convert Report to PDF Automatically renders the HTML report into a downloadable PDF. 📊 Log Report Metadata to Google Sheets Stores PDF URL, size, timestamp, and expiry for tracking. 📧 Email Research Report Sends the PDF download link to stakeholders. 🧩 Prerequisites • Google Sheets API access • Financial Modeling Prep (FMP) API key • NewsAPI key • OpenAI API access • Gmail OAuth2 credentials • HTML-to-PDF service credentials 💡 Key Benefits ✔ Fully automated equity research reporting ✔ Consistent, repeatable analysis every week ✔ Data-backed AI insights with no assumptions ✔ No manual data collection or formatting ✔ Clean PDF reports ready for sharing ✔ Centralized tracking in Google Sheets ✔ Scales easily to multiple companies 👥 Perfect For - Equity analysts - Investment research teams - Startup founders - Finance and strategy teams - Advisory and consulting firms - Anyone producing regular equity research reports
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related N8n workflows
Form to meeting: Google Calendar, Zoom, Gmail & Slack booking automation
Search LinkedIn companies, score with AI and add them to Google Sheet CRM
Filter rows in Google Sheets and send a Telegram message with the results
Multi-agent AI content creator for SEO blogs & newsletters with OpenRouter, DALL-E, Gemini
Watch Google Forms responses and add new entries to Google Sheets
Update Google Sheets cells with data from a custom webhook
Discord setup guidelines 📜 - get all channels & categories of a Discord server
Automatically sync Beex leads to HubSpot (Create & Update)
Reviews
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
- JSON blueprint — instant download
- Setup guide PDF included
- 5 downloads · valid 30 days
- Works with n8n
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you