The Minimum Fields Every Trade Journal Entry Needs

[PTScalper]

Replace the json_payload block in your script with this updated version:

Code: Select all

// Updated JSON Payload: Numeric values are now wrapped in quotes
            json_payload = '{' +
                 '"Date": "' + str.format("{0,date,yyyy-MM-dd HH:mm}", t_entry_time) + '",' +
                 '"Pair": "' + t_pair + '",' +
                 '"Setup": "' + t_setup + '",' +
                 '"Outcome": "' + t_outcome + '",' +
                 '"Entry": "' + str.tostring(t_entry_price) + '",' +
                 '"Exit": "' + str.tostring(t_exit_price) + '",' +
                 '"StopLoss": "' + str.tostring(t_sl) + '",' +
                 '"Size": "' + str.tostring(t_size) + '",' +
                 '"RR": "' + str.tostring(realized_rr, "#.##") + '"' +
                 '}'

[PTScalper]

Because Make previously received a broken payload, it is stuck expecting binary data. You must force it to re-read the clean JSON structure.

Re-determine Data Structure:

1.1.) Right-click your Custom Webhook module in Make and select Re-determine data structure.

1.2.) Verification: The webhook module will display a spinning animation, indicating it is waiting for new data.

[PTScalper]

2.Send a Clean Test Alert:

TradingView.Create a temporary manual alert (Alt+A) on any chart. Check the Webhook URL box and paste this perfectly formatted JSON into the Message box:{"Date": "2026-09-23 15:30", "Pair": "XAUUSD", "Setup": "15m Liquidity Sweep", "Outcome": "Win", "Entry": "2520.10", "Exit": "2525.50", "StopLoss": "2517.00", "Size": "1", "RR": "1.74"}

Verification: The spinning animation in Make will stop and display a green "Successfully determined" message.

[PTScalper]

3.Remap Google Sheets:

Open your Google Sheets module in Make. Click into each spreadsheet column field and re-map the green variables (Date, Pair, Setup, etc.) from the webhook payload.

Verification: The variables in the mapping menu will now appear as normal text strings instead of binary data collections.

[PTScalper]

4.Test the End-to-End Flow:

Click Run once in Make, send one more manual dummy alert from TradingView with the exact same payload, and check your Google Sheet.

Verification: The dummy trade metrics will populate cleanly into the individual columns in your spreadsheet.