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. Copy your Clay workbook's Webhook column URL

   

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

4. Copy main.tsx's HTTP endpoint URL

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

6. 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