Library / Monitoring, Ops & Incidents
Monitoring, Ops & Incidents
Hourly Bitcoin and Ethereum Rates to Sheets and Telegram
Every hour, this fetches BTC and ETH exchange rates from Alpha Vantage, saves them in Google Sheets and sends Telegram notifications.
What it does
### 2. Collect BTC and ETH price from Alpha Vantage Insight API This starts by calling the CURRENCY_EXCHANGE_RATE function of the Alpha Vantage Insight API to get the exchange rate to euros. #### How to setup? - Set up API credentials 1. Get your free API key from Alpha Vantage 2. Fill in the API key in the HTTP Request node using query parameters authentication - Load records in the Google Sheet Node: 1. Add your Google Sheet API credentials to access the Google Sheet file 2. Select the file using the list, an URL or an ID 3. Select the sheet in which you want to record your working sessions 4. Map the fields: From_Currency_Code, From_Currency_Name, To_Currency_Code, To_Currency_Name, Exchange_Rate, Bid_Price, Ask_Price, Last_Refreshed, Time_Zone Learn more about the Google Sheet Node - Send Telegram notification 1. Add your Telegram credentials 2. Fill in the Chat ID and message content 3. Use dynamic variables for formatting the exchange rate alert
The steps
- BTC Exchange Rate
- Call Every Hour
- Save Rate BTC
- Save Rate ETH
- ETH Exchange Rate
- Notification BTC
- Notification ETH
Similar automations
Alerts & NotificationsSend BTC and ETH Analysis to Discord and Telegram37 stepsMonitoring, Ops & IncidentsBitcoin Price Drop Alerts with Bright Data and Gmail9 stepsReports, Analytics & DashboardsEmail Crypto OHLC Data for Four Coins via Gmail14 stepsFinance, Invoices & AccountingUpdate Invoice Currency Rates in Google Sheets Daily7 steps