Automation library · Data collection

Sync warehouse stock to GoHighLevel with SFTP and Google Drive

Started by another system calling it, and works across FTP and Google Drive. 26 steps, 3 branches, 1 loop or waits: large, and worth reading before you trust it with anything live.

Large

Download free
26 stepsLarge: read it before trusting it with anything live
3Branches: places the flow splits
1Loop or waits
2Services it connects to

The flow

Starts it 3Logic 13Service 10

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

  1. 1Cron TriggerSchedule triggerStarts it
  2. 2Manual Trigger – Google Drive TestManual triggerStarts it
  3. 3WebhookWebhookStarts it
  4. 4Parse Webhook XMLCodeLogic
  5. 5SFTP List FilesFtpService
  6. 6Google Drive - Download XMLGoogle DriveService
  7. 7LimitLimitLogic
  8. 8Filter Stock FilesIfLogic
  9. 9Parse Drive XMLCodeLogic
  10. 10Loop Over ItemsSplit In BatchesLogic
  11. 11Get Latest FileCodeLogic
  12. 12Search Product by NameHttp RequestService
  13. 13Search Product by Name (Webhook)Http RequestService
  14. 14Download XML FileFtpService
  15. 15Check if Product Exists (Drive)CodeLogic
  16. 16IfIfLogic
  17. 17Parse SFTP XMLCodeLogic
  18. 18IF - Update or Create Product (Drive)IfLogic
  19. 19Update ProductHttp RequestService
  20. 20Create ProductHttp RequestService
  21. 21Extract RecordsCodeLogic
  22. 22Update Product Stock (Drive)Http RequestService
  23. 23Create New Product (Drive)Http RequestService
  24. 24Split Out ItemsSplit OutLogic
  25. 25Transform DataCodeLogic
  26. 26Update Stock via APIHttp RequestService

How it's built

Starts on
Another system calling it
Steps
26, with 3 branches, 1 loop or waits
Size
Large: read it before trusting it with anything live
Connects to
FTP, Google Drive
Model
None. This is plumbing, not judgement

Questions

What does it need to run?

An n8n account, plus your own FTP and Google Drive accounts. 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 26 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 26 steps before you point it at anything that matters.