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!


Clickbank Promo Tools

β™ŠοΈ 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

22 thoughts on “How to Automatically Track Bitcoin Profit in Google Sheets

  • January 21, 2022 at 9:01 pm
    Permalink

    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 πŸ™πŸΎ

    Reply
  • January 21, 2022 at 9:01 pm
    Permalink

    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!

    Reply
  • January 21, 2022 at 9:01 pm
    Permalink

    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?

    Reply
  • January 21, 2022 at 9:01 pm
    Permalink

    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 😁

    Reply
  • January 21, 2022 at 9:01 pm
    Permalink

    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?

    Reply
  • January 21, 2022 at 9:01 pm
    Permalink

    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!

    Reply
  • January 21, 2022 at 9:01 pm
    Permalink

    Just finished setting up both automated Gemini buys and Sheets update. This is gold. I love your channel. Thank you!

    Reply
  • January 21, 2022 at 9:01 pm
    Permalink

    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 !

    Reply
  • January 21, 2022 at 9:01 pm
    Permalink

    Took a little tinkering since Google changed the way to get your json file but I got it and this is so awesome! THANKS!!!

    Reply
  • January 21, 2022 at 9:01 pm
    Permalink

    Do you have to pay for the AWS account usage?

    Reply
  • January 21, 2022 at 9:01 pm
    Permalink

    Loving the videos, super helpful. I got this set up yesterday!! Thanks

    Reply
  • January 21, 2022 at 9:01 pm
    Permalink

    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 πŸ™‚

    Reply
  • January 21, 2022 at 9:01 pm
    Permalink

    Well I can't find my functions in aws no more!!! but the buys still happening do you know what's going on Rhett?

    Reply
  • January 21, 2022 at 9:01 pm
    Permalink

    Can you do a Coinbase Pro?

    Reply
  • January 21, 2022 at 9:01 pm
    Permalink

    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?

    Reply
  • January 21, 2022 at 9:01 pm
    Permalink

    Thank you Rhett! This is super helpful πŸ™‚

    Reply
  • January 21, 2022 at 9:01 pm
    Permalink

    this one didnt work for me'

    Reply
  • January 21, 2022 at 9:01 pm
    Permalink

    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.

    Reply
  • January 21, 2022 at 9:01 pm
    Permalink

    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

    Reply
  • January 21, 2022 at 9:01 pm
    Permalink

    you are a genius

    Reply
  • January 21, 2022 at 9:01 pm
    Permalink

    great content king. liked button, channel subbed, bell smashed, profits made, wealth rising, spreadsheets filling, brain leveled up.

    Reply
  • January 21, 2022 at 9:01 pm
    Permalink

    How are you currently tracking your Bitcoin profits?

    Reply

Leave a Reply

Your email address will not be published.

%d bloggers like this: