Track Crypto Prices, New Listings & Transactions with CoinGecko & Google Sheets
Last edited 58 days ago
⚙️ How It Works
This workflow is a comprehensive crypto automation system that combines three critical functions for traders and investors into one powerful tool:
📊 Price Monitor
- A
Crontrigger runs on a schedule (e.g., every minute). - A
HTTP Requestnode checks the cryptocurrency's price. - An
Ifnode compares the price against a defined threshold. - If the condition is met, a
Telegramnode sends an alert.
📰 New Listing Notifier
- An
RSS Feed Triggermonitors exchange announcements. - When a new listing is published, a
Telegramnode sends a real-time notification.
🧾 Automated Crypto Transaction Logger
- A second
Crontrigger runs daily (or as scheduled). - A
HTTP Requestnode fetches trade history from your exchange’s API. - A
Codenode formats the transaction data. - A
Google Sheetsnode logs it in your spreadsheet.
🛠️ How to Set Up
1️⃣ Configure Credentials
You will need credentials for:
- Telegram: To send alerts and notifications.
- Google Sheets: To log transaction history.
- Exchange API (e.g., Binance): To fetch your trade history.
2️⃣ Customize the Price Monitor
- Node 2:
HTTP Request (Check BTC Price)
Change theurlto monitor a different crypto (e.g., Ethereum). - Node 3:
If (Price > $50k)
AdjustrightValueto set your target price threshold. - Node 4:
Telegram (Send Alert)
Replace[YOUR TELEGRAM CHAT ID]with your actual ID.
3️⃣ Customize the Listing Notifier
- Node 1:
RSS Feed (New Listing Trigger)
ReplacefeedUrlwith your preferred exchange’s RSS feed. - Node 2:
Telegram (Listing Notif)
Replace[YOUR TELEGRAM CHAT ID]with your actual ID.
4️⃣ Customize the Transaction Logger
- Node 2:
HTTP Request (Get Binance Trades)
Set theurlto your exchange’s trade history endpoint.
ConfigureheaderParametersfor Authorization with your API key. - Node 4:
Google Sheets (Log Transactions)
Replace[YOUR SPREADSHEET ID]and[YOUR SHEET NAME]accordingly.
5️⃣ Final Activation
Once credentials and parameters are configured:
- ✅ Save the workflow
- 🔁 Activate it!
Ready to give this a visual punch with icons or a mini preview for the n8n template gallery? I can help dress it up in seconds!
You may also like
New to n8n?
Need help building new n8n workflows? Process automation for you or your company will save you time and money, and it's completely free!





