Publish scheduled LinkedIn posts from Twenty CRM via Unipile and SharePoint
Ready for 3.0What this workflow does
This workflow has 12 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects Postgres. It also calls api30.unipile.com:16038 over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).
- Fetch Scheduled Posts (Twenty CRM) (Postgres): run a query
- Process Posts (Split in Batches) (Loop Over Items (Split in Batches)): loops over the items in batches
- Check Attachment Present? (If): checks a condition and branches into true / false
- Build SharePoint ShareId (Code): runs custom JavaScript code
- Unipile - Create Post (Text Only) (HTTP Request): calls api30.unipile.com:16038 (POST)
- SharePoint - Resolve Drive Item (HTTP Request): calls an HTTP API
- Unipile - Get Post Details (HTTP Request): calls an HTTP API
- SharePoint - Download Attachment (Binary) (HTTP Request): calls an HTTP API
- Mark Post as POSTED (Twenty CRM Update) (Postgres): run a query
- Unipile - Create Post (With Attachment) (HTTP Request): calls api30.unipile.com:16038 (POST)
Services it uses
HTTP calls to: api30.unipile.com:16038
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (7)
- Manual Trigger
n8n-nodes-base.manualTrigger - Postgres
n8n-nodes-base.postgres - Schedule Trigger
n8n-nodes-base.scheduleTrigger - If
n8n-nodes-base.if - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches
From the author
Quick overview Automate your LinkedIn content calendar. This workflow fetches scheduled posts from a PostgreSQL database (Twenty CRM), downloads attached media from SharePoint, and publishes them seamlessly to LinkedIn using Unipile. How it works 1. A…