{"product_id":"n8n-workflow-auto-schedule-social-posts-from-google-sheets","title":"n8n Workflow: Auto-Schedule Social Posts from Google Sheets","description":"\u003ch3\u003eAuto-schedule multi-network social posts from your Google Sheets—every hour\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically reads your Google Sheets content calendar, finds posts marked as ready for the future, schedules them via \u003cstrong\u003eSocialRobot\u003c\/strong\u003e to multiple social platforms, and then marks each row as done so it won’t be processed again.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns hourly\u003c\/strong\u003e using a scheduled trigger to keep your publishing pipeline up to date.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads all rows\u003c\/strong\u003e from your Google Sheets content calendar.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters for the right posts\u003c\/strong\u003e by keeping only rows where the \u003cem\u003eready\u003c\/em\u003e field is set (e.g., \u003cstrong\u003eyes\/true\/ready\u003c\/strong\u003e) and the scheduled \u003cem\u003edate\u003c\/em\u003e is in the future.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedules the post\u003c\/strong\u003e through \u003cstrong\u003eSocialRobot\u003c\/strong\u003e to: \u003cstrong\u003eX (Twitter), Bluesky, Mastodon, Threads, and LinkedIn\u003c\/strong\u003e, using the row’s \u003cstrong\u003ecaption\u003c\/strong\u003e and \u003cstrong\u003edate\u003c\/strong\u003e fields.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates the Google Sheets rows\u003c\/strong\u003e by setting \u003cem\u003eready\u003c\/em\u003e to \u003cstrong\u003edone\u003c\/strong\u003e, preventing duplicate scheduling.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eMarketing teams maintain a centralized \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e editorial calendar and want automated scheduling across networks.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators manage frequent social posting while minimizing manual copy\/paste between platforms.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers want a reliable \u003cstrong\u003en8n automation workflow\u003c\/strong\u003e that uses clear “ready → done” state management in Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTrigger:\u003c\/strong\u003e Schedule Trigger (runs every hour)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData source:\u003c\/strong\u003e Google Sheets (OAuth2 credential)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow logic:\u003c\/strong\u003e Set, Code, Sticky Note (for mapping\/filtering and preparing fields)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSocial publishing:\u003c\/strong\u003e SocialRobot community node (\u003cstrong\u003esocialrobot-ion8n-nodes-socialrobotsocial robot\u003c\/strong\u003e) with a SocialRobot API credential and the correct SocialRobot account ID in each publish step\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequired sheet columns:\u003c\/strong\u003e \u003cstrong\u003edate\u003c\/strong\u003e (ISO datetime), \u003cstrong\u003ecaption\u003c\/strong\u003e, and \u003cstrong\u003eready\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eResult:\u003c\/strong\u003e scheduled posts go out on time across X (Twitter), Bluesky, Mastodon, Threads, and LinkedIn—while your Google Sheets stays clean and idempotent.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46058934075571,"sku":"N8N-19704","price":25.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/BnMxJ2GrZoTSQTj61aEno_qWu7ovni.png?v=1789722164","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-auto-schedule-social-posts-from-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}