---
title: "Reddit Scraper Tool Powered by Google Sheets"
description: "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."
url: "https://nickeubanks.com/reddit-scraper"
author: "Nick Eubanks"
date: "2020-03-30"
categories: ["Entrepreneurship"]
tags: []
wordCount: 300
readingTime: 2
---

# Reddit Scraper Tool Powered by Google Sheets

**Published:** March 30, 2020 · 2 min read · Entrepreneurship

> 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 ScraperThis 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. ![](https://nickeubanks.com/wp-content/uploads/2020/03/unnamed-10.png)[Click Here to Download](#mailmunch-pop-936042)Here's how it works:IMPORTANT Watch the video - it's ~3 minutesUse the native Reddit menu to set your SubReddit of choiceGo click "Scrape Now"In about 10 seconds it will populate your sheet with resultsCopy and paste into new sheets, rinse and repeatImportant NoteYou 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 a message asing you to "Authorize the app." 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.Happy Scraping.[Click Here to Download](#mailmunch-pop-936042)

---

*Written by [Nick Eubanks](https://nickeubanks.com) — serial entrepreneur, Global CMO at Digistore24, and author of [The Last Moat](https://nickeubanks.com/book).*

[Read on nickeubanks.com](https://nickeubanks.com/reddit-scraper)