scraper.py

from instagrapi import Client
import pandas as pd
import time
import os

USERNAME = os.getenv("IG_USERNAME")
PASSWORD = os.getenv("IG_PASSWORD")

client = Client()
client.login(USERNAME, PASSWORD)

with open("profiles.txt", "r") as f:
    profiles = [line.strip() for line in f]

rows = []

for username in profiles:
    try:
        print(f"Fetching {username}")

        user = client.user_info_by_username(username)

        rows.append({
            "username": user.username,
            "full_name": user.full_name,
            "biography": user.biography,
            "followers": user.follower_count,
            "following": user.following_count,
            "profile_url": f"https://instagram.com/{user.username}"
        })

        time.sleep(5)

    except Exception as e:
        print(e)

df = pd.DataFrame(rows)
df.to_excel("output/instagram_profiles.xlsx", index=False)

print("Done.")