How to Automatically Track Bitcoin Profit in Google Sheets

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!

UPDATE 2/7/2022: I UPDATED THE SCHEMA FOR THE SHEET. NEW VIDEO + RESOURCES AVAILABLE HERE: https://www.youtube.com/watch?v=hutDJ-FVatw

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

📈 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://rhettre.notion.site/Gemini-API-Functions-for-AWS-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

Видео How to Automatically Track Bitcoin Profit in Google Sheets канала Rhett Reisman - Level Up Your Brain