Schedule and auto-post images to Instagram with Google Sheets, Drive and AI captions

Description This n8n workflow automatically publishes posts to Instagram Business accounts and Facebook Pages using Google Sheets as your content calendar. You schedule posts in the sheet, and n8n processes them, uploads media (if any), posts via Meta’s Graph API, and updates the sheet with success/failure. n8n

How it Works Google Sheets rows marked “Pending” and due for publishing are picked up by a scheduled trigger. Posts are then routed to the proper social platforms and published via Meta’s Graph API. Finally, n8n writes back the publish status and timestamp to the sheet. n8n

🧠 Step-by-Step 1️⃣ Scheduled Trigger

The workflow automatically checks Google Sheets at fixed intervals (e.g., every 15 min) for posts that are ready (status = Pending, publish time reached).

2️⃣ Config & Credentials Store reusable settings including:

- Google Sheets ID & Sheet name - Meta App credentials (App ID, App Secret) - Access token for Meta Graph API - Instagram Business Account ID - Facebook Page ID

These configs make the workflow modular and secure.

3️⃣ Setup: Create a Meta (Facebook) App To post via the Graph API, you must first set up a Meta developer app: