Automation

Integrate WhatsApp with CRM, ERP, and Spreadsheet: Where to Start

By VeyloCRM · · 11 min read

The company receives the order on WhatsApp, types it into the system, copies it to the spreadsheet, notifies the customer again via WhatsApp, and then records it in finance. Five manual steps, four chances for error. Integration is meant to eliminate this — not to connect every system to every other system, which is where most projects fail.

How much repeated typing costs

An operation processing 200 orders per month and spending 3 minutes per order entering the same information in two places consumes 10 hours monthly just on typing. Add rework: if 4% of entries have errors — number, quantity, address — that’s 8 cases causing new conversations, corrections, and sometimes direct losses.

It’s not just time. Manual typing creates three silent problems: outdated information, because updates depend on someone remembering; discrepancies between systems, because no one knows which is correct; and person-dependence, because when that person is absent, the flow stops.

Properly integrating these 200 orders returns 10 hours, eliminates most of the 8 errors and — the biggest gain — allows automatic customer notifications at every status change, drastically reducing the question "so, how’s my order?".

Note that the above calculation doesn’t consider any sophisticated technology. It’s basic integration, done once, working every month.

The four workflows worth it

Good integration starts small and specific. Four workflows cover almost all the value available for small and medium businesses:

1. Lead enters and becomes a record. New WhatsApp conversation creates contact and deal in the CRM, with origin filled automatically. Eliminates manual registration and ensures nothing is left out of the funnel.

2. Order status becomes message. When the order changes status in the ERP — confirmed, in production, invoiced, dispatched — the customer receives a notification. This flow reduces repetitive service volume the most.

3. Finance triggers billing and payment confirmation. Due date generates reminder; identified payment generates confirmation and automatically closes the collection sequence. Without this, customers who have already paid keep receiving invoices — the most annoying error.

4. Synchronized calendar. Confirmed scheduling in the system triggers the confirmation and reminder sequence described in scheduling and confirmation, and cancellation frees the time slot.

If you do just the second and third, you’ve already captured most of the return. Projects that try all four at once in the first month usually deliver none.

Free reading

Keep reading for free

Fill out once and unlock this and all other blog articles. We don’t charge anything — we just want to know who we’re writing for.

Takes 20 seconds. Prefer to talk directly on WhatsApp?

The three ways to integrate

From simplest to most robust. The choice depends on what you already use and who will maintain it.

1. Native integration. When the WhatsApp platform already talks to your system. It’s always the best option when available: configuration in minutes, vendor maintenance, no coding. Worth checking the integration list before hiring any tool.

2. No-code automation tool. Tools that connect systems by triggers and actions, without programming. They work very well for simple flows with moderate volume. They cost an additional monthly fee and require someone responsible for maintaining the scenarios.

3. Integration via API and webhook. The custom path: one system notifies the other when something happens. It’s the most flexible and reliable option for high volume, and the only viable one when the flow has specific business rules. Requires a developer — and, mainly, someone to maintain it afterward.

A practical decision rule: start with native; if it doesn’t exist, test no-code; only go to development when the flow is critical and recurring enough to justify maintenance. Custom integration abandoned is the one that causes the most problems because it breaks silently.

What not to synchronize

Excessive integration creates more work than it solves. Four things rarely worth it:

All conversation history inside the ERP. Pollutes the system and is not consulted. A link to the conversation and a summary of what was agreed is enough.

Complete registration editable in two places. When both sides can edit the same field, someone will overwrite the other. Define one system as the source of truth for each data point.

Real-time synchronization of non-urgent data. Reporting and consolidation can run once a day. Real-time costs more and breaks more.

Sensitive data without necessity. If a system doesn’t need the information to function, it shouldn’t receive it — a principle LGPD calls necessity and that reduces risk in case of incident.

A good integration project is defined as much by what it leaves out as by what it connects.

The first workflow in one week

A realistic roadmap to set up the most valuable flow without stopping operations:

Monday — choose and design. One flow only, the most repetitive. Draw it on a sheet: what triggers it, what happens, who receives, what is recorded where.

