📋 How to Scrape Reddit with Google Scripts

1. Overview

\[ \begin{array}{l} \textbf{Google Apps Script can fetch and process Reddit data --} \\ \text{by using Reddit's public JSON feeds without requiring authentication for basic scraping.} \\ \textbf{This allows you to collect posts, titles, authors, and scores --} \\ \text{directly into Google Sheets for analysis or reporting.} \end{array} \]

2. Core Steps

\[ \begin{array}{ll} \textbf{Step\ 1:} & \text{Open a new or existing Google Sheet for storing Reddit data.} \\ \textbf{Step\ 2:} & \text{Go to Extensions $\rightarrow$ Apps Script to open the editor.} \\ \textbf{Step\ 3:} & \text{Use UrlFetchApp in Apps Script to request Reddit's JSON API endpoint.} \\ \textbf{Step\ 4:} & \text{Parse the JSON response and insert relevant data into the sheet.} \\ \textbf{Step\ 5:} & \text{Run the script, review the imported posts, and set triggers for automation.} \end{array} \]

3. Sample Google Apps Script

// Example: Scrape posts from a subreddit (e.g., r/technology)
function scrapeReddit() {
  var subreddit = 'technology'; // Change to your target subreddit
  var url = 'https://www.reddit.com/r/' + subreddit + '/.json?limit=10';
  
  var response = UrlFetchApp.fetch(url, {
    'muteHttpExceptions': true,
    'headers': { 'User-Agent': 'GoogleScript/1.0' }
  });
  
  var data = JSON.parse(response.getContentText());
  
  if (data && data.data && data.data.children) {
    var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
    sheet.clear();
    sheet.appendRow(['Title', 'Author', 'Score', 'URL']);
    
    data.data.children.forEach(function(post) {
      var p = post.data;
      sheet.appendRow([p.title, p.author, p.score, 'https://reddit.com' + p.permalink]);
    });
  } else {
    Logger.log("No data returned or invalid subreddit.");
  }
}

4. Important Notes

\[ \begin{array}{l} \text{• Reddit's JSON API does not require authentication for public subreddits.} \\ \text{• Excessive requests may lead to temporary IP blocking; add delays if needed.} \\ \text{• Always set a User-Agent header to avoid being blocked.} \\ \text{• Respect Reddit's API terms of use when scraping content.} \end{array} \]

5. Conceptual Flow (in LaTeX)

The process can be described as:

\[ \text{Reddit JSON Feed} \xrightarrow{\text{Apps Script Parsing}} \text{Structured Data in Google Sheets} \]

Where: \[ \text{Structured Data} = \{ \text{Title}, \text{Author}, \text{Score}, \text{Post URL} \} \]