Skip to content
FlowHubFluxonLab
Google Sheets
Reporting & Analyticsfree

Automated IBKR Trade Report to Google Sheets Journal

by Wolfgang RennerUpdated Aug 2026
RequiresGoogle SheetsGoogle Sheets
Share Post Share
HR1. Request Flex Report1. Request Flex…Co2. Extract Reference Code2. Extract Refe…WaWait 10 SecondsHR3. Download Report3. Download Rep…SO5. Split TradesSe6. Format Trade Fields6. Format Trade…7. Save to Google Sheet7. Save to Goog…ScDaily Schedule TriggerDaily Schedule …Xm4. Convert XML to JSON4. Convert XML …12345678
1/5
STEPS · 8
Runs on a schedule

On a schedule, fetches IBKR trade data over HTTP, parses the XML report, and appends each trade to a Google Sheets journal.

Tags

cronmediumGoogle SheetsCrypto Tradingdiscoveredpending-review
Connects
sheetsGoogle Sheets
CategoryReporting & Analytics
Triggercron
Complexitymedium
Nodes9
AddedJun 27, 2026