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. Paste that 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)

1. Fetches Issues: Retrieves all issues from the specified GitHub repository
2. Extracts Authors: Gets unique author usernames from the issues
3. Finds Emails: Uses GitHub API to find email addresses for each author
4. Sends to Clay: Sends each email with metadata to your Clay webhook for enrichment

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