The wealth of information on Reddit is essentially endless – but it’s like trying to drink from a firehose. It’s way too much information, all over the place, updating in realtime.
How do you use this data?
Well, from an Agency Owner’s perspective you should be mining it for competitive intelligence and product and service ideas.
The process starts with you first identifying the SubReddits where 1) your competitors are hanging out and engaging in discussions, and 2) where you target audience (or potential clients) are hanging out.
Then you want to grab all the posts and all the comments, and parse through them for nuggets of insight and direction.
But copying and pasting all of that information sounds like a nightmare — why just scrape it all into a neatly organized Google Sheet instead?
What a good idea.
Introducing The Google Sheets Reddit Scraper
This simple, yet powerful tool lets you scrape individual SubReddit’s for Top Posts (up to 50 at a time) and all corresponding comments. It then pulls all of this text, time-stamped, into neatly organized columns in Google Sheets – complete with links to the source posts on Reddit.
Starting a company is hard. Really. Effing. Hard. There’s plenty of articles on the internet about how great it is, and less about how it’s kind of shitty. This is my personal perspective on what I’ve learned after riding this rollercoaster for 10 years.