Daily Crypto Yield Tracking and Automated Reporting - n8n Workflow

Cryptocurrency investors and traders who monitor yield products.
Users needing secure, automated daily reports of high-yield assets.
Developers seeking a practical example of secure HMAC-SHA256 request signing within an n8n node setup.
Anyone looking for effective n8n templates for financial monitoring.

Financial market surveillance is crucial, but manually checking dozens of assets for the best APY rates daily is time-consuming. This robust n8n workflow solves this problem by providing fully automated, secure monitoring of Binance Flexible Earn products.

This n8n template authenticates with the Binance API using HMAC-SHA256 signatures, fetches up to 100 products, sorts them by their latest Annual Percentage Rate (APY), calculates potential daily earnings based on a simulated investment, and compiles all data into an easy-to-read HTML email report.

By deploying this powerful n8n workflow, users ensure they never miss the highest-yielding opportunities, streamlining their financial automation processes. The use of the n8n node architecture simplifies complex crypto API interactions.

The entire process is initiated by an n8n trigger and moves through three primary phases: secure authentication, data processing, and final reporting.

1. Scheduled Execution (n8n Trigger): The n8n workflow starts daily, triggering the data preparation sequence.


2. API Preparation & Signing: The Prepare Data code n8n node generates the current Unix timestamp and the precise query string required by Binance. The Set Credentials n8n node feeds the secure API Key and Secret. A crucial Crypto n8n node then signs the query string using HMAC-SHA256 and the secret key to generate the required API signature.


3. Data Fetching: The HTTP Request n8n node uses the generated signature, timestamp, and API Key to securely pull the list of Flexible Earn products from the Binance API.


4. Processing & Filtering: The raw JSON data is split into individual asset items using the Split Out n8n node. These items are cleaned, sorted by APY rate (descending), and limited to the top 15 highest-yielding assets using the Limit n8n node.


5. Analysis: The final Filter & Analyze code n8n node calculates the estimated daily income for each of the top 15 assets, based on a default simulated capital of $10,000 (which is easily adjustable within the n8n node).


6. Reporting: Finally, the Gmail n8n node compiles the analyzed results into an HTML list and sends the Daily Yield Report to the configured email recipient.

To utilize this n8n template, follow these steps:

1. Import the n8n workflow: Copy the provided JSON code and import it directly into your n8n instance.


2. Configure Binance Credentials: Locate the 'Set Credentials' n8n node (a 'Set' node) and replace YOURBINANCEAPIKEY and YOURBINANCESECRETKEY with your actual Binance API Key and Secret. Ensure your API key has read access to Simple Earn Flexible products.


3. Configure Email Credentials: Double-click the 'Send Email' n8n node. You will need to set up a Gmail OAuth2 credential (or use another email service like SMTP) and specify the To address where you wish to receive the daily report.


4. Activate: Save the n8n workflow and activate it to start the daily monitoring schedule.

Daily Trigger (Schedule Trigger n8n node): Serves as the primary n8n trigger, initiating the data collection every 24 hours.
Prepare Data (Code n8n node): Generates the essential Unix timestamp for security and constructs the base query string required for the Binance API request. This step is vital for the request signing process.
Set Credentials (Set n8n node): Temporarily holds the sensitive Binance APIKEY and SECRETKEY for use in subsequent n8n nodes, streamlining credential management within the n8n workflow execution.
Sign Request (Crypto n8n node): Executes the HMAC-SHA256 encryption using the secret key against the prepared query string, producing the necessary signature required by the Binance n8n node API.
Get Earn Rates (HTTP Request n8n node): Securely fetches raw product data from the Binance API, utilizing the signed parameters and API key.
Split Out (Split Out n8n node): Transforms the single JSON object containing a 'rows' array into multiple individual items, allowing subsequent n8n nodes to process each asset separately.
Sort (Sort n8n node): Orders the individual asset items by the latestAnnualPercentageRate field in descending order to identify the highest yields.
Limit (Limit n8n node): Restricts the dataset to the top 15 highest APY products, optimizing the final report size.
Filter & Analyze (Code n8n node): Performs the final calculation, simulating estimated daily earnings based on a $10,000 capital, and formats the output for the email report. This custom code n8n node adds crucial value-added metrics to the core data.
Send Email (Gmail n8n node): Generates and sends the final HTML formatted report detailing the top assets, APY, and daily income estimates. This is the final action of the n8n workflow.