Schedule social media posts from Google Sheets to Twitter & Instagram

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. Posts the content: - As a tweet (text only) to Twitter (X). - As a post (image + caption) to Instagram via the Facebook Graph API. 5. Marks the row in Google Sheets as Posted with a timestamp.

It runs every 5 hours (configurable via the Schedule Trigger).

---

Requirements

- Google Sheets API Credentials connected in n8n. - HCTI.io account (HTML → Image API). - Twitter (X) OAuth1 credentials. - Facebook/Instagram Graph API access token (for the business account/page). - A Google Sheet with at least these columns: - RowID - Caption - Desc - Hashtags - Status

Set Status to Pending for any row you want posted.

---