Skip to content
NEWMarketplace and the trig8n Agent: sell what you build, and get plans and changes that are tested before you see them. See what is new

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

  1. BTC Exchange Rate
  2. Call Every Hour
  3. Save Rate BTC
  4. Save Rate ETH
  5. ETH Exchange Rate
  6. Notification BTC
  7. Notification ETH

Similar automations