Automate Stripe Charge Notes Creation with n8n & Pipedrive

What this workflow does

This workflow connects Stripe charges to the correct Pipedrive organizations automatically. It solves the problem of manual matching by fetching recent successful Stripe payments and adding notes to the right sales entries in Pipedrive daily. The result is error-free updates that save time and keep sales data accurate.

It runs every morning at 8 AM, ensuring new payment info is linked without manual work. This means less mistakes, less work, and a better view of customer payments for the sales team.

Tools and services used

• Stripe API: Gets recent payment charges and customer details.
• Pipedrive API: Searches organizations and creates notes for payment charges.
• n8n platform: Runs the automation workflow with various nodes.

How the workflow works: Inputs → Process → Output

Inputs

• The last workflow run time saved in static data.
• Stripe API access to search charges and customers.
• Pipedrive API access to search organizations and create notes.

Processing steps

• Read the last run timestamp to avoid duplicates.
• Query Stripe for successful charges created after last run.
• Split the list of charges into individual items.
• Retrieve all Stripe customers to get clear names.
• Merge charges with customer names by matching customer IDs.
• Search Pipedrive for organizations matching customer names.
• Merge charge data with matched organization info.
• Create notes in Pipedrive organizations with charge descriptions and amounts.
• Update the last run timestamp for future workflow triggers.

Output

• New notes in Pipedrive linked to organizations, showing recent Stripe charge details.
• Accurate sales payment records without manual effort.

Beginner step-by-step: How to use this workflow in n8n for production

Step 1: Import the workflow

1. Click the Download button on this page to get the workflow JSON file.
2. Open your n8n editor, click on “Import from File” and select the downloaded JSON file.

Step 2: Configure credentials and IDs

1. Add your Stripe API Key in the n8n Stripe credential node.
2. Add your Pipedrive API Key in the Pipedrive credential node.
3. Check any fields that require organization IDs, emails, or other unique values and update them to match your data.

Step 3: Test the workflow

1. Run the workflow once manually to check for errors.
2. Verify that new notes appear in Pipedrive organizations for recent Stripe charges.

Step 4: Activate workflow

1. Turn on the workflow using the Activate button in n8n.
2. Confirm the Cron trigger will run daily at 8 AM, making updates automatically.

If you want to self host n8n for more control or cost saving, consider self-host n8n.

Customization ideas

• Change the daily run time by editing the Cron node hour.
• Add filters in Stripe query to handle only charges you want.
• Include extra customer info like email or phone in the notes by updating the Set node.
• Make notes richer by adding payment date or metadata in Pipedrive node content.

Common edge cases and failures

• Stripe authentication errors mean API Keys are wrong or expired; check credentials in n8n.
• Pipedrive find organization may fail if names do not match well; consider fuzzy search or improving naming.
• Cron node may trigger at wrong time if timezone is wrong; verify server timezone and Cron settings.

Summary of benefits and results

✓ Saves more than 2 hours daily by removing manual data entry.

✓ Creates accurate links between Stripe charges and Pipedrive organizations.

✓ Keeps sales team informed with detailed charge notes.

✓ Frees team to focus on selling, not admin.