Export your daily Binance spot portfolio to Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
Nodes used (7)
- HTTP Request
n8n-nodes-base.httpRequest - Split Out
n8n-nodes-base.splitOut - Filter
n8n-nodes-base.filter - Edit Fields (Set)
n8n-nodes-base.set - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Crypto
n8n-nodes-base.crypto - Google Sheets
n8n-nodes-base.googleSheets
What it does
What this workflow does This workflow automatically exports your Binance spot portfolio positions to Google Sheets on a daily basis, enabling you to build comprehensive tracking dashboards and analyze your crypto holdings over time. Who is this for? - Crypto investors wanting to track portfolio evolution - Traders needing historical data for analysis - Anyone wanting automated portfolio snapshots without manual exports How it works 1. Schedule Trigger - Runs daily at a configurable time 2. Binance API - Fetches current spot wallet balances 3. Data Transformation - Filters only non-null assets 4. Google Sheets - Clears sheet and appends current assets --- Setup Instructions Prerequisites - Binance account with API access enabled - Google account with Google Sheets - n8n instance (cloud or self-hosted) Step 1: Binance API Configuration 1. Go to https://www.binance.com/en/my/settings/api-management 2. Create a new API key 3. IMPORTANT: Enable ONLY "Read" permissions - DO NOT enable trading or withdrawals 4. Whitelist your server IP (recommended for security) 5. Save your API Key and Secret Key securely Step 2: Google Sheets Setup 1. Create a new Google Sheet with headers matching your exported fields (e.g., Asset | Balance) 2. In n8n, connect your Google account via OAuth2 3. Note your spreadsheet ID from the URL Step 3: Import & Configure 1. Import this workflow into n8n 2. Add your Binance credentials (API Key + Secret) 3. Configure the Google Sheets node with your spreadsheet ID and sheet name 4. Adjust the schedule trigger to your preferred time (default: daily) --- Customization Track historical positions: By default, this workflow clears the sheet before each export, giving you a real-time snapshot. To keep position history: 1. Remove the "Clear Sheet" action 2. Add a timestamp column to track when each export occurred 3. Use Google Sheets or Looker Studio to visualize daily evolutions Add price data: Extend the workflow by adding an HTTP Request node to fetch current prices from Binance API (/api/v3/ticker/price) and calculate portfolio value.