{"product_id":"n8n-workflow-postwire-auto-publish-shorts-from-google-sheets","title":"n8n Workflow: PostWire Auto-Publish Shorts from Google Sheets","description":"\u003ch3\u003eAuto-publish your Shorts from Google Sheets to TikTok, Instagram Reels, and YouTube—twice daily\u003c\/h3\u003e\n\u003cp\u003eWith this \u003cstrong\u003en8n workflow\u003c\/strong\u003e, you queue videos in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e and the automation automatically publishes the next “ready” Shorts item to \u003cstrong\u003eTikTok\u003c\/strong\u003e, \u003cstrong\u003eInstagram Reels\u003c\/strong\u003e, and \u003cstrong\u003eYouTube Shorts\u003c\/strong\u003e using the \u003cstrong\u003ePostWire API\u003c\/strong\u003e—then updates your sheet with links or “needs fix” details.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a schedule:\u003c\/strong\u003e executes at \u003cstrong\u003e10:00\u003c\/strong\u003e and \u003cstrong\u003e18:00\u003c\/strong\u003e every day.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads your publishing queue:\u003c\/strong\u003e scans your selected Google Sheet for rows where the \u003cem\u003estatus\u003c\/em\u003e column equals \u003cstrong\u003e“ready”\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePublishes one queued video per run:\u003c\/strong\u003e it takes \u003cstrong\u003eonly the first matching row\u003c\/strong\u003e, ensuring one automation action per time slot.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrepares the PostWire payload:\u003c\/strong\u003e normalizes the \u003cstrong\u003evideo_url\u003c\/strong\u003e, derives a \u003cstrong\u003eYouTube title\u003c\/strong\u003e when it’s missing, and parses the \u003cstrong\u003enetworks\u003c\/strong\u003e list to determine target platforms.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePublishes via PostWire with idempotency:\u003c\/strong\u003e sends the video, caption, title, and target platforms using an \u003cstrong\u003eidempotency key\u003c\/strong\u003e based on the sheet row and video URL.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrites results back to Google Sheets:\u003c\/strong\u003e updates the same row with posting links and a \u003cstrong\u003eposted\u003c\/strong\u003e\/\u003cstrong\u003epartly posted\u003c\/strong\u003e outcome when at least one platform succeeds; otherwise writes \u003cstrong\u003e“needs fix”\u003c\/strong\u003e with error details.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003ePublish Shorts in a predictable cadence without manual copy\/paste across TikTok, Reels, and YouTube.\u003c\/li\u003e\n  \u003cli\u003eUse a shared team queue in Google Sheets to coordinate what gets posted next.\u003c\/li\u003e\n  \u003cli\u003eAutomatically capture failures and route them to a “needs fix” workflow via detailed sheet notes.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes:\u003c\/strong\u003e if, set, limit, sticky note, \u003cstrong\u003eHTTP Request\u003c\/strong\u003e, \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePostWire API authentication:\u003c\/strong\u003e configure an HTTP Header Auth credential to send \u003ccode\u003eAuthorization: Bearer \u0026lt;your_PostWire_API_key\u0026gt;\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets requirements:\u003c\/strong\u003e columns include \u003cem\u003evideo_url, caption, title, networks, status, posted_at, links, note\u003c\/em\u003e, and a \u003cem\u003erow_number\u003c\/em\u003e field used to match\/update rows.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46132884897971,"sku":"N8N-20159","price":9.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/tuuiZTqDOWWUV2uMNGNd5_ApsOs8Jt.png?v=1790759825","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-postwire-auto-publish-shorts-from-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}