{"product_id":"n8n-instagram-auto-publisher-google-sheets-gmail-alerts","title":"n8n Instagram Auto-Publisher: Google Sheets + Gmail Alerts","description":"\u003ch3\u003eAuto-publish Instagram posts from Google Sheets—complete with Gmail success \u0026amp; error alerts\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow watches your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e queue and automatically publishes the next \u003cstrong\u003ePending\u003c\/strong\u003e asset to \u003cstrong\u003eInstagram\u003c\/strong\u003e (Reels for MP4, image posts otherwise). It then updates the sheet and sends \u003cstrong\u003eGmail\u003c\/strong\u003e notifications for both success and errors.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns manually\u003c\/strong\u003e when you click \u003cem\u003eTest workflow\u003c\/em\u003e or \u003cstrong\u003eon a daily schedule around 4 PM\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads the first queued row\u003c\/strong\u003e in \u003cstrong\u003eSheet1\u003c\/strong\u003e where \u003cstrong\u003eStatus = Pending\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDetects asset type\u003c\/strong\u003e: if the queued file is an \u003cstrong\u003eMP4\u003c\/strong\u003e, it prepares a \u003cstrong\u003eReel\u003c\/strong\u003e; otherwise it prepares an \u003cstrong\u003eimage post\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates an Instagram media container\u003c\/strong\u003e via the \u003cstrong\u003eFacebook Graph API\u003c\/strong\u003e using your provided \u003cem\u003emedia URL\/filename\u003c\/em\u003e and \u003cem\u003ecaption\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePolls processing status\u003c\/strong\u003e via the Graph API and waits \u003cstrong\u003e15 seconds\u003c\/strong\u003e to retry while the container is \u003cstrong\u003eIN_PROGRESS\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePublishes on completion\u003c\/strong\u003e when the container status becomes \u003cstrong\u003eFINISHED\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates Google Sheets\u003c\/strong\u003e: marks the row as \u003cstrong\u003eCompleted\u003c\/strong\u003e after publishing, or \u003cstrong\u003eError Publishing\u003c\/strong\u003e if the container status is \u003cstrong\u003eERROR\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends Gmail alerts\u003c\/strong\u003e: success email includes the remaining pending count; errors trigger an error notification.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eMaintain a simple \u003cstrong\u003econtent queue\u003c\/strong\u003e in Google Sheets and push scheduled Instagram posts without manual upload.\u003c\/li\u003e\n  \u003cli\u003ePublish a mix of \u003cstrong\u003eMP4 Reels\u003c\/strong\u003e and image assets from one workflow, with reliable status handling.\u003c\/li\u003e\n  \u003cli\u003eGive your team instant \u003cstrong\u003eGmail notifications\u003c\/strong\u003e when posts succeed or fail.\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\/tools\u003c\/strong\u003e: if, code, wait, gmail, switch, aggregate\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\u003c\/strong\u003e: Google Sheets (OAuth2), Facebook Graph API (Instagram publishing), Gmail (OAuth2)\u003c\/li\u003e\n  \u003cli\u003eRequired setup: replace \u003cstrong\u003eYOUR_SPREADSHEET_ID\u003c\/strong\u003e, ensure \u003cstrong\u003eSheet1\u003c\/strong\u003e has at least \u003cstrong\u003eStatus\u003c\/strong\u003e and \u003cstrong\u003eFilename\u003c\/strong\u003e (optionally \u003cstrong\u003eUrl\u003c\/strong\u003e and \u003cstrong\u003eCaption\u003c\/strong\u003e), and provide \u003cstrong\u003eYOUR_INSTAGRAM_ACCOUNT_ID\u003c\/strong\u003e (or an \u003cem\u003einstagram_account_id\u003c\/em\u003e column).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46160852811955,"sku":"N8N-20402","price":3.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/PeNQXvvnoUCYc4qixbcQP_w0TCSMs4.png?v=1791191564","url":"https:\/\/buyflowscripts.com\/products\/n8n-instagram-auto-publisher-google-sheets-gmail-alerts","provider":"N8N Commerce","version":"1.0","type":"link"}