📈 Hourly Monitoring of Crypto Rates with Alpha Vantage API and Google Sheets

Tags: Crypto, Currency Exchange, Alpha Vantage API, Google Sheets

Context

Hi! I’m Samir — a Supply Chain Engineer and Data Scientist based in Paris, and founder of LogiGreen Consulting.

I help companies automate data pipelines using APIs, AI agents, and workflow automation to improve operational visibility and decision-making.

This workflow is part of our financial monitoring toolkit, allowing businesses to track real-time cryptocurrency exchange rates for assets like BTC and ETH.

Monitor crypto rates in real time and log the data to Google Sheets.

📬 For business inquiries, feel free to connect with me on LinkedIn

Who is this template for?

This workflow is designed for crypto analysts, finance teams, or automation enthusiasts who want to collect and track crypto exchange rates automatically for reporting or analysis.

Let’s imagine you want to monitor BTC and ETH prices against the EUR:

The Alpha Vantage API is called every hour to collect the exchange rate, bid/ask prices, and timestamp.

This data is saved in Google Sheets and can trigger a Telegram alert.

How does it work?

This workflow automates the hourly logging of crypto exchange rates:

• ⏰ Schedule Trigger launches the workflow every hour
• 🌐 Alpha Vantage API fetches BTC and ETH exchange rates (to EUR)
• 📄 Google Sheets node appends each result to a tab (BTC or ETH)
• 📲 Telegram node sends a summary alert with the latest rate info

Steps:

1. ⏰ Trigger every hour via Schedule node
2. 🌐 Call Alpha Vantage API for BTC and ETH
3. 📊 Append rates, bid/ask prices, and timestamp to Google Sheets
4. 📲 Send formatted Telegram message with rate summary

What do I need to get started?

You’ll need:

• A free Alpha Vantage API key
• A Google Sheet with BTC and ETH tabs
• A Telegram bot and Chat ID to send notifications

Next Steps

🗒️ Use the sticky notes in the n8n canvas to:

• Add your Alpha Vantage API key and Google Sheet credentials
• Set your Telegram Chat ID and bot connection
• Monitor and visualize real-time crypto prices with no manual input

This template was built using n8n v1.93.0
Submitted: June 12, 2025