Publish Instagram reels and posts from Google Sheets with Gmail alerts

Description

Quick overview This workflow runs manually or daily at 4 PM to pull the next pending item from Google Sheets and publish it to Instagram (Reels for MP4 videos or an image post) via the Facebook Graph API, then updates the sheet and sends Gmail success or error notifications. How it works Runs when you click “Test workflow” or on a daily schedule around 4 PM. Reads the first row in Google Sheets (Sheet1) where Status is Pending. Checks whether the queued asset is an MP4 to decide between publishing a Reel (video) or an image post. Creates an Instagram media container via the Facebook Graph API using the provided media URL/filename and caption. Polls the container status via the Facebook Graph API and waits 15 seconds to retry while processing is IN_PROGRESS. Publishes the media to Instagram when the container status is FINISHED. Updates the Google Sheets row to Completed and emails a Gmail success message including remaining pending count, or marks Error Publishing and sends an error email if the container status is ERROR. Setup Connect credentials for Google Sheets OAuth2, Facebook Graph API (with permissions to publish to your Instagram Business account), and Gmail OAuth2. Replace YOUR_SPREADSHEET_ID in all Google Sheets nodes and ensure Sheet1 has at least the columns Status and Filename (optionally Url and Caption) with rows queued as Status = Pending. Replace YOUR_INSTAGRAM_ACCOUNT_ID (or populate an instagram_account_id column) so the Facebook Graph API nodes target the correct Instagram Business Account. Ensure each queued item has a publicly reachable Url (video_url/image_url) or update the S3-style fallback URL pattern to match where your media files are hosted. Update the recipient address in both Gmail nodes (success and error) to your notification email. An n8n automation workflow template by Aryan Shinde.

Community Metrics

Categories

• Automation

Tags

• n8n
• workflow
• google-sheets
• facebook-graph-api
• gmail
• code

Capabilities

• 4 nodes

Information