Extract GitHub issue authors' emails and send them to Clay for enrichment.

This API fetches all issues from a GitHub repository, extracts unique author usernames, finds their email addresses, and sends the data to Clay for further enrichment.

1. Remix this val

2. Set GITHUB_TOKEN in this val's Environment variables on the left sidebar - GitHub personal access token with repo access

3. Copy your Clay workbook's Webhook column URL

   

4. Set that as CLAY_WEBHOOK_URL in this val's Environment variables on the left sidebar

5. Copy main.tsx's HTTP endpoint URL

6. Replace "https://ghissuestoclay.val.run/" with your URL in test.ts

7. Try it out: click Run in test.ts

• githubRepo - Required - Repository in format "owner/repo"
• clayWebhookUrl - Required - Your Clay webhook URL for data enrichment
• githubToken - Required - GitHub Personal Access Token
• limit - Optional - Maximum number of unique authors to process (default: 10)

Each record sent to Clay contains:

• github_username - The GitHub username
• email - The email address found for the user
• source_repo - The repository the issues came from

Create a GitHub Personal Access Token with repo access:

1. Go to GitHub Settings > Developer settings > Personal access tokens
2. Generate new token with repo scope
3. Set as GITHUB_TOKEN environment variable

1. Create a Clay table for enrichment
2. Set up a webhook endpoint in Clay
3. Use the webhook URL as clayWebhookUrl parameter