Automation library · Content

Social media campaign manager with LinkedIn and Postgres

Started by a clock, and works across Email, LinkedIn, Postgres and X. 21 steps, 4 branches, 1 loop or waits: large, and worth reading before you trust it with anything live.

Large

21 stepsLarge: read it before trusting it with anything live
4Branches: places the flow splits
1Loop or waits
4Services it connects to

The flow

Starts it 2Logic 8Service 11

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

  1. 1Schedule TriggerSchedule triggerStarts it
  2. 2Daily AnalyticsCronStarts it
  3. 3Get Scheduled PostsPostgresService
  4. 4Get YesterdayFunctionLogic
  5. 5Workflow DataSetLogic
  6. 6Process PostsSplit In BatchesLogic
  7. 7Get Post MetricsPostgresService
  8. 8Facebook InsightsFacebook Graph ApiService
  9. 9Twitter MetricsHttp RequestService
  10. 10Send Daily ReportEmail SendService
  11. 11Twitter Post?IfLogic
  12. 12Post to TwitterTwitterService
  13. 13Facebook Post?IfLogic
  14. 14Update Post StatusPostgresService
  15. 15Post to FacebookFacebook Graph ApiService
  16. 16LinkedIn Post?IfLogic
  17. 17Post to LinkedInLinked InService
  18. 18Instagram Post?IfLogic
  19. 19Create Instagram MediaFacebook Graph ApiService
  20. 20MergeMergeLogic
  21. 21Publish Instagram PostFacebook Graph ApiService

How it's built

Starts on
A clock
Steps
21, with 4 branches, 1 loop or waits
Size
Large: read it before trusting it with anything live
Connects to
Email, LinkedIn, Postgres, X
Model
None. This is plumbing, not judgement

Questions

What does it need to run?

An n8n account, plus your own Email, LinkedIn, Postgres and X accounts. You connect your own accounts after importing it; none are included.

What starts it?

It starts on a clock.

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 21 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 21 steps before you point it at anything that matters.