Public: Getting Post Titles and URLs from Subreddits | Taylor Tomita
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEF
1
Grabbing Post Titles and URLs from Subreddits
TaylorTomita.com
2
3
How to UseSubreddit URLPost URLPost Title
4
Disclaimer: This tool is not great, lol

1. Copy/Paste the desired Subreddit URL into the "Subreddit URL" field.
You can also use Reddit's filtering options in you are looking to pull specific sections of the Subreddit (/new, /rising, /controversial, /top)!

______________________________

2. Add the Subreddit Text (Name) to the "Subreddit Text" field. Be sure to add an apostrophe ( ' ) to the end of the Subreddit Text that you've entered. I know, that sounds dumb, but I couldn't get it to work otherwise.
For example: If you were looking at /r/AskReddit - you would input: AskReddit'

IMPORTANT: This field is case sensitive, so if the Subreddit uses upper case in their URL (/r/AskReddit does) - be sure to use the exact formatting.

______________________________

3. Once you input both of these fields, the Sheet should automatically start pulling the Post URLs and Titles from the Page you entered. As of right now, this only works for one page at a time, so if you wanted to pull the post details for page 2 you will need to navigate to the second page of the subreddit and input that specific page 2 URL into the Subreddit URL field.

Note: Depending on the Subreddit's setup, this may end up pulling in Reddit posts/internal links from the Sidebar, however this will not typically be a major issue.

______________________________

4. If you are copy/pasting the Post URLs & Post Titles from this sheet, be sure to use the "Paste Special>Paste As Values" option. Otherwise, you will just paste a bunch of functions and that will suck.

______________________________



Note: This is currently set up to only pull internal URLs from Reddit, so it will not pull post data that links to an external URL outside of reddit.com. This should be okay, since a majority of question-based posts on reddit will be "self posts".
ex) https://www.reddit.com/r/AskReddit/Insert Subreddit URL here ^#VALUE!
5
Subreddit Text
6
ex) https://www.reddit.com/r/AskReddit/Insert Subreddit Text+' here ^
7
In this example the "Subreddit Text" would be the red text - CASE SENSITIVE
8
Add an ' to the end of the text (I know, lol)
It should look like AskReddit'
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
Loading...
 
 
 
InputData
Data
 
 
Main menu