Highlighted posts

import praw
import gspread
from oauth2client.service_account import ServiceAccountCredentials
import re
import time
import prawcore

# Reddit API credentials
reddit = praw.Reddit(
    client_id='[Your client ID]',
    client_secret='[Yourclientsecret]',
    user_agent='[useragent by YOuruseragent]',
    username='[yourusername]',
    password='[yourpassword]'
)

# Google Sheets API credentials
scope = ['https://spreadsheets.google.com/feeds', 'https://www.googleapis.com/auth/drive']
creds = ServiceAccountCredentials.from_json_keyfile_name('credentials.json', scope)
client = gspread.authorize(creds)

# Open your spreadsheet
spreadsheet = client.open('Accountchecker')  # Replace with your sheet name
sheet = spreadsheet.sheet1  # Use the first sheet or specify by name

# Get all usernames from the first column
usernames = sheet.col_values(1)[1:]  # Skip header

# Prepare headers if missing
headers = sheet.row_values(1)
if 'Suspended' not in headers:
    sheet.update_cell(1, 2, 'Suspended')
if 'Post Karma' not in headers:
    sheet.update_cell(1, 3, 'Post Karma')
if 'Comment Karma' not in headers:
    sheet.update_cell(1, 4, 'Comment Karma')

# Cache data to reduce API calls
data = sheet.get_all_values()

# Process each username
updates = []  # Cache updates to batch process later
batch_size = 10  # Number of rows to process before batching updates

for i, row in enumerate(data[1:], start=2):
    # Skip rows that already have data in the 'Suspended' column
    if len(row) > 1 and row[1]:  # Check if 'Suspended' column is filled
        continue

    # Trim spaces and validate username
    username = row[0].strip()
    if not re.match(r'^[A-Za-z0-9_-]+$', username):
        print(f"Invalid username at row {i}: {username}")
        updates.append([i, 'Suspended', 'N/A', 'N/A'])
        continue

    try:
        user = reddit.redditor(username)
        user.id  # Trigger error if suspended

        # Attempt to fetch subreddit to detect shadowban
        try:
            user.subreddit.display_name  # Access subreddit info
            updates.append([i, 'No', user.link_karma, user.comment_karma])
        except Exception:
            # Shadowbanned if subreddit info cannot be accessed
            updates.append([i, 'Shadowbanned', user.link_karma, user.comment_karma])

    except prawcore.exceptions.NotFound:
        # Suspended or deleted account
        updates.append([i, 'Yes', 'N/A', 'N/A'])

    except Exception as e:
        print(f"Error processing {username} at row {i}: {e}")
        updates.append([i, 'Yes', 'N/A', 'N/A'])

    # Pause for 5 seconds to avoid API overuse
    time.sleep(5)

    # Perform batch update every 10 rows
    if len(updates) >= batch_size:
        for update in updates:
            sheet.update_cell(update[0], 2, update[1])  # Suspended
            sheet.update_cell(update[0], 3, update[2])  # Post Karma
            sheet.update_cell(update[0], 4, update[3])  # Comment Karma
        updates = []  # Clear updates after batch processing

# Final batch update for remaining rows
for update in updates:
    sheet.update_cell(update[0], 2, update[1])  # Suspended
    sheet.update_cell(update[0], 3, update[2])  # Post Karma
    sheet.update_cell(update[0], 4, update[3])  # Comment Karma

print('Update complete!')

import praw
import gspread
from oauth2client.service_account import ServiceAccountCredentials
import time

# Reddit API Credentials
REDDIT_CLIENT_ID = 'your_client_id'
REDDIT_CLIENT_SECRET = 'your_client_secret'
REDDIT_USERNAME = 'your_username'
REDDIT_PASSWORD = 'your_password'
REDDIT_USER_AGENT = 'script:subreddit_checker:v1.0 (by /u/your_username)'

# Google Sheets API Credentials File
GOOGLE_SHEETS_CREDENTIALS = 'path/to/credentials.json'  # Path to your credentials.json file
SPREADSHEET_NAME = 'SubredditChecker'  # Name of your Google Spreadsheet

# Initialize Reddit Instance
reddit = praw.Reddit(
    client_id=REDDIT_CLIENT_ID,
    client_secret=REDDIT_CLIENT_SECRET,
    username=REDDIT_USERNAME,
    password=REDDIT_PASSWORD,
    user_agent=REDDIT_USER_AGENT
)

# Google Sheets Authentication Scope
scope = ["https://spreadsheets.google.com/feeds", "https://www.googleapis.com/auth/drive"]
creds = ServiceAccountCredentials.from_json_keyfile_name(GOOGLE_SHEETS_CREDENTIALS, scope)
client = gspread.authorize(creds)
sheet = client.open(SPREADSHEET_NAME).sheet1  # Access the first sheet

def check_subreddit_details(subreddit_name):
    """Fetch subreddit details such as ban status, crosspostability, and members."""
    try:
        subreddit = reddit.subreddit(subreddit_name)
        is_banned = False
        is_crosspost_enabled = subreddit.allow_crosspost
        member_count = subreddit.subscribers
    except Exception as e:
        # If subreddit is banned or inaccessible
        print(f"Error fetching subreddit {subreddit_name}: {e}")
        is_banned = True
        is_crosspost_enabled = 'N/A'
        member_count = 'N/A'
    return is_banned, is_crosspost_enabled, member_count

def update_google_sheet():
    """Read or populate subreddit list in Google Sheet and update with details."""
    print("Fetching subreddit list from Google Sheets...")
    subreddits = sheet.col_values(1)  # Read all values from Column A

    # If Column A is empty (excluding headers), populate it with a sample list
    if len(subreddits) <= 1:  # Only the header row exists
        print("Column A is empty. Populating it with sample subreddit names...")
        sample_subreddits = ["AskReddit", "Python", "learnprogramming", "gaming", "worldnews"]
        sheet.update('A2:A{}'.format(len(sample_subreddits) + 1), [[sub] for sub in sample_subreddits])
        subreddits = sheet.col_values(1)
        print("Sample subreddits added to Column A.")

    subreddits = subreddits[1:]  # Exclude the header row

    # Write headers if they are missing
    headers = ["Subreddit", "Banned", "Crosspost Enabled", "Members"]
    if sheet.cell(1, 2).value != "Banned":
        sheet.insert_row(headers, 1)

    # Check and update subreddit details
    for i, subreddit_name in enumerate(subreddits, start=2):  # Start from row 2
        print(f"Working on row {i}: Checking subreddit: {subreddit_name}")
        is_banned, crosspost_enabled, member_count = check_subreddit_details(subreddit_name)

        # Update the sheet with the results
        sheet.update_cell(i, 2, "Yes" if is_banned else "No")  # Banned column
        sheet.update_cell(i, 3, "Yes" if crosspost_enabled else "No")  # Crosspost column
        sheet.update_cell(i, 4, member_count)  # Member count

        print(f"Finished row {i}: Updated subreddit {subreddit_name}")
        time.sleep(2)  # Avoid hitting rate limits
    print("Google Sheet updated successfully!")

if __name__ == "__main__":
    update_google_sheet()