Set of 5 n8n workflows: how to stop drowning in leads, deals, and reports

A familiar picture: leads are coming in, but there's no order

The morning doesn't start with coffee, but with checking five chats. In one — a new lead from the form, in the second — a question from a client, in the third — a colleague asking for a status on a deal. While you manually transfer contacts into the CRM, reply to emails, and compile a report in Google Sheets, half the day is gone. And in the evening it turns out that a couple of leads were left unanswered, and someone created a duplicate deal in HubSpot.

This isn't a discipline problem. It's a problem of not having a system. When every step — from first touch to the client report — depends on a person, sooner or later something breaks. The good news: most of this routine can be handed off to n8n — a tool for visually building automations.

Below is a practical solution made of five connected workflows. Not theory, but a sequence of steps you can repeat.

Step 1. Capturing leads from all sources into one place

The first workflow solves the chaos at the intake stage. Its job is to collect leads from website forms, Telegram, WhatsApp, email, and social media into a single stream.

How it works:

• Webhook trigger receives data from the form or messenger.
• Field normalization brings all leads into a single format: name, contact, source, request text.
• Duplicate check compares the email or phone against existing records.
• Writing to the database (Google Sheets, Airtable, or straight into HubSpot) logs the lead with a timestamp and source.

What this gives you: not a single lead gets lost, and you get a unified funnel instead of scattered chats. It's important to think through right away which fields are critical — the cleaner the input data, the more accurate the qualification works.

Step 2. Qualification: separating hot from cold

The second workflow automatically scores a lead against set criteria: budget, urgency, fit with the target profile, keywords in the request.

The logic is simple:

1. n8n receives a new lead from the first workflow.

2. It runs it through a set of conditions or an AI node to evaluate the request text.

3. It assigns a status: hot, warm, cold.

4. It sends hot ones straight to the CRM and notifies you, and cold ones — into a nurturing sequence.

The key here is not to overcomplicate. Start with 3–5 criteria that genuinely influence the decision. If qualification is based on the lead's text, connect an LLM node — it will handle meaning recognition better than keyword search.

Step 3. Automatic deal creation in HubSpot

The third workflow is the bridge between qualification and the CRM. As soon as a lead gets the "hot" status, n8n:

• creates a contact in HubSpot (or updates an existing one);
• creates a deal at the right funnel stage;
• sets the source, owner, and date of the next touch;
• adds a note with the text of the original request.

This eliminates manual copying and, most importantly, the delay. While you're busy, the deal is already in the system, and the manager sees a priority task. If you have several lines of business, the workflow scales easily: you add a branch for each product or region.

Step 4. Client reports without manual assembly

The fourth workflow takes the weekly pain of preparing client reports off your plate. On a schedule, it:

• pulls data from HubSpot, ad accounts, and spreadsheets;
• calculates key metrics: number of leads, conversion, cost per inquiry;
• generates a readable report in Google Docs or PDF;
• sends it to the client by email or Telegram.

The client receives a regular, neat report without your involvement. You save hours that used to go into compiling numbers. This is especially valuable for agencies, where there are several clients and each has their own metrics.

Step 5. A notification system that won't let you forget

The fifth workflow is the connective tissue of the whole system. It monitors events and reminds you in time:

• a new hot lead — an instant notification in Telegram or Slack;
• a deal has been stuck at a stage for more than N days — a reminder to the manager;
• a client hasn't received a report — an alert to the person responsible;
• a lead has gone unanswered for more than an hour — escalation.

Notifications are configured by priority: critical ones — immediately, secondary ones — as a digest once a day. That way you don't drown in pushes, but you don't miss anything important either.

How to put it all together

The five workflows work like a conveyor: capture → qualification → deal → report → notification. Each subsequent one receives data from the previous one via webhook or a shared database.

If you don't want to build this from scratch, there's a ready-made automation bundle for a micro-agency: lead generation, qualification, CRM, and reporting on n8n. It already contains these five scenarios — all that's left is to connect your accounts and adapt the fields to your needs.

Adjacent tasks can also be covered by automation. For example, if you produce content to attract leads, the content factory for micro-agencies: competitor monitoring, rewriting, and auto-publishing on n8n will come in handy — it helps maintain a steady stream of publications without manual work. And for sending commercial proposals, there's the AI proposal builder for micro-agencies, which generates and sends proposals automatically.

What to consider during implementation

• Start with one workflow. Don't try to launch everything at once — debug lead capture first, then add qualification.
• Think through your data fields. A unified format at the input saves hours on rework.
• Test on real leads. Synthetic data won't reveal edge cases.
• Keep an error log. n8n can notify you about failures — enable this right away.
• Don't automate chaos. First describe the process on paper, then move it into a workflow.

Conclusion

The routine around leads, deals, and reports eats up time you could spend on growth. Five n8n workflows cover the key points: capture, qualification, CRM, reporting, and notifications. This isn't a magic pill, but a system that works while you focus on strategy.

If you want to save time on building, check out the ready-made automation bundle for a micro-agency — it already contains all five scenarios, which you can adapt to your process.