Track Your Coinbase Trades in Google Sheets

In this video I show you the best way to track your Coinbase trades using the Coinbase Advanced Trade API, the google sheets API, and AWS and Google Cloud automations.
This is the most robust spreadsheet I've seen on the internet for tracking your cryptocurrency purchases, cost basis, and profit & loss. Not only because it gives you live price data, but also because of how it automatically pulls in your transaction data every time you buy or sell cryptocurrency on Coinbase, Gemini, and Kraken.
If you want to help building it out for Binance / Binance US dm me on Twitter @rhettre.
🐦 Follow me on Twitter: x.com/rhettre
📝 Companion Blog Post: www.rhett.blog/track-crypto-2...
🎥 Original sheet video: • Automatically Track Yo...
🎥 Learn more about AWS: • I Built a Crypto Tradi...
👨🏻‍💻 Link to the GitHub gist: gist.github.com/rhettre/891f3...
📈 Link to base spreadsheet: docs.google.com/spreadsheets/...
☁️ Get Started on Google Cloud: console.cloud.google.com
☁️ Get Started on AWS: console.aws.amazon.com
Download the Spreadsheet 0:00
Google Cloud Sheets 2:19
Script on AWS 5:20
Connect to Coinbase 8:18
Testing the Script 9:29

[@JesusSalazar-kv7mn]

I LOVE YOUR KNOWLEDGE BRO ! Having someone like you in there corner to make ideas come to life is blessing ! I’m prob sound super geeked 😂😂 but man your skills make me excited for the future , me and you can def do some damage

[@RhettReisman]

100% haha let's link up soon

[@JesusSalazar-kv7mn]

@@RhettReisman LOOKING forward to it brother

[@davegardner5246]

I love your tutorial vids. The automated monthly buy has been rock solid for months. I´m getting an error with this one though - "errorMessage": "Unable to import module 'lambda_function': No module named 'gspread'",

[@lideadhead]

same issue here for me. Happens when I first run the Test.

[@RhettReisman]

Yeah my bad guys, the layer.zip in the blog post didn't have google sheets API. Should be fixed now www.rhett.blog/track-crypto-2023/

[@davegardner5246]

@@RhettReisman thanks very much!

[@lideadhead]

Appears to not work when first run. Error message about module gspread not installed?

[@RhettReisman]

Totally my fault, the layer.zip in the blog post didn't have google sheets API. Should be fixed now www.rhett.blog/track-crypto-2023/

[@robnotaro8584]

When I run this I get
[ERROR] Runtime.HandlerNotFound: Handler 'lambda_handler' missing on module 'lambda_function'

[@RhettReisman]

Is it populating the spreadsheet? That looks like it's just worried about you not having a function called lambda_handler
Just updated the code in the gist with an option to get rid of that error but it should still function even if you see that error.

[@robnotaro8584]

No it isnt@@RhettReisman