N8N WORKFLOW SETUP
Add Pipedrive reporting to an n8n workflow
Connect Adzviser to an AI Agent, test one request, and only then add the schedule, alert, or delivery step.
Connect Pipedrive to Adzviser
In Adzviser, sign in to Pipedrive and allow Adzviser to read its reporting data.
Configure the MCP Client Tool
Add n8n's MCP Client Tool to an AI Agent, enter Adzviser's server address and credentials, and test the tool before activating the workflow.
https://mcp.adzviser.com/httpTest before activating
Run the workflow manually with one Pipedrive request. Check the selected account, dates, and output before turning on its trigger.
AUTOMATION BLUEPRINT
Build a repeatable Pipedrive reporting workflow
Keep the automation easy to audit: one trigger, one clearly scoped analysis, and one useful destination for the result.
Decide when it runs
Use a schedule, webhook, or manual trigger and calculate a complete reporting period before requesting data.
See a related Pipedrive promptGive the AI Agent a stable instruction
Fix the account-selection rule, metrics, breakdowns, comparison, and output format so each run is consistent.
See a related Pipedrive promptSend a result people can use
Route the takeaway and evidence table to email, Slack, a database, or the next approved step in your workflow.
See a related Pipedrive promptN8N AI AGENT INSTRUCTION
Use a structured Pipedrive instruction in every run
A predictable output makes the automation easier to test, route, and monitor.
Compare recent results with the previous period and call out the largest changes.
First show my connected Pipedrive accounts and ask me which one to use. Then complete this analysis: Analyze Pipedrive revenue trends from the workspace I choose for the last 30 complete days. Show: Weekly/Monthly Revenue, Deal Count, Average Deal Size, and Win Rate. Is revenue growing? Are there seasonal patterns? What's driving trends? Return valid JSON with keys summary, evidence, alerts, and next_steps so the following n8n node can route the result reliably.
