AutomationMart
Home/Browse/Track portfolio performance and risk using Google Sheets and Alpha Vantage
n8n

Track portfolio performance and risk using Google Sheets and Alpha Vantage

n8nn8n8 modulesv1.0
Google Sheets

Description This workflow helps users track and understand the performance of their stock portfolio in an automated and structured way. It reads portfolio holdings from Google Sheets, fetches the latest market prices, calculates key performance metrics, and updates the results back into the same sheet. In addition to standard return calculations, the workflow also classifies each holding based on overall performance and risk, making the output more actionable and easier to interpret. The workflo

At a glance

Track portfolio performance and risk using Google Sheets and Alpha Vantage is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Google Sheets. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Google Sheets
Modules
8
Price
Free
Version
v1.0
Track portfolio performance and risk using Google Sheets and Alpha Vantage workflow diagram

About this workflow

Description This workflow helps users track and understand the performance of their stock portfolio in an automated and structured way. It reads portfolio holdings from Google Sheets, fetches the latest market prices, calculates key performance metrics, and updates the results back into the same sheet. In addition to standard return calculations, the workflow also classifies each holding based on overall performance and risk, making the output more actionable and easier to interpret. The workflow is designed for investors who want a simple, repeatable way to monitor portfolio performance without manual calculations. ⚙️ What This Workflow Does - Reads portfolio holdings (stock, buy price, quantity, buy date) from Google Sheets - Fetches daily stock price data using Alpha Vantage - Calculates key metrics: - Invested Value - Current Value - Profit & Loss (P&L) - P&L Percentage - CAGR - Maximum Drawdown - Classifies each holding as Healthy, Watch, or Risk based on return and drawdown - Updates the same Google Sheet with the latest results - Runs automatically on a schedule ✅ Key Benefits - Eliminates manual portfolio tracking and calculations - Provides clear performance and downside risk visibility - Adds a simple decision layer through portfolio status classification - Keeps all portfolio data in one place (Google Sheets) - Dashboard-ready output for further analysis or visualization 🧩 Features - Scheduled portfolio evaluation - Daily market price data from Alpha Vantage - Deterministic, explainable financial calculations - Simple risk and performance classification logic - Google Sheets-based input and output Clean, update-in-place data handling (no duplicate rows) 🔐 Requirements - Alpha Vantage API key (for market price data) - Google Sheets OAuth credentials - An n8n instance (cloud or self-hosted) 🎯 Target Audience - Retail investors tracking long-term portfolios - Finance teams maintaining internal portfolio dashboards - Automation builders creating investment-related workflows - Users looking for a simple, explainable portfolio monitoring setup

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

Automated PR code reviews with GitHub, GPT-4, and Google Sheets best practices

AI-Agent Code Review for GitHub Pull Requests Description: This n8n workflow automates the process of reviewing code changes in GitHub pull requests using an OpenAI-powered agent. It connects your GitHub repo, extracts modified files, analyzes diffs, and uses an AI agent to generate a code review based on your internal code best practices (fed from a Google Sheet). It ends by posting the review as a comment on the PR and tagging it with a visual label like ✅ Reviewed by AI. 🔧 What It Does 1. T

Free

Send Go4Clients personalized SMS to new Google Sheet Spreadsheet rows

When a new row is added to Google Sheets Spreadsheet, Go4Clients will send a personalized SMS to the recipient. The template uses [this](https://docs.google.com/spreadsheets/d/1y0wCp8jhPwAxxwEsD8KF6Tzxy6s7-mQdIQ5VoXrQl40/edit?usp=sharing) example spreadsheet.

Free

Generate videos with AI, ElevenLabs,PIAPI Shotstack/Creatomate & post to Youtube

Auto-Generate Long Videos with AI, ElevenLabs,PIAPI,Shotstack/Creatomate & Post to Youtube Overview This n8n automation workflow automates the creation, scripting, production, and posting of YouTube videos. It leverages AI (OpenAI), image generation (PIAPI), video rendering (Shotstack), and platform integrations (Airtable, Google Sheets, YouTube) to streamline the process. Target Audience - Content creators, video producers, and YouTubers seeking to auto

Free

Pharmacy inventory alerts for low stock & expiring medicine with Google Sheets

This n8n workflow monitors pharmacy inventory stored in a Google Sheet, checks daily for low stock or near-expiry medicines, and sends alerts to the pharmacist via email, ensuring timely restocking and waste prevention. Why Use It This workflow automates inventory management for pharmacies, reducing the risk of stockouts or expired medicines, saving time, minimizing losses, and ensuring compliance with safety standards by providing proactive alerts. How to Import It 1. Download the W

Free

Automate daily AI news with Perplexity Sonar Pro (via Telegram)

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. 🧠 Perplexity-Powered Daily AI News Digest (via Telegram) This ready-to-deploy n8n workflow automates the entire process of collecting, filtering, formatting, and distributing daily AI industry news summaries directly to your Telegram group or channel. Powered by Perplexity and OpenAI, it fetches only high-signal AI updates from trusted sources (e.g. OpenAI, DeepMind, HuggingFace, MIT Tech

Free

AI Shopify product descriptions: GPT-4o Vision + Claude + Analytics

Complete AI Product Description Generator Transforms product images into high-converting copy with GPT-4o Vision + Claude 3.5 The Shopify AI Product Description Factory is a production-grade n8n workflow that converts product images and metadata into refined, SEO-aware descriptions—fully automated and region-agnostic. It blends GPT-4o vision for visible attribute extraction, Claude 3.5 Sonnet for premium copy, Perplexity research for verified brand context, Google Sheets for orchestrati

Free

Reddit API Hub: Manage posts, comments & subreddits via server-sent events

Reddit Content Operations via MCP Server 🧑‍💼 Who is this for? This workflow is built for content creators, marketers, Reddit automation enthusiasts, and AI agent developers who want structured, programmable access to Reddit content. If you're researching niche communities, tracking trends, or automating Reddit engagement — this is for you. 💡 What problem is this workflow solving? Reddit has valuable content scattered across subreddits, but manual analysis or engagement is inefficient. This workf

Free

Extract structured data from medical documents with Google Gemini AI

How it works Transform medical documents into structured data using Google Gemini AI with enterprise-grade accuracy. Classifies document types (receipts, prescriptions, lab reports, clinical notes) - Extracts text with 95%+ accuracy using advanced OCR - Structures data according to medical taxonomy standards - Supports multiple languages (English, Chinese, auto-detect) - Tracks processing costs and quality metrics automatically Set up steps Prerequisites Google Gemini API key (get from Google AI

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