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!
βοΈ Sign Up for Gemini and get $10 of BTC when you Trade $100:
π¦ Earn Up To A $250 BTC Bonus When You Sign Up And Fund Your New BlockFi Account!
π Free Google Sheet to Track Bitcoin Buys:
π Link to Gemini + Sheets Code in Notion:
π° Definitively The Best Way to Buy Bitcoin in 2021 with Gemini + AWS :
βοΈ Set up Google Sheets API:
π€ Tech With Tim Google Sheets API Tutorial:
β± 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
source
Hey rhett you're a King! I was following along trying to add the credentials, but the question "where will u be calling the API from?" Never came up so i didnt get that json link could i get any help??? Please ππΎ
I absolutely love your videos and because of them I have spreadsheets for both BTC and LUNA but in the Buy Audit File tab I am only getting data for columns A through G. Should there be data all the way across? Also, the purchase asymmetry stats are both spitting out the DIV/0 error. Should that not be the case? Thanks!
Hey Rhett, I noticed today that two lines were filled in the spreadsheet randomly. Not sure where they came from but one transaction was for .65 and the other was .35 cents. Any idea why that would happen?
Hey Rhett, I've tried to set this up but I keep getting the same error of not being able to find the spreadsheet. I guess im doing something wrong when I try to share the sheet with the email. How do I properly open that in my drive? Maybe that's the problem that I'm having.
When I try to share it, it says "link sent" but not "person added"
Edit: figured it out π
I cannot get this to work with CBP. Everything appears to be configured, but the only data I see in the spreadsheet is all of your Gemini transactions and nothing of mine. Should my data overwrite your data in this sheet?
Thank you Rhett! Going to Drop a comment for the YT Gods – These Gemini Step-by-Step are the BEST I've ever used on YT – THANK YOU!
Just finished setting up both automated Gemini buys and Sheets update. This is gold. I love your channel. Thank you!
I have learned so much from your videos. (Brain Level 2). Seriously people hit the like and subscribe button, these vids need more views, follow, and likes !
Took a little tinkering since Google changed the way to get your json file but I got it and this is so awesome! THANKS!!!
Do you have to pay for the AWS account usage?
Loving the videos, super helpful. I got this set up yesterday!! Thanks
Just for info. – you can add transaction_type = str(transaction['type']) to return whether the transaction is a buy or sell. You also need to add it to the return function just below the first definition paragraph. With how things are set up in GSheets, it doesn't recognize the difference – but throwing around a couple of if statements works pretty well to split off the sales π
Well I can't find my functions in aws no more!!! but the buys still happening do you know what's going on Rhett?
Can you do a Coinbase Pro?
First, this worked really well and is super useful, so thank you for another excellent tutorial. One question and want to preface this by saying that I am no excel/sheets wizard. Maybe I am not understanding correctly…but column K and column L seem to have the same formula. Is that how it is supposed to be?
Thank you Rhett! This is super helpful π
this one didnt work for me'
Awesome upload and guide! Just one suggestion, ETH GSheet is not populating correctly as It will require manual change. Could you please create ETH G Sheet as well. For BTC, it is working perfectly fine and really appreciate your guide.
my only concern is there may contains some security vulnerability cause I donβt understand your
code. Could you please do a video explain the Gemini layer in lambda? Ty
you are a genius
great content king. liked button, channel subbed, bell smashed, profits made, wealth rising, spreadsheets filling, brain leveled up.
How are you currently tracking your Bitcoin profits?