GitHub Star Tracker - Slack & Sheets

This workflow automates tracking of GitHub repository star events, replacing manual monitoring that consumes 5+ hours weekly for teams managing 10+ repositories. It captures star creation/deletion events via a GitHub webhook, processes event data, sends rich Slack notifications with user avatars and repository stats, and logs details to Google Sheets for analytics. Key nodes include GithubTrigger (GitHub Star Trigger) for event capture, Set (Event Processor) for data formatting, Slack (Slack Notifier) for notifications, and GoogleSheets (Sheets Logger) for logging. Ideal for open-source maintainers, developer teams, or marketing teams (3-10 staff) in tech or SaaS ($500K-$5M revenue), it reduces monitoring time by 90% for 100-1,000 star events monthly.\n\nSaves 4 hours/week on 10+ repositories, improving tracking efficiency by 90%. Suits open-source projects, developer marketing, or repository analytics. Requires GitHub API (free, developer.github.com), Slack API (free, api.slack.com), Google Sheets API (free, console.developers.google.com), n8n ($20/month cloud). Scalable to 2,000 events/month; needs HTTPS.\n\nSetup Instructions:\n1. Install n8n via cloud.n8n.io or self-host (docker run -it --rm -p 5678:5678 n8nio/n8n).\n2. Set up GitHub webhook for star events at developer.github.com; configure githubApi in DevHubConnect GitHub API with owner and repository.\n3. Set up Slack API at api.slack.com; configure slackApi in DevHubConnect Slack API with channel (e.g., #development).\n4. Set up Google Sheets API at console.developers.google.com; configure googleSheetsOAuth2Api in DevHubConnect Google Sheets API with GOOGLE_SHEETS_ID and SHEETS_TAB_NAME.\n5. Create Google Sheet with columns: Date, Time, Action, User, Repository, Total Stars, User Profile, Timestamp.\n6. Set environment variables: GITHUB_TOKEN, SLACK_BOT_TOKEN, GOOGLE_SHEETS_CLIENT_EMAIL, GOOGLE_SHEETS_PRIVATE_KEY, GITHUB_USERNAME, GITHUB_REPOSITORY, GOOGLE_SHEETS_ID, SLACK_CHANNEL.\n\nTesting:\n- Trigger a star event on the configured repository. Verify Slack notification with user avatar and star count, and check Google Sheet log.\n- Unstar the repository. Confirm notification and log reflect deletion with appropriate emoji and color.\n\nErrors:\n- 400 (invalid webhook, ensure GitHub webhook is active).\n- 429 (API rate limit, verify GitHub/Slack API quotas).\n- No log entry (invalid Sheet ID, check GOOGLE_SHEETS_ID).\n\nMaintenance:\n- Rotate API tokens quarterly.\n- Monitor n8n logs for GitHub/Slack/Sheets API failures.\n- Archive Google Sheet data monthly to manage size.\n\nOptimization:\n- Add filters in Event Processor for specific repositories or users.\n- Include additional metrics (e.g., forks, issues) in Slack Notifier.\n- Set up automated reports in Sheets Logger for weekly/monthly summaries.", "businessValue": "Saves 4 hours/week on 10+ repositories with 90% faster tracking", "setupTime": "30-45 minutes", "difficulty": "Intermediate", "requirements": [ "GitHub API (free, developer.github.com)", "Slack API (free, api.slack.com)", "Google Sheets API (free, console.developers.google.com)", "n8n cloud ($20/month) or self-hosted", "Stable HTTPS connection", "Environment variables: GITHUB_TOKEN, SLACK_BOT_TOKEN, GOOGLE_SHEETS_CLIENT_EMAIL, GOOGLE_SHEETS_PRIVATE_KEY, GITHUB_USERNAME, GITHUB_REPOSITORY, GOOGLE_SHEETS_ID, SLACK_CHANNEL" ], "useCase": "Automating GitHub star event tracking with Slack notifications and Google Sheets logging"