Schedule LinkedIn Posts in n8n: Sheets to PostNitro AI & Buffer

Schedule LinkedIn Posts in n8n—From Google Sheets to PostNitro AI & Buffer

This n8n workflow automatically finds unused LinkedIn post topics in your Google Sheets, generates post text using PostNitro AI, publishes to LinkedIn via Buffer, and logs results back to the sheet—sending you an email with error details if anything fails.

What this workflow does

• Runs on a schedule: executes daily at 4 PM using a scheduled trigger.
• Reads topics from Google Sheets: loads all rows and keeps only entries where the Used column equals "No".
• Generates LinkedIn post content: sends each selected topic to PostNitro AI to produce the post text.
• Publishes through Buffer: creates the LinkedIn post in Buffer using the generated content.
• Updates your sheet after posting: marks the matching row as Used = "Yes" and Status = "success".
• Handles failures with visibility: if generation fails, it updates Status = "Failed" and emails the error details via Gmail.

Use cases

• SaaS marketing teams queuing LinkedIn ideas in Google Sheets for daily publishing.
• Automation engineers standardizing a repeatable “topic → AI post → scheduled publishing” pipeline.
• Operators tracking posting progress with Used and Status directly in the source spreadsheet.

Technical details

• Schedule Trigger (runs daily at 4 PM)
• Google Sheets (read rows; update Used, Status, and row mapping)
• Filter (select rows where Used = “No”)
• PostNitro AI (generate post content; configure brandId, presetId, templateId)
• Buffer (publish to LinkedIn; configure organizationId and channelId)
• Gmail (send error notifications to a configured recipient)

Perfect for n8n users who want an SEO-friendly, production-ready LinkedIn posting workflow—built around Google Sheets, PostNitro AI, and Buffer.