Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.


  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse

Cloudron Forum

Apps | Demo | Docs | Install

Setting up an Automated Blog using n8n & Tiny Tiny RSS

Scheduled Pinned Locked Moved N8N
12 Posts 5 Posters 1.0k Views
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • murgeroM Offline
    murgeroM Offline
    murgero App Dev
    wrote on last edited by murgero
    #1

    In this little write up I'll be discussing how to setup n8n to post automatically to Wordpress using an aggregated RSS feed via tiny tiny rss. Optionally, you can have this also post to twitter, discord, facebook, etc as well (I have mine setup for Facebook so that's what I'll be discussing.)

    Firstly, you'll need Cloudron setup, plus:

    • Tiny Tiny RSS (This can be a new or currently active app!)
    • WordPress (Managed or Unmanaged doesn't matter, also this should be a new setup specific for this but it's not totally required.)
    • Of course, n8n app as well

    WordPress Setup

    This one is pretty simple.

    1. Login to WordPress and make sure to change the admin password (default is changeme)
    2. Install the following plugins:
      1. https://github.com/WP-API/Basic-Auth
      2. Jetpack
      3. (Optional) WP-Coder by Wow-Company
      4. (Optional) Header Footer Code Manager By 99robots
      • The optional bits make it easier to add AdSense or other ads to the blog site.
    3. Login to Jetpack, link the site to it if not already.
    4. (Optional) Setup Jetpack to auto share to any of your social medias.
      • This is done in Settings -> Sharing -> Configure Social Media
      • Make sure to "allow all admins and editors access to post" so your bot account can post.
    5. Create a new bot account (call it whatever, make the name human readable since people will see it). Give it a VERY complex password, at LEAST 24 - 32 Characters in length.

    Tiny Tiny RSS

    Install this as normal. Setup a few RSS feeds you would like automatically posted. Copy the secret link of the All Articles section. (Button is next to title in second column) Save this for later - it's needed for n8n.
    a619818e-9c3a-48b3-8f7b-128562757ba4-image.png

    n8n Setup

    Install n8n and login. Create a new Workflow - name it whatever you would like.

    1. Copy the following text from: https://gist.github.com/mitchellurgero/4d727b6821b21c8b0fe794b9bebf6cc5
    2. Click anywhere in the workflow, and press CTRL + V. You should now see something similar to:
      5e827598-59a2-4030-9aaa-bb424569a130-image.png
    3. Edit the RSS Feed Read to paste in that Secret Link from the Tiny Tiny RSS Setup.
    4. Edit WordPress and for Credentials Create New and fill in the data with the bot account and the full URL to your WordPress install.

    If all is done correctly, you now have setup n8n & WordPress as an Automated blog setup, maybe even with social integration. If you would like to see the end result, check out my own version of this here:

    • https://aggregation.urgero.org/
    • Facebook Group: https://www.facebook.com/TechNewsAggregation/

    And also, let me know if you have any issues, or if something needs more clarification - this was a quick write up so I may have missed something.

    Some may ask - if I am setup to post to facebook, why bother with WordPress. That is because the facebook posts link back to the wordpress site (which I have setup adsense on) for some tiny tiny bit of extra $$$ plus facebook is much easier to moderate comments on ⛏

    --
    https://urgero.org
    ~ Professional Nerd. Freelance Programmer. ~
    Matrix: @murgero:urgero.org

    timconsidineT scookeS girishG 3 Replies Last reply
    11
  • timconsidineT Offline
    timconsidineT Offline
    timconsidine App Dev
    replied to murgero on last edited by
    #2

    @murgero nice !

    1 Reply Last reply
    3
  • scookeS Online
    scookeS Online
    scooke
    replied to murgero on last edited by
    #3

    @murgero This is super handy.

    A life lived in fear is a life half-lived

    1 Reply Last reply
    2
  • girishG Do not disturb
    girishG Do not disturb
    girish Staff
    replied to murgero on last edited by
    #4

    @murgero awesome write up!

    1 Reply Last reply
    2
  • scookeS Online
    scookeS Online
    scooke
    wrote on last edited by scooke
    #5

    I've set it up, and it works well in terms of getting the content from the feeds and creating a new post in Wordpress. However, unlike yours, my Wordpress posts display no images, just a placeholder image (the gray square with the x). Is there an extra setting I need to tweak, or is that dependent on the source? Thanks again!

    A life lived in fear is a life half-lived

    timconsidineT 1 Reply Last reply
    1
  • timconsidineT Offline
    timconsidineT Offline
    timconsidine App Dev
    replied to scooke on last edited by
    #6

    @scooke in my twitter crossposter on n8n you have to load the image using an HTTP Read node

    scookeS 1 Reply Last reply
    0
  • scookeS Online
    scookeS Online
    scooke
    replied to timconsidine on last edited by
    #7

    @timconsidine I just edited my question to hone in on Wordpress as the place I'm hoping to get images shown. Do you think your comment for Twitter applies to Wordpress too? If so, what is the "HTTP Read node" and where in the workflow does it need to go? Thank you!

    A life lived in fear is a life half-lived

    timconsidineT 4 Replies Last reply
    0
  • timconsidineT Offline
    timconsidineT Offline
    timconsidine App Dev
    replied to scooke on last edited by
    #8

    @scooke I mis-typed on name of node : it is HTTP Request

    I inserted it after the IF.
    Screenshot follows.

    Basically you set it to take the image url and save it as binary data
    Then in the next step you can post the binary data.
    Although please note, I don't know what parameters the Wordpress node takes.

    1 Reply Last reply
    1
  • timconsidineT Offline
    timconsidineT Offline
    timconsidine App Dev
    replied to scooke on last edited by
    #9

    @scooke

    Screenshot 2021-09-26 at 23.08.15.png

    1 Reply Last reply
    2
  • timconsidineT Offline
    timconsidineT Offline
    timconsidine App Dev
    replied to scooke on last edited by
    #10

    @scooke
    Screenshot 2021-10-02 at 21.46.48.png

    1 Reply Last reply
    1
  • timconsidineT Offline
    timconsidineT Offline
    timconsidine App Dev
    replied to scooke on last edited by timconsidine
    #11

    @scooke I guess that in the Wordpress node you add an additional field for Content and link the expression for that to the output of the HTTP Request.
    But I am just guessing.

    1 Reply Last reply
    1
  • ajtatumA Offline
    ajtatumA Offline
    ajtatum
    wrote on last edited by
    #12

    I've built something similar for my site, but ended up just purchasing WP Webhooks and it made my life so much easier. It's definitely worth the $100 IMO.

    1 Reply Last reply
    0

  • Login

  • Don't have an account? Register

  • Login or register to search.
  • First post
    Last post
0
  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
  • Login

  • Don't have an account? Register

  • Login or register to search.