- QuantNomad's Newsletter
- Posts
- Automate Your Trading Journal (TradingView + Google Sheets)
Automate Your Trading Journal (TradingView + Google Sheets)
Most traders still log their trades manually.
Which means:
• missed trades
• incomplete records
• messy spreadsheets
But if you're already using TradingView alerts, you can automate the entire process.
In my latest tutorial, I show how to send TradingView strategy alerts directly into Google Sheets using a webhook built with Google Apps Script.
The setup looks like this:
TradingView Alert
↓
Webhook
↓
Google Apps Script
↓
Google Sheets Trading JournalEach alert automatically logs:
• ticker
• entry / exit
• price
• timestamp
• strategy name
• position size
No Zapier.
No Make.
No paid tools.
Just a simple webhook and a few lines of code.
What you’ll learn
In the tutorial I cover:
✔ building a webhook using Google Apps Script
✔ sending JSON alerts from TradingView
✔ automatically logging trades into Google Sheets
✔ testing alerts manually
✔ connecting Pine Script strategy alerts
By the end you’ll have your own automated trading journal.
Full tutorial + code
Read the full guide here:
or watch the video walkthrough:
Are you tracking agent views on your docs?
AI agents already outnumber human visitors to your docs — now you can track them.
