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.
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.
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.
You will need to authorize the custom script to run within your copy of the Google Sheet.
You will know this when you go to run the script the first time and are greeted with this message:
Click Advanced > Proceed, then you will need to click Allow
This is just to authorize a custom script to be run within Google App Scripts, you are not giving me permission or access to ANYTHING.
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.