Automated Social Media Content Generation and Distribution
detail.loadingPreview
Generate engaging social media posts from trending topics and distribute them across X, Facebook, and LinkedIn, with data logged in Google Sheets.
About This Workflow
This workflow automates the creation and distribution of social media content. It starts by identifying trending topics using Google Trends, then selects a relevant keyword for a blog post using an AI model. Perplexity AI is then used to generate a LinkedIn-ready post based on the chosen topic. Finally, the generated content is posted to X (Twitter), Facebook Graph API, and LinkedIn, with a record of the post, status, and timestamp logged in a Google Sheet.
Key Features
- Trending Topic Identification: Leverages Google Trends and SerpApi to find trending search queries.
- AI-Powered Topic Selection: Uses OpenAI to select the most relevant trending topic for a blog post.
- AI Content Generation: Utilizes Perplexity AI to craft professional and engaging social media posts adhering to specific platform guidelines.
- Multi-Platform Distribution: Posts content automatically to X (Twitter), Facebook, and LinkedIn.
- Automated Data Logging: Records post details (topic, status, AI output, date) in a Google Sheet for tracking.
How To Use
- Trigger: The workflow is triggered by a schedule (configured in
Schedule Trigger). - Find Trends: The
Google Trendsnode fetches trending search queries for a specified date range. - Select Top Trends:
2 Most Trendingformats the top two trending queries. - Filter Keywords:
High search volume keywords(Code node) filters keywords with a value greater than 30. - Choose Topic:
Choosing Topic(OpenAI node) selects the most relevant keyword for a blog post. - Research Post Content:
Research Topic- Perplexity(HTTP Request node) generates a LinkedIn post based on the chosen topic, following specific formatting and content rules. - Wait: A
Waitnode introduces a delay before distribution. - Split Content:
Split Outprepares the generated content for distribution to multiple platforms. - Distribute to Platforms:
X1(Twitter node) posts to X.Facebook Graph API1(Facebook Graph API node) posts to Facebook.LinkedIn1(LinkedIn node) posts to LinkedIn.
- Log to Sheets:
Google Sheets2appends the posted content, status, and timestamp to a Google Sheet.
Configuration:
- Replace
[CONFIGURE_YOUR_LINKEDIN_PERSON_ID],[CONFIGURE_YOUR_LINKEDIN_CREDENTIALS],[YOUR_GOOGLE_SHEETS_URL],[YOUR_GOOGLE_SHEETS_DOCUMENT_ID],[CONFIGURE_YOUR_GOOGLE_SHEETS_CREDENTIALS],[CONFIGURE_YOUR_PERPLEXITY_API_KEY],[YOUR_SERPAPI_KEY], and[CONFIGURE_YOUR_OPENAI_API_KEY]with your respective API keys and credentials. - Adjust the
COMPANY NAME + DESCRIPTION + PRODUCTS + TARGET MARKETandYOUR_COMPANYplaceholders in theChoosing Topicnode's prompt for accurate topic selection.
Apps Used
Workflow JSON
{
"id": "b753e4ba-e1b7-473c-942e-ecb7637672b5",
"name": "Automated Social Media Content Generation and Distribution",
"nodes": 8,
"category": "Marketing",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: b753e4ba-e1b7...
About the Author
Crypto_Watcher
Web3 Developer
Automated trading bots and blockchain monitoring workflows.
Statistics
Related Workflows
Discover more workflows you might like
Automated Multi-Platform Social Media Publisher
Streamline your social media content creation and publishing with this n8n workflow. Simply fill out a web form with your caption, media (image or video), and target platforms, and let n8n automate the posting process across multiple social networks.
WhatsApp AI Assistant: LLaMA 4 & Google Search for Real-Time Insights
Instantly deploy a smart AI assistant on WhatsApp, powered by Groq's lightning-fast LLaMA 4 model. This workflow enables real-time conversations, remembers context, and provides up-to-date answers by integrating live Google Search results.
AI-Powered On-Page SEO Audit & Report Automation
Instantly generate comprehensive on-page SEO technical and content audits for any website URL. This AI-powered workflow automates the entire process, from scraping the page to delivering a detailed report directly to your inbox, empowering you to optimize for better search rankings and user engagement.