How to Automatically Track Bitcoin Profit in Google Sheets

223 Views

  • Thanks! Share it with your friends!

    You disliked this video. Thanks for the feedback!

fendekanlik
Published
In this video I show you how to automatically track your Bitcoin profits from Gemini or Coinbase Pro using the Google Sheets API and AWS. This automated strategy (paired with automated purchases) will allow you to stop worrying about the price of Bitcoin and will let you sit back relax and watch the sats roll in to your spreadsheet everyday.

Believe me, there is nothing more fun than watching your net worth increase in your Bitcoin spreadsheet!

This positive feedback loop will make you want to save even more money to watch the number go up even faster!

♊️ Sign Up for Gemini and get $10 of BTC when you Trade $100:
https://gemini.com/share/ZVG91T

???? Earn Up To A $250 BTC Bonus When You Sign Up And Fund Your New BlockFi Account!
https://blockfi.mxuy67.net/rhettre

???? Free Google Sheet to Track Bitcoin Buys: https://docs.google.com/spreadsheets/d/1QMpKvV1M6AI-6pk-76MlpDB-spTlvL7YrjZ2zm06t2k/edit?usp=sharing

???? Link to Gemini + Sheets Code in Notion: https://www.notion.so/rhettre/Buy-Bitcoin-Everyday-Lambda-Functions-Cloudwatch-abe92c33a13b4be19d232d5c91edfccf

???? Definitively The Best Way to Buy Bitcoin in 2021 with Gemini + AWS : https://youtu.be/h6r1h3am6kA

☁️ Set up Google Sheets API: https://console.cloud.google.com

???? Tech With Tim Google Sheets API Tutorial: https://www.youtube.com/watch?v=cnPlKLEGR7E

⏱ Popular Cron Expressions (formatted for AWS Cloudwatch):
15th + 30th of each Month: 0 12 15,30 * ? *
Every Friday: 0 12 ? * FRI *
Last day of each Month: 0 12 L * ? *
Everyday at 12 GMT: 0 12 * * ? *

0:00 Defining the Problem
1:25 Getting Sheets API Credentials
3:39 Connecting API to Your Sheet
4:26 Adding Lambda Layer in AWS
5:13 Writing the Lambda Function
10:45 Automating the Lambda Function
12:26 Limitations and Other Resources
14:34 Outro
Category
Crypto Investing
Tags
Be the first to comment