Curated

(5/5)

RAG Workflow For Stock Earnings Report Analysis

Set up steps 1. Google Cloud Project & Vertex AI API: Create a Google Cloud project. Enable the Vertex AI API for your project. 2. Google AI API key: Obtain a Google AI API key from Google AI Studio. 3. Pinecone account and API key: Create a free account on the Pinecone website. Obtain your API key from your Pinecone dashboard. Create an index named company-earnings in your Pinecone project. 4. Google Drive - download and save financial documents: Go to a company you want to analize and d

Integrations Used (11)

Vectorstorepinecone

Embeddingsgooglegemini

Documentdefaultdataloader

Textsplitterrecursivecharactertextsplitter

Workflow Structure (15 nodes)

100%

Google Sheets

List Of Files To Load (Google Sheets)

Split In Batches

Loop Over Items

Google Drive

Download File From Google Drive

Langchain.embeddings Google Gemini

Embeddings Google Gemini

Langchain.vector Store Pinecone

Pinecone Vector Store

Langchain.document Default Data Loader

Default Data Loader

Langchain.text Splitter Recursive Character Text Splitter

Recursive Character Text Splitter

Manual Trigger

When clicking ‘Test workflow’

Langchain.lm Chat Open Ai

OpenAI Chat Model

Langchain.agent

AI Agent

Langchain.embeddings Google Gemini

Embeddings Google Gemini (retrieval)

Langchain.vector Store Pinecone

Pinecone Vector Store (Retrieval)

Langchain.tool Vector Store

Vector Store Tool

Google Docs

Save Report to Google Docs

Langchain.lm Chat Google Gemini

Google Gemini Chat Model1

Node Types:

default

action

logic

trigger

Requires credentials

Prerequisites

Required Credentials (6)

Google Docs

Used by: Save Report to Google Docs

Docs

Google Drive

Used by: Download File From Google Drive

Docs

Google Palm

Used by: Embeddings Google Gemini, Google Gemini Chat Model1 +1 more

Docs

Google Sheets

Used by: List Of Files To Load (Google Sheets)

Docs

OpenAI

Used by: OpenAI Chat Model

Docs

Pinecone

Used by: Pinecone Vector Store, Pinecone Vector Store (Retrieval)

Docs

Multiple services required

This workflow needs 6 different credentials. Make sure you have accounts for all services before importing.

Complexity

Advanced

Expert level. Custom code, complex logic, many integrations.

Setup time: ~1 hour

Score: 65/100

Loops

4 Integrations

When to Use This Workflow

AI-Powered Content Creation

Automate content generation, summarization, or analysis using AI capabilities.

Save hours of manual work while maintaining quality and consistency.

Automated Reporting

Automatically collect and organize data into spreadsheets for analysis.

Spend less time on data entry and more time on insights.

Real-time Response

React instantly when events happen - new orders, form submissions, or API calls.

Zero delay between trigger and action for time-sensitive workflows.

workflow.json

{
  "id": "fqaNojXWrspqjfkY",
  "meta": {
    "instanceId": "69133932b9ba8e1ef14816d0b63297bb44feb97c19f759b5d153ff6b0c59e18d"
  },
  "name": "RAG Workflow For Stock Earnings Report Analysis",
  "tags": [],
  "nodes": [
    {
      "id": "1a621f76-9636-430d-94dd-d5e7dcd5afdc",
      "name": "Pinecone Vector Store",
      "type": "@n8n/n8n-nodes-langchain.vectorStorePinecone",
      "position": [
        380,
        -60
      ],
      "parameters": {
        "mode": "insert",
        "options": {},
        "pineconeIndex": {
...