n8n Workflow: Queue LinkedIn Posts from Data Table + Gmail Alerts

Queue LinkedIn Posts from an n8n Data Table—With Gmail Alerts When Nothing’s Due

This n8n workflow automatically pulls the next “to publish” LinkedIn post from an n8n Data Table every weekday at 9:00, publishes it to LinkedIn, and then marks it as published. If your post queue is empty, it immediately sends you a Gmail notification so nothing slips through.

What this workflow does

• Runs on a weekday schedule at 9:00.
• Reads your n8n Data Table and fetches the oldest row where status is set to “to publish”.
• Checks for post content in the fetched row.
• Publishes the content to LinkedIn as a text post.
• Updates the same Data Table row by setting status to “published” and recording publishedAt (publish timestamp).
• Sends a Gmail email alert if no queued content is found—informing you the content queue is empty.

Use cases

• SaaS operators who manage a backlog of LinkedIn updates and want predictable weekday publishing.
• Automation engineers building a reliable “content queue → LinkedIn → status tracking” system.
• Teams that populate an n8n Data Table with drafts, then rely on automatic publication and audit-friendly timestamps.

Technical details

• Schedule Trigger: runs weekdays at 9:00.
• Data Table: selects the next row with status = to publish and updates it after publishing.
• LinkedIn: publishes the text content to your chosen LinkedIn profile using OAuth2.
• Gmail: sends an email notification via OAuth2 when the queue is empty (recipient is configurable).
• if logic and Sticky Note for workflow structure/documentation.

Setup checklist

Create or select an n8n Data Table (e.g., content_queue) with at least id, content, status, and publishedAt. Connect your LinkedIn OAuth2 and Gmail OAuth2, set the LinkedIn profile and the Gmail recipient, then adjust the Data Table nodes (and schedule if needed).