Make.com Automation: Automatically Adding WordPress Posts to Notion

Introduction

This automation uses Make.com to automatically collect posts published on a site WordPress and archive them in a Notion database. This process allows for centralized content management, making it easy to organize and analyze posts in one place.

Automation Pipeline

STEP 1: Initial Setup on Make.com

  1. Sign in to Make.com and go up Templates.
  2. Near “Add WordPress posts to Notion”.
  3. Select the template and start configuring the pipeline.

STEP 2: Connecting with WordPress

Installing the Plugin

  1. Download the plugin WordPress Make.
  2. Log in to your WordPress (portfolio.paoloronco.it).
  3. Go to Plugins > Add New > Upload Plugin.
  4. Install and activate the plugin.
  5. Go to Plugins > Make and copy the API Key.
  6. Paste the API Key into Make.com to complete the connection.

Setup on Make.com

  • Select Type: Post.
  • Select Status: All.
  • Select Limit: 150.
  • Right click on WordPress (watch posts) → Choose where to start → All.

STEP 3: Creating a Database on Notion

Notion Setup

  1. Sign in to Notion and go up Settings > Connections.
  2. Create a new internal integration.
  3. Create a new page and add a Database.
  4. Set the following columns in the database:
    • Date
    • Title
    • Author
    • Link
  5. Associate the created connection with the page.
  6. Recover thePage ID:
    • Copy the Notion page URL, e.g.: https://www.notion.so/paoloronco/DATABASE-IDv=altro(which is not needed).
    • Get all the value before ?v= and use it as Database ID on Make.com.

Setup on Make.com

  • Enter the Database ID copied.
  • Map the fields:
    • Title → {{1.yoast_head_json.title}}
    • Link → Link
    • Date → Date
    • Author → {{1.yoast_head_json.schema.@graph[].author.name}}

STEP 4: Filtering to Avoid Length Errors

  • Between Notion Create Database Item And Notion Append Page Content, set a filter with max operators: 10000.
  • This will avoid article length errors.

STEP 5: Append Content to Notion

  • Page ID: Please enter the correct value.
  • Type: Paragraph.
  • Leave everything else at its default settings.

Results and Possible Extensions

  • The system import automatically new WordPress posts to Notion without manual intervention.
  • Potential extensions:
    • Add more metadata (categories, tags, images).
    • Automate sharing of posts on other platforms.
    • Create an integration with Google Sheets for backup or analysis.

This automation demonstrates how Make.com can simplify content management and optimize workflows 🚀.