Create An Auto-Updating, Searchable List Of Your Posts (IFC S2R12)
In only 5 minutes, you can now create an auto-updating, searchable list of your posts, which will make future reference a lot easier. No more need to waste hours looking for that previous post you want to link to...
![Create a searchable list of your posts](https://steemitimages.com/640x0/https://mysteemworld.com/wp-content/uploads/2019/06/find-your-old-posts-1024x683.jpg)
Source
Intro
I've had the idea to write this post for weeks.. even months, maybe. When I saw @cicisaja mention in one of her posts that it had taken her hours to find one of her older posts she wanted to refer to, it struck me that I had found a solution to that more than a year ago. All my posts are automatically added to a Google spreadsheet, which allows me to find the one I need in seconds.Initially, there were a lot of workarounds needed, so it would have been a hell of a job to explain it. But about 2 months ago, a new SteemIt service was created, which makes it a lot easier to set up the automated system. All it will take is 5 minutes of your time to set it up.
However, just when I wanted to start writing this tutorial, the service went down for a week. Fortunately, it is back up and seems to be here to stay.
It could use our help, though. This service is so incredibly valuable that we simply can't lose it. Please consider using one of the donation buttons on the site to help the developers to keep the website online.
![divider](https://steemitimages.com/640x0/https://mysteemworld.com/wp-content/uploads/2018/10/dividerlines.png)
RSS Feed URL
Some of you have been around long enough to remember Streemian. I forgot what they were about, but I do know one of their services was providing an RSS feed URL for your SteemIt blog.
In case you don't know what an RSS feed URL is:
![RSS icon](https://steemitimages.com/640x0/https://mysteemworld.com/wp-content/uploads/2019/06/rss-icon-small.png)
RSS stands for 'really simple syndication', or is also used for “rich site summary”. It is basically a sort of text file that is automatically updated with stripped-down content (for faster loading) whenever you make a new blog post.
It's one of the most powerful tools a blog can have.
Last year, I published two posts from my old account in which I wrote about the importance and the possibilities of an RSS feed URL.
Your SteemIt RSS Feed URL Is A Goldmine! Use It!!
Profit From Your SteemIt RSS Feed URL, Even When Streemian Is Down
I hope Cheetah will forgive me for quoting my own old posts, but I'll do it anyway...
On this platform you earn money when people upvote your posts or comments. This means that you need to get the word out about your posts and get as much exposure as you can get. There are many ways to drive traffic to your SteemIt posts, but only few are as powerful as your RSS feed URL.An RSS feed has a very wide range of possible uses, and all are based on the most valuable power there is online: AUTOMATION.
Just to give you some examples: with your RSS feed URL you can send out newsletters or push notifications on complete autopilot, you can add self-updating widgets or pages to your website, you can even build a completely automated website that updates itself whenever you make a new post here on SteemIt.
Also, you can submit your RSS feed to RSS feed directories and use it to create backlinks, which both improve your Google ranking.
All these features can help you to generate more traffic to your posts. And by getting more views, you increase the chance that people will start following you. And when you have more followers, you usually get more upvotes. And more upvotes... you get the picture, right?
The number one use of an RSS feed, is also the most effective one: in combination with a tool like IFTTT or Zapier you can have your message added to more sites than you can imagine... without having to lift a finger. With your RSS feed, you can not only automate a big part of your administration, you can also set up all your social media post promotion campaigns to work on complete autopilot.
It's actually very simple: if you want to get the word out about your SteemIt blog, there's no way around; you simply NEED your RSS feed URL.
Both posts also included a step-by-step tutorial on the workaround to get the RSS feed for your SteemIt blog after Streemian had shut down, but there's no use for that anymore. Things have become way more simple...
![divider](https://steemitimages.com/640x0/https://mysteemworld.com/wp-content/uploads/2018/10/dividerlines.png)
RSSteem
Streemian went down more than a year ago. I still don't get why another RSS feed URL wasn't provided instantly, considering the impact it could have had. Millions of links to SteemIt posts could have been spread around the web during that time, but apparently getting the word out wasn't a priority.
Fortunately, there were people who were aware of the need to provide users with an RSS feed URL for their blog. About 2 months ago, @bambukah created the RSSteem-website.
It didn't really launch with a bang - and if it did, I missed it. I accidentally stumbled upon it while I was browsing SteemProjects.
I was so happy to see that RSSteem not only provided users with a straightforward way to create the RSS feed URL for their own blog, but also offered the option to create shareable RSS feed URL's for a user's feed and comments, and even for a specific tag or category.
![rssteem](https://steemitimages.com/640x0/https://mysteemworld.com/wp-content/uploads/2019/06/rssteem.jpg)
Source
This tool unlocks so many new possibilities... I could probably spend weeks writing posts about what you can do with these links.
But today, I'll just stick to just one.
@bambukah, I can't thank you enough for creating this site. I've sent you a small contribution, and I hope others will do the same once they realize what an important step the development of RSSteem was.
![divider](https://steemitimages.com/640x0/https://mysteemworld.com/wp-content/uploads/2018/10/dividerlines.png)
Creating A Searchable List Of Your Posts
But let's get back to the initial topic of this post. I promised to show you how you can use your RSS feed URL to create an auto-updating, searchable list of the posts you publish, so you can always find the one you need in just a couple of seconds.
The system takes less than 5 minutes to set up, so I don't see a reason not to. You never know when it will come in handy. I find it hard to imagine that you have never felt the need to find one of your old posts for some reason.
The steps included are:
- Creating your RSS feed URL
- Setting up the automation rule
- Checking the results
Basically, you'll set up a system that will add your SteemIt blog title, description, link and date to a Google Spreadsheet on autopilot whenever you publish a new post. In the future, if you need the link to one of your previous posts, you can simply use the 'search' feature in Google spreadsheets to find it.
Don't worry, thanks to RSSteem this process has become a lot easier than before. So easy, that everyone can do it.
And believe me when I say it often comes in handy to not have to waste a lot of time to find the post you want to refer to.
Let's get to it!
What You Need:
- A Google account to access Google Spreadsheets (available on the web, for Android and IOS)
- A free IFTTT account (available on the web, for Android and IOS)
![dividersmall](https://steemitimages.com/640x0/https://mysteemworld.com/wp-content/uploads/2018/10/dividersmall.png)
Let's Get Started
(You'll find a video tutorial at the bottom of this post.)
First, you need to create the RSS feed URL for your SteemIt blog.
A. Generating Your RSS Feed URL
Go to the RSSteem website. You'll land on the 'Account Posts' page. Type your SteemIt username (without @) in the field and click the 'Generate Link'-button.
![create RSS feed URL with RSSteem.org](https://steemitimages.com/640x0/https://mysteemworld.com/wp-content/uploads/2019/06/create-RSS-feed-URL.jpg)
Click To Enlarge
A popup will appear, showing you your RSS feed URL. Copy the URL and save it to a Notepad file.
When you click the 'Display Content' button, you'll notice you'll be redirected to a page with basic code. At the top, it says 'This XML file does not appear to have any style information associated with it.'
Don't worry about this. IFTTT knows how to turn this into readable content.
B. Setting Up The Automation
If you don't have a free IFTTT account yet, go ahead and create one. To do so, click the 'Sign Up'-button on the IFTTT homepage and follow the instructions. Be sure to sign up using your Google account!
Log into your IFTTT account and click the this link to be redirected to the applet I've set up for you.
You'll be redirected to the applet page.
First thing you need to do is turn on the applet by clicking 'Turn On'.
Once turned on, you can personalize the applet.
In the field at the top, paste the link RSSteem created for you.
At the bottom, enter a name for the spreadsheet you want to add your SteemIt posts to. This can be an existing one, but I recommend creating a new one. All you need to do is enter the name of your choice, and IFTTT will automatically create the Google spreadsheet for you.
Click 'Save'.
That's it! You're all set up!
![divider](https://steemitimages.com/640x0/https://mysteemworld.com/wp-content/uploads/2018/10/dividerlines.png)
Your Searchable List
Whenever you publish a new post, its title, link and description will be added to a Google spreadsheet, together with the date.
You can access that spreadsheet any time you want by logging into Google with the account you used to set up this system, and then visit Google Sheets. On the landing page, click the button 'Go To Google Spreadsheets' and you'll be redirected to a page where you can see all the spreadsheets you've created.
Open the one you are using with IFTTT, and you will see a list of all the posts you've published since you set up this system.
Remember, this means there won't be a spreadsheet when you've just set up the applet. You'll need to create a post on SteemIt first. In other words, this won't work for the posts you've published in the past, only for the ones you will publish in the future.
To find the post you're looking for, click 'Edit' and select 'Find and Replace'.
![find and replace](https://steemitimages.com/640x0/https://mysteemworld.com/wp-content/uploads/2019/06/find-and-replace.jpg)
Click To Enlarge
In the popup window, type your keyword in the field and click the 'Find' button.
![add search term](https://steemitimages.com/640x0/https://mysteemworld.com/wp-content/uploads/2019/06/add-search-term.jpg)
Click To Enlarge
The first cell that contains the search term will be highlighted. Click the 'Find'-button again to find the next cell that has the keyword in it. Repeat this until you've found the post you are looking for.
They really don't come any easier than that. Now you'll never have to waste time anymore searching for that previous post you want to link to.
Here's a quick video rundown:
Forgive me for the quality, I'm not such a talented video creator :0)
Your Rss Feed URL Is A Goldmine
This is just one example of how you can use your RSS feed URL to make life a little easier.
The truth is... Having access to your RSS feed URL provides you with hundreds of opportunities. Having access to a tag or category RSS feed URL is simply priceless.
Automate your social media accounts, generate extra traffic to your SteemIt blog, build auto-updating (niche) websites, set up a newsletter, generate automated backups for your posts, receive notifications of posts in your mailbox or feed reader... the sky is really the limit here.
So it's safe to say this post was only the tip of the iceberg. There is so much more you can do when you have access to RSS feed URLs like we do now.
SteemIt Inc. was wrong when they didn't offer one themselves for an entire year. If they would have, things might have been way different right now.
I'll be showing you more ways to use this magic tool soon, so stay tuned!!
![see ya later](https://steemitimages.com/0x0/https://mysteemworld.com/wp-content/uploads/2019/06/see-ya-later.gif)
Source
![Power House Creatives Logos FINAL_float.png](https://steemitimages.com/350x250/https://cdn.steemitimages.com/DQmd3ZgczWd8wzLLhwBJ9WkGqf46kfizUHL9qq5zV4Z56gZ/Power%20House%20Creatives%20Logos%20FINAL_float.png)
![JOIN THE DISCORD](https://steemitimages.com/640x0/https://i.imgur.com/87RsVYb.png)
Stopping by @simplymike, due to the resteem of @abh12345. Great post with very useful content. Thank you kindly for all of the effort I know went into producing it!
Resteemed for reference to my readers who may choose to investigate and put this great idea to work for their accounts ...
Thanks, @roleerob
10 out of 10 for effort in sorting this out and producing a guide.
Such a shame it doesn't work retrospectively, but I'm willing to gather a list of old posts if people ask.
Thanks!
It's indeed a shame you can only use it for posts you make from the time you set it up.
Unless you know how to pull things from the database or the blockchain, of course, like you do.
Personally, I think it was a big mistake not to provide people with an RSS feed straight after Streemian had shut down. I mean, during that year, millions of backlinks to Steemt could have been created - posts could have been shared on dozens of platforms - I don't get why they didn't care.
I have been using it all along, but going through the steps of creating your own RSS feed URL was too much of a hassle to start to explain. That's why I was so happy I found out about RSSteem. i only hope they will keep the site up.
As far as I understand this, it works for future posts (which is great also). Any way to make it populate the spreadsheet with already published posts?
Thanks for the tutorial. Resteemed.
Thanks for the resteem.
It indeed works only for posts you make after you've set it up.
To get a list of posts you published in the past, you need to have access to the SteemIt database. Which is possible, but it isn't free.
@paulag, do you perhaps know about an easy and free way for any user to get a list of the posts he published in the past?
I think you will need to query the blockchain itself to get this info for free. Or you can ask me for a list :)
Thanks, but paulag sent me one only a couple of weeks ago. It came in useful, because my IFTTT applet had been inactive for a while, (and I had missed their notification), so my spreadsheet hadn't been updating for all that time. I set it back up right after she had sent me the list, so I got links to every single post 😉
Actually, if you're logged into your Steem account, you can simply scroll down through your posts and grab the links.
Time consuming, if you're like me and have hundreds of posts, but doable (I did), and free.
And, obviously, you can do the same with comments and/or replies, as desired.
Posted using Partiko Android
I set up this system not long after I started here, so fortunately, I don't have to search.
You can also use the 'Search' feature. If your post or comment contained some uncommon words, it shouldn't be very hard to find them
As I said, I found all of my old posts by simply scrolling through them, though admittedly it took a while.
But automating the addition of new posts is fabulous. Thanks again.
Posted using Partiko Android
👍
Really good question, mate!
I appreciate your offer, @abh12345! Could I pay your service with $ENGAGE, to have my list to populate my spreadsheet? ;)
Awesomeness!! I was using StackEdit.io for that reason. Granted it's great to have everything in one place, but formatting was a bit different. You would spend time tweaking things to make the post look nice, then paste it into Steemit and it would be off. Then more time in Steemit to retweak the post. Just too much time.
Thanks @simplymike for this tutorial. A great way to catalogue posts.
You're welcome 😉
very cool tutorial probably your best one yet, I can really see the value in having an RSS feed for your steemit blog.
Thanks. It has taken me a while to get it write. 2 months to get from the idea to finally be able to publish the post :0)
I was just thinking it would make a for a cool feature to have on sites like the Twitter or Instagram feeds people often embed on their sites. You could embed your account or tag or community posts as a feed, could come in handy and be a great way to promote content
Exactly. You could even use a tag feed and build an entire website that updates on autopilot with posts on the same topic.
It would be useful to have images attached to the feed for that, though - but that's not impossible.
I'm still using the RSS feed I created 'the old way'- before RSSteem was available (you can find instructions on how to do that using FetchRSS by clicking the links at the top of this post). By running them through Feedburner, my RSS feed looks like this: http://feeds.feedburner.com/SimplymikeOnSteemIt
Incredible work, and fantastic guide. This is supremely useful, and needs more visibility. Resteemed.
Thanks a lot!
Great tip and walkthrough. This should be very useful.
Proud member of #powerhousecreatives
Thanks
Hi, @simplymike!
You just got a 18.47% upvote from SteemPlus!
To get higher upvotes, earn more SteemPlus Points (SPP). On your Steemit wallet, check your SPP balance and click on "How to earn SPP?" to find out all the ways to earn.
If you're not using SteemPlus yet, please check our last posts in here to see the many ways in which SteemPlus can improve your Steem experience on Steemit and Busy.
Seems Pretty straightforward thanks for putting the time into documenting how to do this I don't have the time to do it tonight but I have bookmarked it to do on the weekend
It shouldn't take u a lot of time 👍
NO it looks fairly quick and thanks for the reply, I had forgotten but have made a note to do it tomorrow
👍