Schedule social media posts from Google Sheets to Twitter & Instagram
Ready for 3.0What this workflow does
This workflow has 8 nodes and runs on a schedule (every day). Along the way it connects Google Sheets and Facebook Graph API. It also calls api.x.com and hcti.io over HTTP.
How it runs
Trigger: On a schedule (every day).
- Get row(s) in sheet (Google Sheets): uses Google Sheets
- Post on Twitter (HTTP Request): calls api.x.com (POST)
- Insta post caption (Edit Fields (Set)): sets 2 fields: final_caption, HTML
- HCTI Image (HTTP Request): calls hcti.io (POST)
- Create Insta post (Facebook Graph API): uses Facebook Graph API
- Post On Instagram (Facebook Graph API): uses Facebook Graph API
- Update Status Posted (Google Sheets): update
Services it uses
HTTP calls to: api.x.com, hcti.io
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 (5)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Facebook Graph API
n8n-nodes-base.facebookGraphApi
From the author
Social Media Auto-Poster (Google Sheets → Twitter & Instagram) This workflow automatically: 1. Pulls rows marked as Pending from a Google Sheet. 2. Generates a formatted Instagram caption and HTML preview. 3. Converts the HTML into an image via HCTI.io. 4.…