Tuesday — define the source of truth. For each field, which system sends it. This decision avoids 80% of future problems.

Wednesday — configure in test environment. With two or three real cases, including the odd ones: customer without email, canceled order, invalid number.

Thursday — run in parallel. Automation works, but someone checks manually. It’s the step no one wants to do and the one that most prevents damage.

Friday — connect for real and document. One page with what was done, who maintains it, and what to do if it stops. Integration without documentation becomes a mystery in three months, usually when the person who set it up is no longer there.

Only after this flow runs stable for two weeks is it worth starting the second.

When the spreadsheet is still the right answer

Not every integration needs a system. For small operations, a well-connected spreadsheet solves it at almost zero cost — and is better than an ambitious project that never leaves the drawing board.

Three uses where it holds up well:

Lead registration with origin. Each new conversation becomes a row with date, name, phone, origin, and status. Allows calculating response time, conversion by channel, and volume per week without any paid tool.

Base for occasional sends. Segmented list, with date of last contact and consent recorded in its own column — a condition for any active action.

Campaign control. Who received what and when, to avoid repeated contact and to measure response by group.

Limits appear quickly: spreadsheets don’t notify anyone, don’t prevent two people editing the same row, and don’t keep conversation history. When the team exceeds two people or volume exceeds about one hundred conversations per week, the cost of keeping the spreadsheet updated exceeds the monthly fee of a system — and it’s this crossover, not company size, that indicates the time to switch.

What breaks and how to notice

Integration is not a delivered project: it’s a living system. Three things break frequently and all break silently:

Expired credential. Token expires, password changes, and the flow stops without notifying anyone.

Field change. Someone renames a field in the ERP and automation starts recording in the wrong place.

Duplication and loop. Two triggers pointing to the same action create duplicate records — or, worst case, repeated messages to the customer.

Three defenses solve this: an alert when the flow fails (and someone assigned to receive it), a weekly five-minute check comparing what entered both systems, and a safety cap on automatic sending so a configuration error never triggers hundreds of messages.

This last point deserves special attention: defective automation not only irritates the customer but can also get the number banned, for reasons described in why WhatsApp bans business numbers.

Errors that cause the project to fail

Trying to integrate everything at once. Too big a project delivers not even the first flow.

Not defining the source of truth. Two systems with the same editable information guarantee divergence.

Automating a messy process. Integration speeds up what exists — including errors. Organize first.

No one responsible. Integration without an owner breaks and no one notices until the customer complains.

No test environment. Testing in production is like learning to drive on the highway.

No sending limit. A poorly configured loop can trigger message series and get the number banned.

No documentation. In three months, no one remembers why it was done that way.

Well-done integration is invisible: the customer receives the notification at the right time, the salesperson doesn’t type twice, and the manager trusts the report. Getting there requires starting with one flow, defining who controls each data point, and accepting that maintenance is part of it — in that order.

Frequently asked questions

Where to start integrating WhatsApp with other systems?

With the most repetitive flow in your daily routine, almost always the automatic notification of order status change or the billing sequence with automatic payment confirmation. Draw the flow on a sheet, define which system is the source of truth for each field, configure in a test environment with real cases, run in parallel with manual checks for a few days, and only then activate — documenting who maintains it and what to do if it stops.

Do I need a programmer to integrate WhatsApp with my system?

Not always. If the WhatsApp platform already has native integration with your system, configuration takes minutes and maintenance is handled by the vendor. If not, no-code automation tools solve simple flows with moderate volume. Custom development via API and webhook is only justified when the flow is critical, recurring, and has specific business rules — and when there is someone to maintain it afterward.

What can go wrong in a WhatsApp integration?

Three failures repeat, all silently: credentials expire and stop the flow, fields renamed in the other system start recording in the wrong place, and duplicate triggers create repeated records or trigger message series. Defenses are a failure alert with a responsible person assigned, a weekly five-minute check comparing the two systems, and a safety cap on automatic sending.

Centralize service without changing your number

Connection via QR or official API, single queue with assigned responsible, customer history that stays with the company, and sales funnel on the same WhatsApp panel.