It is no secret that saved Reddit posts are difficult to navigate, organize, and keep at hand for when you need to revisit them.
Curiously enough, saving posts on Reddit is incredibly simple, which comes at odds with how they are stored: to see and manage your saved posts, all you get is a scrollable list.
The first problem with this is quite straightforward: as your list of saved posts builds up, it becomes increasingly difficult to access what you have saved.
In other words, the more posts you save, the higher the chance they get buried somewhere down your list.
But there’s more to it.
With the current setup for saved posts, there is no way to know:
- How many posts you have saved
- When did you save each post
What’s worse, it’s impossible to organize them for easier accessibility; for example, by subreddit, or by poster username.
To conclude, there is one final issue: the limit of posts you can save.
As of today, the list of saved Reddit posts is capped at 1,000 entries. You might think this is flexible enough, but wouldn’t it be better if you could just expand your list without limits?
Well, in this post we will be sharing a solution to tackle all of these problems at once by automatically importing Reddit data into a Google Sheets spreadsheet.
For all the good that Reddit has brought us in terms of content quality and diversity, the saved posts feature stands out as one of the app’s weaknesses, and we are here to help you overcome it.
How to manage your saved Reddit posts
The solution we created to manage saved Reddit posts works in a simple way: it monitors your list of saved posts, and sends new saved posts to a Google Sheets spreadsheet.
Most importantly, it does so automatically, and you can choose what data to send to the spreadsheet, including:
- Title of the post
In total, there are 19 different data values you can extract from your list of saved posts and ship to a spreadsheet.
Before we proceed to learning how to create this, please make sure you have the following:
- An Integromat account
- A Google account
And of course, a Reddit account.
Bear in mind, you can create the following scenario with a free Integromat account (and unless you save Reddit posts by the hundreds each month, it can stay that way).
Step 1: Get your private Reddit RSS feed for saved links
A little-known fact about Reddit is the existence of private RSS feeds to funnel information.
Among the many private RSS feeds that are available, we will use the one to access our saved links.
To find it, you will need to go to reddit.com/prefs/feeds/ and click on the corresponding RSS button (not the JSON one):
Once you do this, you will be redirected to a page containing the RSS feed with your saved posts.
Don’t mind the contents of this page, as all you will need from it is the URL of the page.
Before we move on to the next step, remember to keep the tab open, or else copy the URL to your clipboard for future reference.
Step 2: Creating the Integromat scenario
Now that you have an Integromat account, it’s time to put it to good use.
From your personal dashboard, you will begin by creating a new scenario from scratch:
The first thing you’ll need to do here is pick the app module that will trigger your scenario: the RSS app.
Note: app modules define the way an app responds to a request. For more information about basic Integromat terms, please refer to this page.
After searching for the app, select it and click “Continue” on the upper right side of your screen. This will land you on the scenario builder (aka visual canvas) which is what you will use to create Integromat automations - including this one.
In there, you will see that the RSS app has been pre-loaded as your first option. Click on it, and select the “Watch RSS feed items” module from your options.
Once you do that, it’s time to configure the module.
Step 3: Configuring the RSS module
In order to pick up your Reddit saved posts, you will need to configure the module by entering the following information:
- The RSS page URL link (please, see Step 1 if you missed this part)
- The number of posts you want the scenario to return (if you save a lot of posts, enter a high number here)
- Your Reddit username
- Your Reddit account password
If you don’t see the last two fields (username and password), please activate the “show advanced settings” option within the module.
We are aware that the last two items are sensitive data, but there is nothing to worry about.
Integromat doesn’t store personal information, and as an European company it is subject to GDPR data protection laws.
Now that you configured the RSS module, it’s time to move to the following step.
Step 4: Creating the spreadsheet for our Reddit saved posts
Before you add a second module to your scenario, you will have to create a Google Sheet spreadsheet on Google Drive.
It’s fairly simple: just create a new spreadsheet, name it, and add the column headers to organize your saved posts.
For example, our spreadsheet features the following headers:
- Post title
- Post author
And looks like this:
These are the data points we will be funneling from Reddit and into our spreadsheet.
There’s no need to say that you can pick others, or change the arrangement to fit your taste and needs.
After you create the spreadsheet and name the corresponding columns, you will have to select the second (and last) module of your scenario.
To do so please click the “Add another module” button on the right side of the RSS module.
Now that we have all the elements in place, it’s time to configure the Google Sheets module.
Note: once you open the Google Sheets module for configuration, please activate the “Show advanced settings” option.
Step 5: Configuring the Google Sheets module
The first thing you do after you add the Google Sheets module is activate the “Show advanced settings option” at the bottom of the panel.
After you do that, the configuration steps that follow here are fairly simple:
- Connect your Google account to Integromat (by clicking the “Add” button)
- In “Mode”, choose the “Select spreadsheet and sheet” option
- In “Spreadsheet”, select the spreadsheet you created to organize your saved Reddit posts (if you gave it a name, it will show within the list of options)
- In “Sheet”, select the sheet that contains the spreadsheet for the saved posts
Since the spreadsheet you created contains headers, switch the default option of the field from “No” to “Yes”.
Now, if you keep scrolling down the configuration options, you will see two important fields:
- Column range
The spreadsheet we created features four columns (Post title, URL, Date, Post author), so we’ll set the column range to “AD-Z”.
This will allow the scenario to fill in the respective columns with the corresponding information for each of the posts you save on Reddit.
In the “Values fields”, we will select the data points we want from our list of saved posts, which correspond to the header values as well:
- Date created
To conclude, you will need to scroll down all the way to the bottom of the configuration module and do the following:
- Set the “Value input” field to “Raw”
- Set the “Insert data option” field to “Insert rows”
Note: do not forget to configure these, as they are vital for the automation to work!
Step 6: Configure the scenario scheduling
This is the last step, which will let you configure the frequency of your scenario runs. To do so, you have to click on the clock icon that lies on the lower left side of the RSS module.
Note: you can schedule the scenario right after configuring the first module (RSS); if you did it then, feel free to skip this section.
In this example, we set our scenario to run three times a day, every 480 minutes to be precise.
This means that every eight hours, the scenario will watch our saved Reddit posts, pick up whatever we have saved within that time frame, and send the data to the Google spreadsheet.
You can of course change these settings at will, according to your needs.
Before you leave the scenario builder, please remember to:
- Save the scenario
- Turn it on
And that’s it! Now, all your saved Reddit posts can be funneled into a manageable, data-rich spreadsheet.
This is what our spreadsheet looks like after running for a couple of days of having this automation running in the background:
Spectacular? Barely 😆, but nothing beats a good ‘ole spreadsheet when it comes to organizing data.
As you can see, there is a better way to organize your saved Reddit posts, and it can be achieved in less than an hour with a simple Integromat scenario.
This is useful for individuals who want to improve their list of saved posts without going premium on Reddit, and also for companies that wish to follow-up closely on posts that mention their brand.
Whatever the case, it’s all about turning valuable information into something accessible and navigable - and that’s where the true value of this automation resides.
Now, are you ready to get that clunky list behind you?
Then sign up to Integromat, and give your saved posts a better chance at everything.