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.
-
Remix this val
-
Set
GITHUB_TOKENin this val'sEnvironment variableson the left sidebarGITHUB_TOKEN= GitHub personal access token withrepoaccess
-
Set up a Clay workbook with both a
Webhook column(or use this template) -
Copy your Clay workbook's
Webhook columnURL -
Set that as
CLAY_WEBHOOK_URLin this val'sEnvironment variableson the left sidebar -
Copy your
main.tsHTTP endpoint URL -
In test.ts , replace
"https://ghissuestoclay.val.run/"with your URL -
Try it out: click Run in test.ts
This val reads configuration exclusively from environment variables.
githubRepo- Required - Repository in format "owner/repo"clayWebhookUrl- Required - Your Clay webhook URL for data enrichmentgithubToken- Required - GitHub Personal Access Tokenlimit- In-code default of 10 unique authors processed
Each record sent to Clay contains:
github_username- The GitHub usernameemail- The email address found for the usersource_repo- The repository the issues came from