Schedule and auto-post images to Instagram with Google Sheets, Drive and AI captions
Ready for 3.0What this workflow does
This AI workflow has 19 nodes and runs on a schedule (every hour). Along the way it connects Google Sheets, Google Drive, Facebook Graph API and OpenAI Chat Model.
How it runs
Trigger: On a schedule (every hour).
- Workflow Configuration (Edit Fields (Set)): sets 2 fields: googleDriveFolderId, googleSheetId
- Get Next Scheduled Post (Google Sheets): uses Google Sheets
- Check If Post Found (If): checks a condition and branches into true / false
- Get Access Token from Facebook (HTTP Request): calls an HTTP API
- No More Posts (Code): runs custom JavaScript code
- Search files and folders (Google Drive): work with file folder
- Download Image from Drive (Google Drive): download
- Upload Image to Facebook (HTTP Request): calls an HTTP API (POST)
- Get Public URL From Facebook (HTTP Request): calls an HTTP API
- Prepare AI Context (Edit Fields (Set)): sets 2 fields: image_public_url, image_facebook_id
…plus 7 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (11)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Google Drive
n8n-nodes-base.googleDrive - AI Agent
@n8n/n8n-nodes-langchain.agent - Facebook Graph API
n8n-nodes-base.facebookGraphApi - Code
n8n-nodes-base.code - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Wait
n8n-nodes-base.wait - HTTP Request
n8n-nodes-base.httpRequest
From the author
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…