Quick overview

Every morning at 5:00 AM, this n8n workflow reads the day’s posts from one Google Sheet and publishes them to Facebook, Instagram, X, Pinterest, LinkedIn and YouTube. Each network has its own tab, a row goes out only when its date is today and its status is PENDING, and every posted row is marked POSTED, so the sheet always shows what went live.

How it works

1. At 5:00 AM the Schedule Trigger starts six branches at once, one per network.
2. Each branch reads its own tab of the content sheet and keeps the rows whose DATE is today and whose STATUS is PENDING.
3. An IF node checks the row before anything is posted: the date must be today in Asia/Dhaka time, and the caption and the image or video link must be filled in. Facebook takes images only.
4. Facebook and YouTube fetch the media first: Get FB Image downloads the image, and Get Video downloads the video.
5. The post goes out: Facebook through the Graph API (photos), Instagram through an Instagram node, YouTube as a video upload with the row’s title and caption, and X, Pinterest and LinkedIn through one posting API, Post for Me.
6. After a successful post, the Mark node writes POSTED into that row’s STATUS, with up to three retries.
7. A failed post leaves through its error output and does not stop the other networks, so one outage cannot cancel the day’s other posts.

Setup

1. Create a Google Sheet with one tab per network: Facebook, Instagram, X(Twitter), LinkedIn, Pinterest and YouTube.
2. Give each tab the columns DATE, CAPTION, IMAGE/VIDEO and STATUS. The YouTube tab also needs TITLE. Write dates as M/D/YYYY and set new rows to PENDING.
3. Connect the credentials: Google Sheets, a Facebook Page through the Graph API, an Instagram business account, a YouTube channel, and a Post for Me API key for X, Pinterest and LinkedIn.
4. Point every Content node and every Mark node at your sheet and the matching tab.
5. Set the posting time in the Schedule Trigger, then activate the workflow.

Requirements

• An n8n instance, cloud or self-hosted.
• A Google account for the content sheet.
• A Facebook Page, an Instagram business account and a YouTube channel.
• A Post for Me account and API key for X, Pinterest and LinkedIn.
• The community Instagram node (@mookielianhd/n8n-nodes-instagram) installed on the instance.

Customization

• Change the posting time in the Schedule Trigger.
• Remove a network by deleting its branch: Content, IF, Post and Mark.
• Write a different caption per network: each network reads its own tab.
• The IF node uses the Asia/Dhaka date; change the zone in that expression for another market.

Additional info

Every production build includes 14 days of free fixes after go-live. Tool subscriptions and hosting are paid by you to the provider.

The canvas above is a read-only copy of the live workflow: credentials, sheet ids, account ids and API keys are removed.