Hotmart Sales Event Logging to Google Sheets - n8n Workflow

Hotmart Affiliates and Creators needing real-time sales event tracking.
E-commerce managers requiring a centralized log of purchases, refunds, and cancellations.
Users looking for ready-made n8n templates to handle webhook data ingestion.
Anyone needing to structure and standardize raw webhook payloads before saving them.

This powerful n8n workflow is designed to streamline e-commerce backend operations by automatically capturing critical events from the Hotmart platform. By utilizing the webhook functionality as the primary n8n trigger, it instantly processes notifications regarding sales completion, protests (refund requests), subscription cancellations, and successful refunds. Before logging, the n8n node structure cleans the data, converts timestamps to readable formats, and ensures the structure is perfectly optimized for Google Sheets. This n8n workflow ensures crucial business data is immediately available for analysis without manual intervention, making it a robust solution for tracking digital product sales. This template proves the value of using n8n for reliable data pipelines.

The automation starts with the Webhook n8n trigger, which listens for incoming POST requests from Hotmart. Upon receiving an event payload, the n8n workflow immediately passes the data to the Switch n8n node. This Switch node acts as a filter, ensuring only relevant event types (such as PURCHASECOMPLETE, PURCHASEPROTEST, and PURCHASE_REFUNDED) proceed through the main pipeline. The workflow also utilizes a Save execution data n8n node connected to the trigger for historical logging and debugging purposes.

Valid event data then moves to the Convert timestamp n8n node, which translates the raw Hotmart timestamp into a standardized date/time format. Following this transformation, the Set some data n8n node extracts and structures the necessary fields (e.g., customer data, product details, and the processed event date) into the final format required by the spreadsheet. Finally, the prepared data is appended as a new row in the designated Google Sheets file via the Google Sheets n8n node. This complete n8n workflow ensures data integrity and real-time synchronization, utilizing powerful n8n templates logic.

1. Import the n8n workflow: Import this JSON code into your n8n instance to start using the automation.


2. Webhook Setup: Open the Webhook n8n trigger node and copy the provided test URL and production URL. You must configure this URL within your Hotmart account settings (under Webhooks/Notifications) to send event notifications to your n8n endpoint.


3. Google Sheets Credentials: Create a new Google Sheets credential connection in n8n. This credential must have write access to your desired spreadsheet.


4. Google Sheets Configuration: Open the final Google Sheets n8n node. Select your newly created credential, define the specific Spreadsheet ID, and specify the Sheet Name where the Hotmart event data should be recorded. Ensure your sheet headers match the fields being output by the preceding Set some data n8n node.

Webhook (n8n trigger): Function: Serves as the primary entry point, listening for POST requests sent by the Hotmart platform upon sales events. Key Configuration: Must be activated and linked to the Hotmart notification system.
Switch (n8n node): Function: Routes the n8n workflow based on the Hotmart event status (e.g., PURCHASEPROTEST, PURCHASECOMPLETE). It is crucial for filtering incoming events to ensure only actionable ones continue processing.
Save execution data (n8n node): Function: Logs the raw incoming payload from the Hotmart webhook for audit and troubleshooting purposes.
Convert timestamp (Date & Time n8n node): Function: Transforms the raw, non-standard timestamp provided in the Hotmart payload into a standardized, human-readable date and time format, which is essential for accurate reporting in Google Sheets.
Set some data (Set n8n node): Function: Selects, renames, and structures the specific data points (customer info, product ID, event type, converted date) needed for insertion into Google Sheets. This is a critical step for data consistency within this n8n workflow.
Google Sheets (n8n node): Function: The final action. It appends the prepared row of sales event data to the configured Google Sheet document. This node completes the data pipeline.