Back to Templates
Okay, here are the "How It Works" and "Setup Steps" for your "Automated Social Media Content Distribution System," presented clearly in Markdown.
This system transforms manual, repetitive tasks into a smooth, automated content distribution pipeline:
Content Submission & Trigger:
Content Preparation:
social_media_text_core
) that is suitable for posting across different social media platforms.Conditional Social Media Posting:
Check Facebook Post
, Check Twitter Post
, Check LinkedIn Post
) sequentially check your preferences (based on the Post_to_Facebook
, Post_to_Twitter
, Post_to_LinkedIn
columns in your sheet).TRUE
, the corresponding social media node (Facebook
, Twitter
, LinkedIn
) is activated to publish your content. If FALSE
, that platform is skipped, and the workflow moves to the next check.Status Update & Notification:
Publication_Status
column of your original row to "Published." This prevents re-posting and provides a clear record.Follow these detailed steps to build and implement this workflow in your n8n instance:
Prepare Your Google Sheet:
Title
, URL
, Short_Description
, Image_URL
, Hashtags
, Post_to_Facebook
, Post_to_Twitter
, Post_to_LinkedIn
, Publication_Status
TRUE
/FALSE
values for the posting flags.Gather Your API Keys & Credentials:
Build the n8n Workflow Manually (10 Nodes):
Google Sheets Trigger
Google Sheets Trigger
[Copy the ID from your Google Sheet's URL]
[Your Sheet Name, e.g., 'Sheet1' or 'Content']
Rows
Added
Set Content Parameters
.Set
Set Content Parameters
String
social_media_text_core
={{ $json.Title }} - {{ $json.Short_Description }}\nRead more: {{ $json.URL }}\n{{ $json.Hashtags }}
Check Facebook Post
.If
Check Facebook Post
={{ $json.Post_to_Facebook }}
is true
True
output to Post Facebook Message
. False
output to Check Twitter Post
.Post Facebook Message
[YOUR_FACEBOOK_PAGE_ID]
={{ $json.social_media_text_core }}
={{ $json.URL }}
={{ $json.Image_URL }}
Published
(checked)Check Twitter Post
.If
Check Twitter Post
={{ $json.Post_to_Twitter }}
is true
True
output to Create Tweet
. False
output to Check LinkedIn Post
.Create Tweet
={{ $json.social_media_text_core }}
={{ $json.Image_URL }}
Check LinkedIn Post
.If
Check LinkedIn Post
={{ $json.Post_to_LinkedIn }}
is true
True
output to Share LinkedIn Update
. False
output to Update Publication Status
.Share LinkedIn Update
Share Update
Organization
or Personal
(Choose as appropriate)[YOUR_LINKEDIN_ORG_ID]
(If Organization
type selected)={{ $json.social_media_text_core }}
={{ $json.URL }}
={{ $json.Image_URL }}
Update Publication Status
.Google Sheets
Update Publication Status
[YOUR_GOOGLE_SHEET_CONTENT_ID]
[Your Sheet Name, e.g., 'Sheet1' or 'Content']
Update Row
URL
={{ $json.URL }}
Publication_Status
Published
Share LinkedIn Update
and the False
branch of Check LinkedIn Post
.Slack
Send Slack Notification
[YOUR_SLACK_CHANNEL_ID]
New content "{{ $json.Title }}" successfully published to social media! 🎉 Check: {{ $json.URL }}
Update Publication Status
.Final Steps & Activation: