n8n – Payment Processing & CRM Update Automation

Goal:

Create a fully automated n8n workflow for processing online payments, updating deals in the CRM, and maintaining reporting, with error logging and manager notifications in Telegram.

Process:

1. Trigger: Receiving a Stripe webhook.
2. Deal Search: The system searches for the corresponding deal in Pipedrive using the client’s invoice number.
3. Status Update: The deal status is updated to “Paid” via the Pipedrive API.
4. Data Storage: Client and deal information is sent to Airtable for reporting.
5. Error Logging: If no deal is found, the system logs the email, status, and error message.
6. Notifications: A public alert is sent to a Telegram notification channel for managers.

Who this solution is for:

For finance teams, sales managers, and businesses that process online payments and want to minimize manual work and reduce the risk of errors when updating deals.

What problem it solves:

It completely eliminates manual payment verification and CRM updates, automates reporting and error notifications, saving time and reducing the chance of oversights.

Result:

An automated pipeline for processing online payments—from receiving the webhook to updating the CRM, maintaining reporting in Airtable, and notifying managers. The process runs reliably and without human involvement.

#Automation #n8n.io #stripe #pipedrive #airtable #Telegram