Partnerstack Event Tracker with Sheets and Telegram Notifications - n8n Workflow
Capture Partnerstack affiliate events using an n8n trigger, automatically log details to Google Sheets, and send instant alerts via Telegram. A powerful n8n workflow for partnership management.
Workflow Preview
Ready to automate?
Download this n8n workflow template and start using it instantly.
Who is this best for?
- Affiliate and Partnership Managers seeking real-time tracking.
- Operations teams requiring automated logging of affiliate activity.
- Users looking for proven n8n templates for webhook consumption and notifications.
- Anyone who needs a comprehensive n8n workflow solution for external events.
Overview
Lack of real-time visibility into affiliate performance can slow down response times and reporting accuracy. This automated n8n workflow solves that challenge by providing an immediate, reliable conduit for Partnerstack events.
This setup utilizes a dedicated n8n trigger to catch postback data from Partnerstack. The data is then efficiently processed: first, it is logged into a structured Google Sheet for long-term reporting and audit trails. Second, an immediate, formatted notification is delivered via the Telegram n8n node to designated team channels. This high-utility n8n solution ensures your team is always instantly aware of key events like customer sign-ups or commission updates, making this one of the most practical n8n templates available for affiliate operations.
How it Works
This n8n workflow operates on a simple but powerful linear flow, initiated by an external event.
- Webhook Trigger: The process begins when Partnerstack sends a postback payload to the dedicated n8n webhook trigger URL. This n8n trigger listens specifically for POST requests, capturing all the affiliate event data (customer name, email, event type, etc.).
- Google Sheets Logging: The captured data immediately moves to the Google Sheets n8n node. This node uses expressions (
{{ $json.body.data... }}) to parse the incoming JSON and append a new row to the specified spreadsheet. Key data points like the event date, company, event name, customer name, and email are mapped precisely. - Chat ID Configuration: Next, a dedicated Set n8n node defines the target Telegram
chatId. This standardization step ensures the Telegram n8n node always sends the message to the correct destination. - Telegram Notification: The final step involves the Telegram n8n node, which formats a concise notification message. It references data captured by the initial Webhook n8n trigger and uses the configured
chatIdto instantly deliver the alert about the new Partnerstack event.
Installation Guide
- Import the n8n workflow: Copy the provided JSON and import it into your n8n instance.
- Webhook Activation: In the 'Webhook' n8n node, save the workflow and activate it. Copy the generated Webhook URL.
- Partnerstack Setup: Navigate to Partnerstack > My Account > Postbacks. Create a new postback, paste the copied n8n Webhook URL, select the events you wish to track (e.g.,
customer.created), and save. - Google Sheets Credentials: Open the 'Append Row in Sheets' n8n node. Configure your Google Sheets credential and select the target spreadsheet and sheet name where the activity log will reside. Ensure the header row matches the mapped columns (date, eventName, tool, customerName, email).
- Telegram Configuration: Set up the Telegram credentials. Then, modify the 'Set Chat Id' n8n node by replacing
setyourTelgramChatIdHerewith your actual target Telegram Group or Channel ID. This is a crucial step for this specific n8n workflow template.
Node Details
- Webhook (n8n trigger):
- Key Configuration: Uses a unique path to ensure secure and dedicated listening for this n8n workflow.
- Append Row in Sheets (Google Sheets n8n node):
- Key Configuration: Mapped columns include
date (using a JavaScript expression to format the created_at timestamp), eventName ({{ $json.body.event }}), tool, customerName, and email.- Set Chat Id (Set n8n node):
chatId) necessary for the Telegram notification step.- Key Configuration: Sets the variable
chatId to the placeholder, requiring the user to insert their Telegram chat ID for the n8n workflow to function correctly.- Send Notification (Telegram n8n node):
- Key Configuration: Uses expressions to dynamically generate the message text based on the initial input from the Webhook n8n trigger and utilizes the
chatId set in the previous n8n node.Related n8n Workflows
LLM Token Usage and AI Agent Observability Tracker via Google Sheets
Use this powerful n8n workflow to track OpenAI token consumption, calculate costs, and monitor AI agent observability metrics, logging all data automatically to Google Sheets. Ideal for cost management.
Automatic OpenAI Usage and Cost Logging to Google Sheets
Use this advanced n8n workflow to automatically track your OpenAI Admin API token usage, project costs, and API key metrics, logging all relevant financial data instantly to Google Sheets for transparent billing and analysis.
New Keyword Discovery and Zero-Click Analysis for Google Search Console
Identify new search queries (keywords) in Google Search Console that previously had zero impressions. This powerful n8n workflow uses advanced filtering logic to categorize zero-click opportunities and immediate traffic drivers.
AI-Powered Personal Finance Tracker via Slack and Google Sheets
Automate personal finance tracking by implementing a powerful n8n workflow featuring an AI Agent and Google Sheets. Log expenses via Slack messages, track debts, and receive daily financial summaries.
Pipedrive Deal Tracking and Sales Pipeline Reporting in Google Sheets
Use this comprehensive n8n workflow to automatically extract Pipedrive deal data, categorize sales stages, and append records to Google Sheets. Streamline reporting using this powerful n8n templates setup.
Hi, I’m Aitor. At 1Node we help businesses integrate full-scale AI solutions that save time, cut costs, and increase revenue. Guaranteed. Need help implementing AI infrastructures?
Featured*
