AutomationMart
Home/Browse/Generate weekly AI equity research reports with Google Sheets, FMP, NewsAPI, OpenAI, and Gmail
n8n

Generate weekly AI equity research reports with Google Sheets, FMP, NewsAPI, OpenAI, and Gmail

n8nn8n26 modulesv1.0
GmailGoogle SheetsOpenAIOutlook

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
Generate weekly AI equity research reports with Google Sheets, FMP, NewsAPI, OpenAI, and Gmail workflow diagram

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

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 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

Who’s it for Teams that collect meeting requests via a form and want instant, error-free scheduling: customer success, sales, education, agencies, and community managers. How it works / What it does This workflow ingests a form submission (name, email, preferred date/time), checks Google Calendar for conflicts, and branches automatically. If the slot is free, it creates a calendar event, spins up a Zoom meeting, emails the guest a confirmation, and posts a Slack summary to your team.

Free

Search LinkedIn companies, score with AI and add them to Google Sheet CRM

Search LinkedIn companies, Score with AI and add them to Google Sheet CRM Setup Video: Who is this for? This template is ideal for sales teams, business development professionals, and marketers looking to build a targeted prospect database with automatic qualification. Perfect for agencies, consultants, and B2B companies wanting to identify and prioritize the most promising potential clients.

Free

Filter rows in Google Sheets and send a Telegram message with the results

Automatically filter rows in Google Sheets and send the aggregated results as a Telegram message. Streamline data analysis and communication effortlessly.

Free

Multi-agent AI content creator for SEO blogs & newsletters with OpenRouter, DALL-E, Gemini

Who is this for This workflow is designed for content creators, digital marketers, bloggers, and businesses who need to produce high-quality, SEO-optimized blog posts and newsletters at scale. Perfect for marketing teams, content agencies, solopreneurs, and anyone looking to automate their content creation process while maintaining professional quality. What it does This multi-agent AI system generates complete, research-backed blog posts and newsletters automatically. Four specialized

Free

Watch Google Forms responses and add new entries to Google Sheets

Automatically track Google Forms responses and add them as new entries in Google Sheets for streamlined data management and analysis.

Free

Update Google Sheets cells with data from a custom webhook

Streamline your data management process by automatically updating Google Sheets whenever a custom webhook is triggered. This template allows you to efficiently capture and organize incoming data, ensuring your spreadsheets are always up-to-date without manual intervention. Perfect for users looking to enhance their workflow and maintain accurate records in Google Sheets.

Free

Discord setup guidelines 📜 - get all channels & categories of a Discord server

Test Your n8n Discord Connection! Trying to connect n8n to your Discord server but not sure where to start? 🤔 Setting up a Discord Bot and its credentials can be confusing. This workflow provides the perfect starting point, guiding you through the connection and running a test to fetch all channels from your server, confirming everything works! --- 🎯 What This Does This workflow is a "getting started" template designed to solve one primary problem: creating and verifying your first Discord conne

Free

Automatically sync Beex leads to HubSpot (Create & Update)

Summary Automatically sync your Beex leads to HubSpot by handling both creation and update events in real time. How It Works 1. Trigger Activation: The workflow is triggered when a lead is created or updated in Beex. 2. Data Transformation: The nested data structure from the Beex Trigger is flattened into a simple JSON format for easier processing. 3. Email Validation: The workflow verifies that the lead contains a va

Free

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.

Log in to review
Free
No ratings yet

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.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free