{"product_id":"n8n-workflow-queue-linkedin-posts-from-data-table-gmail-alerts","title":"n8n Workflow: Queue LinkedIn Posts from Data Table + Gmail Alerts","description":"\u003ch3\u003eQueue LinkedIn Posts from an n8n Data Table—With Gmail Alerts When Nothing’s Due\u003c\/h3\u003e\n\u003cp\u003eThis 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.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a weekday schedule\u003c\/strong\u003e at \u003cstrong\u003e9:00\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads your n8n Data Table\u003c\/strong\u003e and fetches the \u003cstrong\u003eoldest row\u003c\/strong\u003e where \u003cstrong\u003estatus\u003c\/strong\u003e is set to \u003cem\u003e“to publish”\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eChecks for post content\u003c\/strong\u003e in the fetched row.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePublishes the content to LinkedIn\u003c\/strong\u003e as a text post.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates the same Data Table row\u003c\/strong\u003e by setting \u003cstrong\u003estatus\u003c\/strong\u003e to \u003cem\u003e“published”\u003c\/em\u003e and recording \u003cstrong\u003epublishedAt\u003c\/strong\u003e (publish timestamp).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends a Gmail email alert\u003c\/strong\u003e if no queued content is found—informing you the content queue is empty.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaaS operators\u003c\/strong\u003e who manage a backlog of LinkedIn updates and want predictable weekday publishing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAutomation engineers\u003c\/strong\u003e building a reliable “content queue → LinkedIn → status tracking” system.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTeams\u003c\/strong\u003e that populate an n8n Data Table with drafts, then rely on automatic publication and audit-friendly timestamps.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedule Trigger\u003c\/strong\u003e: runs weekdays at \u003cstrong\u003e9:00\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData Table\u003c\/strong\u003e: selects the next row with \u003cem\u003estatus = to publish\u003c\/em\u003e and updates it after publishing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLinkedIn\u003c\/strong\u003e: publishes the text content to your chosen LinkedIn profile using \u003cstrong\u003eOAuth2\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e: sends an email notification via \u003cstrong\u003eOAuth2\u003c\/strong\u003e when the queue is empty (recipient is configurable).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eif\u003c\/strong\u003e logic and \u003cstrong\u003eSticky Note\u003c\/strong\u003e for workflow structure\/documentation.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eSetup checklist\u003c\/h3\u003e\n\u003cp\u003eCreate or select an n8n Data Table (e.g., \u003ccode\u003econtent_queue\u003c\/code\u003e) with at least \u003ccode\u003eid\u003c\/code\u003e, \u003ccode\u003econtent\u003c\/code\u003e, \u003ccode\u003estatus\u003c\/code\u003e, and \u003ccode\u003epublishedAt\u003c\/code\u003e. Connect your \u003cstrong\u003eLinkedIn OAuth2\u003c\/strong\u003e and \u003cstrong\u003eGmail OAuth2\u003c\/strong\u003e, set the LinkedIn profile and the Gmail recipient, then adjust the Data Table nodes (and schedule if needed).\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45899942559923,"sku":"N8N-18726","price":7.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Wiy5zYd7fDR4v9G_fxqSQ_wf9GSwdd.png?v=1787734838","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-queue-linkedin-posts-from-data-table-gmail-alerts","provider":"N8N Commerce","version":"1.0","type":"link"}