Receive email and Slack alerts on crypto prices in a spreadsheet
Are you thinking about dipping your feet into the cryptocurrency world? Surely, you will want to know the latest about your bitcoins, eths and what is going on with dogecoin. To make it easier keeping up with the market and managing your gains and risks, you will also need a way to monitor your crypto portfolio.
We’d like to introduce you to a simple tool to receive email and Slack alerts on your cryptos and keep an eye on your new prospective investment. Using Rows template Track crypto with email and Slack alerts and a built-in Alpha Vantage integration you can build the tool within minutes. Rows is the only true spreadsheet with built-in integrations and a beautiful sharing experience. Thanks to its 50+ built-in integrations Rows instantly exports data from the tools of your choice into a spreadsheet, reducing manual work and copy&paste.
This step-by-step guide will show you how to set up cryptocurrencies tracking and notifications via email and Slack:
- Sign up for your free account at https://rows.com/
2. After activating your account head to the Templates page. It’s an internal Rows library that contains all spreadsheet templates you can use to connect for data export/import and automate your workflows.
3. Search for the Track crypto with email and Slack alerts template. The template is essentially a spreadsheet that already contains a few formulas to help you quickly customise your crypto tracker.
4. Hit “Use Template” and follow the tutorial to learn how to use the tool and connect your spreadsheet with Alpha Vantage API. In a matter of minutes you will be ready to customize this crypto tracker.
5. In the setup table enter your email address or your Slack name depending on where you would like to activate the notifications. Now you can set up how often you would like to get notified. Hit “SCHEDULE” and correct the frequency and time. The tracking is set to daily notifications at 9:05 am by default.
6. In the Tracker table are already listed 20 most popular cryptos, their current exchange rate and the date/time of the latest rate update. You can easily modify this list by adding cryptos of your interest and removing irrelevant ones. Any time you can go back and make changes in your settings and cryptocurrencies list.
7. All set? Check boxes to activate email or Slack tracking (or both) and instantly start receiving your alerts. From now on you will receive regular alerts according to the schedule you set up.
Use the Track crypto with email and Slack alerts template to easily set up your personal tracker and alerts and stay on top of your crypto game.
Disclaimer: This a guest article by an employee of Rows GmbH. The views and opinions expressed in this article are those of the author and do not necessarily reflect the official position of Alpha Vantage, or any of its affiliates or subsidiaries. The accuracy, completeness and validity of any statements made within this guest article are not guarantees and we accept no liability for any errors, omissions or representations.
