📈 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