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


    Cloudron Forum

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular

    Setting up an Automated Blog using n8n & Tiny Tiny RSS

    N8N
    5
    12
    817
    Loading More Posts
    • 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.
    • murgero
      murgero App Dev last edited by murgero

      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

      timconsidine scooke girish 3 Replies Last reply Reply Quote 11
      • timconsidine
        timconsidine App Dev @murgero last edited by

        @murgero nice !

        1 Reply Last reply Reply Quote 3
        • scooke
          scooke @murgero last edited by

          @murgero This is super handy.

          A life lived in fear is a life half-lived

          1 Reply Last reply Reply Quote 2
          • girish
            girish Staff @murgero last edited by

            @murgero awesome write up!

            1 Reply Last reply Reply Quote 2
            • scooke
              scooke last edited by scooke

              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

              timconsidine 1 Reply Last reply Reply Quote 1
              • timconsidine
                timconsidine App Dev @scooke last edited by

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

                scooke 1 Reply Last reply Reply Quote 0
                • scooke
                  scooke @timconsidine last edited by

                  @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

                  timconsidine 4 Replies Last reply Reply Quote 0
                  • timconsidine
                    timconsidine App Dev @scooke last edited by

                    @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 Reply Quote 1
                    • timconsidine
                      timconsidine App Dev @scooke last edited by

                      @scooke

                      Screenshot 2021-09-26 at 23.08.15.png

                      1 Reply Last reply Reply Quote 2
                      • timconsidine
                        timconsidine App Dev @scooke last edited by

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

                        1 Reply Last reply Reply Quote 1
                        • timconsidine
                          timconsidine App Dev @scooke last edited by timconsidine

                          @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 Reply Quote 1
                          • ajtatum
                            ajtatum last edited by

                            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 Reply Quote 0
                            • First post
                              Last post
                            Powered by NodeBB