Automation library · Data collection

AI-Powered WhatsApp Device Inventory System with Excel

Started by another system calling it, and works across Excel and n8n data table. 39 steps, 6 branches: large, and worth reading before you trust it with anything live.

Large

Download free
39 stepsLarge: read it before trusting it with anything live
6Branches: places the flow splits
0Loops or waits
2Services it connects to

The flow

Starts it 1Logic 16Service 22

The steps in the order they run, from what starts it.

  1. 1Webhook WAHAWebhookStarts it
  2. 2SwitchSwitchLogic
  3. 3Get ImageHttp RequestService
  4. 4Get row(s)Data TableService
  5. 5IF Y/NIfLogic
  6. 6To Base64CodeLogic
  7. 7Parse LokasiCodeLogic
  8. 8Get row(s)1Data TableService
  9. 9Send a text CancelWAHAService
  10. 10Code: Build Gemini PayloadCodeLogic
  11. 11AMBIL DATA DARI STATECodeLogic
  12. 12Send a text New LokasiWAHAService
  13. 13Gemini OCRHttp RequestService
  14. 14Switch Update/AppendSwitchLogic
  15. 15Update row(s)Data TableService
  16. 16TypingWAHAService
  17. 17SMART UPDATECodeLogic
  18. 18APPEND EXCEL / CaptionMicrosoft ExcelService
  19. 19VALIDATIONCodeLogic
  20. 20Update sheetMicrosoft ExcelService
  21. 21Send a text Append/CaptionWAHAService
  22. 22IfIfLogic
  23. 23Send a text UpdateWAHAService
  24. 24Delete row(s)Data TableService
  25. 25ParserCodeLogic
  26. 26Send a text messageWAHAService
  27. 27Delete row(s) after updateData TableService
  28. 28Code: Merge With CaptionCodeLogic
  29. 29NORMALIZE MACCodeLogic
  30. 30LOOKUP KE EXCELMicrosoft ExcelService
  31. 31FILTER ROWCodeLogic
  32. 32IF FoundIfLogic
  33. 33Send a text Data Sudah adaWAHAService
  34. 34If data incompleteIfLogic
  35. 35Y/NData TableService
  36. 36Insert rowData TableService
  37. 37APPEND EXCELMicrosoft ExcelService
  38. 38Send a text Not CompleteWAHAService
  39. 39Send a text AppendWAHAService

How it's built

Starts on
Another system calling it
Steps
39, with 6 branches
Size
Large: read it before trusting it with anything live
Connects to
Excel, n8n data table
Model
None. This is plumbing, not judgement

Questions

What does it need to run?

An n8n account, plus your own Excel account. You connect your own accounts after importing it; none are included.

What starts it?

It starts on another system calling it.

Does it use AI?

No. Every step is fixed logic or a call to a service, so it does the same thing every time.

How long does it take to set up?

Take your time. At 39 steps it is large: read it before trusting it with anything live.

How do I import it?

Copy the workflow, open a new workflow in n8n and paste. The steps appear on the canvas, ready for your own accounts.

Before you run it

Nothing here has been tested by us. It is somebody's working automation, read and described from its own steps. Treat the connections it wants as a list of accounts it will touch, and read the 39 steps before you point it at anything that matters.