Extract Emails of Top Contributors from GitHub Repositories

I have a table with a list of github repo urls. I want to get the email for the top 2 contributors to each repo. What's the best way to accomplish this?

6 comments

Clay
APP
·
·
Use two GitHub actions in sequence: 1. Find Contributors with Github - Input your repo URLs to get all contributors with commit counts 2. Find Email from Username or Search with Github - Use the usernames from the top 2 contributors to retrieve their email addresses The contributors action returns an array with usernames and contribution data, so you can identify the top contributors by commit count, then use their usernames in the email lookup action
Sources: Find Contributors with Github Find Email from Username or Search with Github Find Contributors with Github | Clay.com Find Repo Summary with Github | Clay.com
Tori S.
·
·
The find contributors with github doesn't work in this case, because I need to perform this operation on a list of github repos. I'm not starting with a single repo to kick off a table.
Clay
APP
·
·
You're correct that "Find Contributors with Github" processes one repository at a time. For your table of GitHub repo URLs, you'll need to: 1. Add the "Find Contributors with Github" action as a column - This will run for each repo URL in your table automatically, returning an array of contributors with commit counts for each repository 2. Use a formula or additional column to identify the top 2 contributors from each array based on commit counts 3. Add "Find Email from Username or Search with Github" as another column, using the usernames of the top 2 contributors to retrieve their email addresses The key is that when you add an action as a column in Clay, it automatically processes each row in your table, so you don't need batch processing - Clay handles the iteration for you.
Sources: Find Contributors with Github Find Email from Username or Search with Github
Clay
APP
·
·
Hey Tori, thanks for reaching out! Let me take a look.
Clay
APP
·
·
Hey Tori, are you working in the "Official MCP Servers" table? If not, can you send the table link please so I can help troubleshoot? Thanks!
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.

Extract Emails of Top Contributors from GitHub Repositories | Clay