Schedule approved LinkedIn page posts from Google Sheets with precise timing
Ready for 3.0What this workflow does
This workflow has 17 nodes and runs on a schedule (cron 45 9-12 * * *). Along the way it connects Google Sheets, Google Drive and LinkedIn.
How it runs
Trigger: On a schedule (cron 45 9-12 * * *).
- Load LinkedIn Organization Credentials (Google Sheets): uses Google Sheets
- Fetch Approved LinkedIn Posts (Google Sheets): uses Google Sheets
- Filter Posts Scheduled for Today (Code): runs custom JavaScript code
- Process First Post Only (Code): runs custom JavaScript code
- Route by Post Type (Switch): routes items into 2 branches
- Mark as Scheduled in Sheet (Google Sheets): update
- Mark Article as Scheduled (Google Sheets): update
- Wait: pauses until specific time
- Wait: pauses until specific time
- Prepare Post Data (Aggregate): combines items into one
…plus 6 more steps. See the full node list below.
Services it uses
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 (8)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - Switch
n8n-nodes-base.switch - Wait
n8n-nodes-base.wait - Aggregate
n8n-nodes-base.aggregate - Google Drive
n8n-nodes-base.googleDrive - LinkedIn
n8n-nodes-base.linkedIn
From the author
Description Automate LinkedIn organization page posting with precise time scheduling and Google Drive media management. Runs hourly during business hours, processes approved posts scheduled for today, waits until exact time, publishes to LinkedIn, and updates…