Notion to LinkedIn Daily Post

• 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.

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, and Update post status in notion database nodes.
• 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 LinkedIn node.

3. Workflow Configuration

• Schedule Trigger (Schedule Trigger):
  • Configure the triggerAtHour to set the desired time for the workflow to run each day (e.g., 15 for 3 PM).
• Notion Database Filtering (Filter the table for the day's post):
  • Ensure the databaseId is 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|date filter 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.
• 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 content and image.file.url from the Notion blocks. Adjust the fieldToAggregate if your Notion structure differs.
• 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 the jsCode if your content structure requires different formatting logic.
• HTTP Request Node (Download image):
  • The url parameter ={{ $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.
• Merge Node (Merge):
  • This node merges the formattedText from the Format the post node and the downloaded image data from the Download image node. This combined data is then passed to the LinkedIn node.
• LinkedIn Publish Node (Publish on LinkedIn):
  • The text parameter ={{ $json.formattedText }} pulls the formatted content from the Merge node.
  • The person parameter likely refers to a LinkedIn person/entity ID. Ensure this is correctly set for your target profile or company page.
  • shareMediaCategory is set to IMAGE, expecting the downloaded image to be used.
• Notion Update Node (Update post status in notion database):
  • This node updates the status of the published post in Notion.
  • pageId is dynamically set using the URL from the Filter the table for the day's post node.
  • propertiesUi.propertyValues.selectValue is 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.