Notion to LinkedIn Daily Post
detail.loadingPreview
Automates daily LinkedIn posts by fetching content from a Notion database, formatting it, and publishing it.
About This Workflow
This workflow automates the process of sharing content from your Notion database to your LinkedIn profile on a daily basis. It's designed to run on a schedule, ensuring consistent engagement. The workflow fetches posts based on the current date, retrieves their content, formats it for readability, and then publishes it to LinkedIn with an associated image. Finally, it updates the post's status in Notion to 'Published'.
Key Features
- Scheduled Execution: Triggers automatically every day at a specified time.
- Notion Integration: Reads posts from a specific Notion database based on the current date.
- Content Fetching: Retrieves the full content of Notion pages, including text and images.
- Content Formatting: Processes Notion blocks into a readable text format suitable for social media.
- Image Handling: Downloads associated images for LinkedIn posts.
- LinkedIn Publishing: Posts the formatted content and image to your LinkedIn profile.
- Status Update: Marks the post as 'Published' in your Notion database.
How To Use
Workflow Setup Guide
1. Prerequisites
- n8n Account: You need an active n8n instance.
- Notion Account: A Notion account with a database containing your posts.
- LinkedIn Account: A LinkedIn profile or company page.
2. Credentials Setup
- Notion Credentials:
- Go to Credentials in n8n.
- Add a new Notion API credential.
- Follow the instructions to create an integration in Notion and obtain your API key. Make sure this integration has access to your target database.
- Select this credential in the
Filter the table for the day's post,Fetch the content on the page, andUpdate post status in notion databasenodes.
- LinkedIn Credentials:
- Go to Credentials in n8n.
- Add a new LinkedIn OAuth2 API credential.
- Follow the instructions to authorize n8n to post on your behalf. Important: To post on a company page, you must have a company page assigned to your personal profile. The credential setup will guide you through selecting whether to post on your personal profile or a company page.
- Select this credential in the
Publish on LinkedInnode.
3. Workflow Configuration
- Schedule Trigger (
Schedule Trigger):- Configure the
triggerAtHourto set the desired time for the workflow to run each day (e.g.,15for 3 PM).
- Configure the
- Notion Database Filtering (
Filter the table for the day's post):- Ensure the
databaseIdis set to your Notion post database ID. You can find this in the URL of your Notion database page (e.g.,f09dc21b-1070-4d5a-bf7f-a9ab3dbb69fb). - The
Date|datefilter is set to automatically match the current day (={{ $today.format("yyyy/mM/dd") }}). Make sure your Notion database has a 'Date' property configured in this format.
- Ensure the
- Notion Content Fetching (
Fetch the content on the page):- This node uses the URL of the fetched Notion page to retrieve its content. Ensure the connection is correct.
- Content Aggregation (
Aggregate the Notion blocks):- This node aggregates the
contentandimage.file.urlfrom the Notion blocks. Adjust thefieldToAggregateif your Notion structure differs.
- This node aggregates the
- Code Node (
Format the post):- This JavaScript code processes the Notion content (
items[0].json.content). It aims to format bullet points and regular text into a more readable string for LinkedIn. Review and adjust thejsCodeif your content structure requires different formatting logic.
- This JavaScript code processes the Notion content (
- HTTP Request Node (
Download image):- The
urlparameter={{ $json.url[0] }}is set to download the first image found in the aggregated Notion blocks. If your posts have multiple images or you want to select a specific one, you might need to adjust this.
- The
- Merge Node (
Merge):- This node merges the
formattedTextfrom theFormat the postnode and the downloaded image data from theDownload imagenode. This combined data is then passed to the LinkedIn node.
- This node merges the
- LinkedIn Publish Node (
Publish on LinkedIn):- The
textparameter={{ $json.formattedText }}pulls the formatted content from theMergenode. - The
personparameter likely refers to a LinkedIn person/entity ID. Ensure this is correctly set for your target profile or company page. shareMediaCategoryis set toIMAGE, expecting the downloaded image to be used.
- The
- Notion Update Node (
Update post status in notion database):- This node updates the status of the published post in Notion.
pageIdis dynamically set using the URL from theFilter the table for the day's postnode.propertiesUi.propertyValues.selectValueis set to 'Published'. Ensure your Notion database has a 'Status' property of type 'Select' and that 'Published' is a valid option.
4. Activation
- Once configured, ensure the workflow is toggled to Active to start automated daily posting.
Apps Used
Workflow JSON
{
"id": "5a57b3a7-9a12-451c-b83c-baf98d0fa266",
"name": "Notion to LinkedIn Daily Post",
"nodes": 19,
"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: 5a57b3a7-9a12...
About the Author
Free n8n Workflows Official
System Admin
The official repository for verified enterprise-grade 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.