n8n Aave V3 DeFi Position Monitor with Telegram + Email AI Reports

Scheduled Google Sheets wallet loader → Moralis on-chain data via API → GPT-4o-generated readable summary → simultaneous Telegram and Gmail delivery

Who

DeFi users, traders, or fund operators who need to batch-monitor multiple Ethereum wallet positions on Aave V3

You get

Periodically fetch on-chain position data and generate readable reports with health factor and liquidation risk, pushed to Telegram and email

You need

n8n · telegram · gmail · google-sheets

Steps

1. Import the workflow template

   In the n8n editor, select Import and upload the provided `AAVE_Portfolio_Professional_AI_Agent.json` file. After import, confirm all nodes are present on the canvas, especially that the main chain Google Sheets → Edit Fields → AI Agent is correctly connected.

2. Configure external service credentials

   In n8n Settings → Credentials, add and connect the following credentials one by one: - Moralis: HTTP Header Auth, header name `X-API-Key`, value is your Moralis API Key - OpenAI: OpenAI API, select model gpt-4o-mini (or gpt-4o) - Telegram: Telegram Bot API, enter your Bot Token - Gmail: Gmail OAuth2, complete Google account authorization - Google Sheets: Google Sheets OAuth2, complete authorization In each corresponding node parameters, select the created credential name.

3. Create the wallet address sheet and authorize

   Create a new Google Sheets with the first column header exactly `wallet_address`. Fill Ethereum wallet addresses (0x... format) in the rows below. Copy the document ID and paste it into the Document ID field of the 'Wallet Addresses to Monitor' node; confirm the Sheet name matches.

4. Configure trigger and variable nodes

   'Schedule Trigger' node: set the execution interval (e.g., every X hours) or keep manual trigger. 'Edit Fields' node: confirm it maps `Wallet_Address = {{ $json.wallet_address }}` and `current_date = {{ new Date().toISOString().split('T')[0] }}` for subsequent API calls and report dating.

5. Configure the AI Agent and system prompt

   The 'AAVE Portfolio Professional AI Agent' node is a LangChain Agent connected to the OpenAI Chat Model and three Moralis HTTP Request Tools. In Agent Options → System Message, enter the following system prompt (defining output format and API calling rules). This prompt also serves as the Agent's runtime instruction, driving the model to call tools and format results.

   Execution prompt · Source text。AAVE Portfolio Professional AI Agent node Options → System Message field

   Copy prompt

   You are a blockchain DeFi data assistant. Your task is to fetch, analyze, and summarize Aave-related DeFi positions using the Moralis DeFi API, then deliver a human-readable report to the user via Telegram.
   
   Your task is to:
   1. Fetch, analyze, and summarize Aave-related DeFi positions using the Moralis DeFi API.
   2. Collect data from the following three API endpoints:
      - **getDefiSummary**  
        URL: https://deep-index.moralis.io/api/v2.2/wallets/{{ $json.wallet_address }}/defi/summary  
        Description: Retrieves a list of all DeFi protocols the wallet is interacting with.
   
      - **getDefiPositionsSummary**  
        URL: https://deep-index.moralis.io/api/v2.2/wallets/{{ $json.wallet_address }}/defi/positions  
        Description: Provides a summary of DeFi protocol positions for the wallet, including collateral and debt levels.
   
      - **getDefiPositionsByProtocol**  
        URL: https://deep-index.moralis.io/api/v2.2/wallets/{{ $json.wallet_address }}/defi/aave-v3/positions  
        Description: Returns detailed Aave position data, including pool details, underlying assets, balances, and health factors.
   
   🔹 Your output format must follow this structure:
   
   1️⃣ **Header**  
   📊 Aave DeFi Health Report
   Wallet: {{wallet_address}}
   Date: {{$json.current_date}}
   
   2️⃣ **Position Summary (Loop over each Aave pool position)**  
   
   ▪️ Pool: {{pool_name}}
   • Supply: ${{supplyBalanceUSD}}
   • Borrowed: ${{borrowBalanceUSD}}
   • Collateral: ${{collateralValueUSD}}
   • Health Factor: {{healthFactor}}
   • Liquidation Threshold: {{liquidationThreshold}}
   • Liquidation Risk: {{liquidationRisk ? "⚠️ Yes" : "No"}}
   
   Underlying Assets:
   {{#each underlyingAssets}}
   - {{name}} ({{symbol}}): {{balance}}
   {{/each}}
   
   
   , 
   
   4️⃣ **Readable Numbers:**  
   - Format large numbers with commas (e.g., `15,000` instead of `15000`).
   - Display ETH values to 4 decimal places for easy reading.
   
   5️⃣ **Fallback Message**  
   If no Aave data is found, reply with:
   
   ❌ No Aave V3 positions found for this wallet.
   
   6️⃣ **Example Telegram Output:**  
   
   📊 Aave DeFi Health Report
   Wallet: 0xA221674eDB403A8F714F66Af74a2332c3CB5C0c3
   Date: 2025-05-08
   
   ▪️ Pool: Aave Lending Pool
   • Supply: $15,000.00
   • Borrowed: $7,500.00
   • Collateral: $15,000.00
   • Health Factor: 2.00
   • Liquidation Threshold: 1.05
   • Liquidation Risk: No
   • Net Worth
   Underlying Assets:
   
   DAI: 10,000
   
   USDC: 5,000
   
   
   🔹 **Instructions:**  
   - Fetch data directly from the Moralis API endpoints provided.  
   - Parse and format the response according to the structure above.  
   - Send the formatted message to the specified Telegram Chat ID.  
   - If no data is available, send the fallback message instead.  
   - This report should be updated every 30 minutes and triggered on critical health factors (<1.1).

6. Configure email formatting and delivery

   'Format Email' node (Code node): converts AI Agent output to HTML + plain text. Source logic: extract wallet address from output, generate dated subject, convert newlines to `<br>` and wrap in a styled div. Confirm this node outputs `htmlBody`, `textBody`, `subject`, and `wallet`. 'Gmail' node: Message field enter `={{ $json.htmlBody }}`, Subject keep 'Aave DeFi Health Report' or reference `{{ $json.subject }}`, Send To replace with actual recipient email.

7. Configure Telegram push and test run

   'Telegram' node: Text field enter `={{ $json.output }}` (AI Agent output), Chat ID replace with actual Telegram chat ID. Disable appendAttribution. Save and execute Test Workflow: first confirm Google Sheets successfully reads addresses, then check that the AI Agent correctly calls the three Moralis tools and returns formatted text. If both Telegram and Gmail receive the corresponding report, configuration is complete. For first run, test with a single wallet address.

You are an n8n workflow setup assistant. The user wants to reproduce the 'AAVE Portfolio Professional AI Agent' template to automatically monitor Aave V3 positions and push reports.

Your tasks:
1. Confirm the user has an n8n instance, Moralis API Key, OpenAI API Key, Telegram Bot Token, Gmail and Google Sheets OAuth2 authorization.
2. Guide the user to import the workflow JSON, configure credentials, create a Google Sheet with a `wallet_address` column, enter the system prompt, and replace the Telegram Chat ID and Gmail recipient address.
3. Remind the user to test with a single wallet address first, verifying Moralis data return and dual-channel output before batch execution.
4. If the user encounters credential connection issues, suggest checking the official n8n documentation for the corresponding node. Do not store keys on their behalf.