[{"_1":2,"_242":-5,"_243":-5},"loaderData",{"_3":4,"_91":92,"_227":228},"root",{"_5":6,"_34":35,"_64":65},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":22,"_29":22,"_30":22,"_31":32,"_33":22},"auth",{"_9":10,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":-5,"_20":-5,"_21":22},"tokenType","session_token","sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","notificationCount",0,"flagDenols","ENV",{"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":51,"_52":53,"_54":55,"_56":57,"_58":59,"_60":61,"_62":63},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","5f86047c78fbcbbdc94436f811a86add7eaf8c7a","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","API_URL","https://api.val.town","clerkState",{"_66":67},"__internal_clerk_state",{"_68":69,"_70":45,"_71":72,"_73":72,"_74":22,"_75":72,"_76":72,"_77":72,"_78":72,"_79":80,"_89":22,"_90":22},"__clerk_ssr_state",{"_9":10,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":-5,"_20":-5,"_21":22},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_81":22,"_21":22,"_82":72,"_83":84,"_85":72,"_86":45,"_87":22,"_88":72},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/_app.x.$handle.$name",{"_93":94,"_95":96,"_97":-7,"_98":72,"_99":-7,"_100":101,"_149":150,"_196":197,"_198":199,"_207":208,"_163":-5,"_221":-5,"_222":-5,"_223":22,"_224":22,"_225":226},"handle","stevekrouse","name","GitHub-To-Clay","branchName","path","version","project",{"_102":103,"_95":96,"_104":105,"_106":-5,"_107":22,"_108":109,"_110":-5,"_111":-5,"_14":112,"_113":-5,"_114":22,"_115":-5,"_116":32,"_16":117,"_118":119,"_120":119,"_121":122,"_123":122,"_124":122,"_125":119,"_126":119,"_23":127,"_130":131,"_133":134,"_148":22},"id","22d58e48-a602-11f0-ad62-0224a6c84d84","createdAt",["D",1760118855268],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","a0bf3b31-15a5-4d5c-880e-4b1e22c9bc18","pinnedFileId","pinPreview","screenshotVersion","likeCount","e81e7335-6d4c-4764-a902-d0962bbfa9f7","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_93":94,"_128":129},"profileImageUrl","https://images.clerk.dev/uploaded/img_2PqHa2Gsy93xQrjh2w78Xu0cChW.jpeg","org",{"_93":94,"_132":129},"avatar","branch",{"_99":135,"_95":43,"_102":136,"_137":103,"_138":-5,"_139":-5,"_140":141,"_142":143,"_144":145,"_146":96,"_147":94},1,"22dac71e-a602-11f0-ad62-0224a6c84d84","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","private","forkedProjectId","60c487fe-a454-11f0-9e71-0224a6c84d84","forkedProjectOrgId","019977b1-1bd1-730d-a575-2afdc309b42c","projectName","userHandle","isOwned","tree",[151,171,180,188],{"_102":152,"_95":153,"_154":155,"_156":-5,"_157":136,"_158":135,"_159":160,"_104":161,"_99":32,"_162":163,"_164":165,"_166":22,"_167":-5,"_168":169,"_98":170},"22df00cc-a602-11f0-ad62-0224a6c84d84","README.md","fileId","0199cf42-56bb-720d-b19c-b79385b20549","parentId","branchId","branchVersion","latest",true,["D",1760118855268],"fileType","file","content","# GitHub to Clay Scraper\n\nScrape users from any GitHub repo, and automatically ingest into Clay. This val\nscrapes the username of anyone who has created an issue, reacted to an issues,\ncommented on an issue, reacted to the comments, starred, or forked any repo.\n\n![CleanShot_2025-10-08_at_17.41.422x.png](https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/86543734-10b8-431c-e71e-da3da9c11400/public)\n\n## Setup\n\n1. Click `Remix` on the top-right to get a copy of it\n1. Set up a Clay workbook with a `Webhook` column\n1. Copy your Clay workbook's `Webhook` URL\n ![CleanShot 2025-08-08 at 13.23.47@2x.png](https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/48cd9c4d-2990-480f-9d07-fb09e2282500/public)\n\n1. Set that as `CLAY_WEBHOOK_URL` in this val's `Environment variables` on the\n left sidebar\n1. In [main.ts](./main.ts), replace `GITHUB_REPO` with the full repository name\n (format: `\"owner/repo\"`)\n1. And that's it! The cron will run on your repo every 30 minutes from now on.\nTo test it out immediately, navigate to [main.ts](./main.ts) and click `Run`.\n\n## Files\n\n- [clay.ts](clay.ts) - Send data to Clay\n- [github.ts](github.ts) - Collects engaged users and fetches usernames\n- [main.ts](main.ts) - Cron trigger that orchestrates the scraping and Clay\n integration\n\n## Rate Limiting\n\nOn larger repos, you may get rate-limited by GitHub. To mitigate this, Val Town\nuses a [proxied fetch](https://docs.val.town/std/fetch/) that reroutes requests\nusing a proxy vendor so that requests obtain different IP addresses. It also\nautomatically retries failed requests several times.","deleted","label","children",[],[153],{"_102":172,"_95":173,"_154":174,"_156":-5,"_157":136,"_158":135,"_159":160,"_104":175,"_99":32,"_162":176,"_164":177,"_166":22,"_167":-5,"_168":178,"_98":179},"22df090a-a602-11f0-ad62-0224a6c84d84","clay.ts","0199cf42-56bb-720d-b19c-b85211c8adf5",["D",1760118855268],"script","export async function sendToClay(\n webhookUrl: string,\n data: any[],\n): Promise {\n for (const record of data) {\n const response = await fetch(webhookUrl, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(record),\n });\n\n if (!response.ok) {\n const errorText = await response.text();\n throw new Error(`Clay request failed: ${response.status} ${errorText}`);\n }\n }\n}\n",[],[173],{"_102":181,"_95":182,"_154":183,"_156":-5,"_157":136,"_158":135,"_159":160,"_104":184,"_99":32,"_162":176,"_164":185,"_166":22,"_167":-5,"_168":186,"_98":187},"22df0a7c-a602-11f0-ad62-0224a6c84d84","github.ts","0199cf42-56bb-720d-b19c-be3da8891ed6",["D",1760118855268],"import { fetch } from \"https://esm.town/v/std/fetch\";\n\nexport interface EngagedUser {\n github_username: string;\n source_repo: string;\n}\n\nexport async function fetchAllIssues(\n owner: string,\n repo: string,\n limit?: number,\n): Promise {\n const issues: any[] = [];\n let page = 1;\n const perPage = limit && limit < 100 ? limit : 100;\n\n const headers: Record = {\n Accept: \"application/vnd.github.v3+json\",\n \"User-Agent\": \"GitHubEngagementTracker/1.0\",\n };\n\n while (true) {\n const remainder = limit\n ? Math.min(perPage, limit - issues.length)\n : perPage;\n\n if (remainder <= 0) break;\n\n const response = await fetch(\n `https://api.github.com/repos/${owner}/${repo}/issues?page=${page}&per_page=${remainder}&state=all`,\n { headers },\n );\n\n if (!response.ok) {\n throw new Error(\n `GitHub API error: ${response.status} ${response.statusText}`,\n );\n }\n\n const data = await response.json();\n\n const filteredIssues = data\n .filter((item) => !item.pull_request)\n .map((item) => ({\n number: item.number,\n title: item.title,\n body: item.body || \"\",\n author_username: item.user.login,\n created_at: item.created_at,\n updated_at: item.updated_at,\n state: item.state,\n labels: item.labels.map((label) => label.name),\n html_url: item.html_url,\n }));\n\n issues.push(...filteredIssues);\n\n if (data.length < remainder) break;\n\n page++;\n }\n\n return issues;\n}\n\nexport async function fetchIssueComments(\n owner: string,\n repo: string,\n issueNumber: number,\n limit?: number,\n): Promise {\n const comments: any[] = [];\n let page = 1;\n const perPage = limit && limit < 100 ? limit : 100;\n\n const headers: Record = {\n Accept: \"application/vnd.github.v3+json\",\n \"User-Agent\": \"GitHubEngagementTracker/1.0\",\n };\n\n while (true) {\n const remainder = limit\n ? Math.min(perPage, limit - comments.length)\n : perPage;\n\n if (remainder <= 0) break;\n\n const response = await fetch(\n `https://api.github.com/repos/${owner}/${repo}/issues/${issueNumber}/comments?page=${page}&per_page=${remainder}`,\n { headers },\n );\n\n if (!response.ok) {\n if (response.status === 404) return comments;\n throw new Error(\n `GitHub API error fetching comments: ${response.status} ${response.statusText}`,\n );\n }\n\n const data = await response.json();\n\n const mappedComments = data.map((item: any) => ({\n id: item.id,\n body: item.body || \"\",\n author_username: item.user.login,\n created_at: item.created_at,\n issue_number: issueNumber,\n }));\n\n comments.push(...mappedComments);\n\n if (data.length < remainder) break;\n page++;\n }\n\n return comments;\n}\n\nexport async function fetchIssueReactions(\n owner: string,\n repo: string,\n issueNumber: number,\n): Promise {\n const headers: Record = {\n Accept: \"application/vnd.github.v3+json\",\n \"User-Agent\": \"GitHubEngagementTracker/1.0\",\n };\n\n const response = await fetch(\n `https://api.github.com/repos/${owner}/${repo}/issues/${issueNumber}/reactions`,\n { headers },\n );\n\n if (!response.ok) {\n if (response.status === 404) return [];\n throw new Error(\n `GitHub API error fetching issue reactions: ${response.status} ${response.statusText}`,\n );\n }\n\n const data = await response.json();\n\n return data.map((item: any) => ({\n content: item.content,\n user_username: item.user.login,\n created_at: item.created_at,\n }));\n}\n\nexport async function fetchCommentReactions(\n owner: string,\n repo: string,\n commentId: number,\n): Promise {\n const headers: Record = {\n Accept: \"application/vnd.github.v3+json\",\n \"User-Agent\": \"GitHubEngagementTracker/1.0\",\n };\n\n const response = await fetch(\n `https://api.github.com/repos/${owner}/${repo}/issues/comments/${commentId}/reactions`,\n { headers },\n );\n\n if (!response.ok) {\n if (response.status === 404) return [];\n throw new Error(\n `GitHub API error fetching comment reactions: ${response.status} ${response.statusText}`,\n );\n }\n\n const data = await response.json();\n\n return data.map((item: any) => ({\n content: item.content,\n user_username: item.user.login,\n created_at: item.created_at,\n }));\n}\n\nexport async function fetchStargazers(\n owner: string,\n repo: string,\n limit?: number,\n): Promise {\n const stargazers: string[] = [];\n let page = 1;\n const perPage = limit && limit < 100 ? limit : 100;\n\n const headers: Record = {\n Accept: \"application/vnd.github.v3+json\",\n \"User-Agent\": \"GitHubEngagementTracker/1.0\",\n };\n\n while (true) {\n const remainder = limit\n ? Math.min(perPage, limit - stargazers.length)\n : perPage;\n\n if (remainder <= 0) break;\n\n const response = await fetch(\n `https://api.github.com/repos/${owner}/${repo}/stargazers?page=${page}&per_page=${remainder}`,\n { headers },\n );\n\n if (!response.ok) {\n if (response.status === 404) return stargazers;\n throw new Error(\n `GitHub API error fetching stargazers: ${response.status} ${response.statusText}`,\n );\n }\n\n const data = await response.json();\n\n for (const item of data) {\n stargazers.push(item.login);\n }\n\n if (data.length < remainder) break;\n page++;\n }\n\n return stargazers;\n}\n\nexport async function fetchForks(\n owner: string,\n repo: string,\n limit?: number,\n): Promise {\n const forkers: string[] = [];\n let page = 1;\n const perPage = limit && limit < 100 ? limit : 100;\n\n const headers: Record = {\n Accept: \"application/vnd.github.v3+json\",\n \"User-Agent\": \"GitHubEngagementTracker/1.0\",\n };\n\n while (true) {\n const remainder = limit\n ? Math.min(perPage, limit - forkers.length)\n : perPage;\n\n if (remainder <= 0) break;\n\n const response = await fetch(\n `https://api.github.com/repos/${owner}/${repo}/forks?page=${page}&per_page=${remainder}`,\n { headers },\n );\n\n if (!response.ok) {\n if (response.status === 404) return forkers;\n throw new Error(\n `GitHub API error fetching forks: ${response.status} ${response.statusText}`,\n );\n }\n\n const data = await response.json();\n\n for (const item of data) {\n forkers.push(item.owner.login);\n }\n\n if (data.length < remainder) break;\n page++;\n }\n\n return forkers;\n}\n\ninterface FetchConfig {\n issueLimit?: number;\n maxStargazers?: number;\n maxForks?: number;\n maxCommentsPerIssue?: number;\n fetchReactions: boolean;\n}\n\nexport async function fetchEngagedUsers(\n owner: string,\n repo: string,\n config: FetchConfig,\n): Promise {\n console.log(`Fetching engaged users for ${owner}/${repo}...`);\n\n const issues = await fetchAllIssues(owner, repo, config.issueLimit);\n console.log(`Found ${issues.length} issues`);\n\n const engagedUsers = new Set();\n\n // Collect issue creators\n for (const issue of issues) {\n engagedUsers.add(issue.author_username);\n }\n\n // Fetch comments and reactions for each issue\n for (const issue of issues) {\n // Fetch issue comments\n try {\n const comments = await fetchIssueComments(\n owner,\n repo,\n issue.number,\n config.maxCommentsPerIssue,\n );\n\n for (const comment of comments) {\n engagedUsers.add(comment.author_username);\n\n // Fetch reactions for this comment (if enabled)\n if (config.fetchReactions) {\n try {\n const commentReactions = await fetchCommentReactions(\n owner,\n repo,\n comment.id,\n );\n\n for (const reaction of commentReactions) {\n engagedUsers.add(reaction.user_username);\n }\n } catch (error) {\n console.log(\n ` Error fetching reactions for comment ${comment.id}:`,\n error.message,\n );\n }\n }\n }\n } catch (error) {\n console.log(\n ` Error fetching comments for issue #${issue.number}:`,\n error.message,\n );\n }\n\n // Fetch issue reactions (if enabled)\n if (config.fetchReactions) {\n try {\n const issueReactions = await fetchIssueReactions(\n owner,\n repo,\n issue.number,\n );\n\n for (const reaction of issueReactions) {\n engagedUsers.add(reaction.user_username);\n }\n } catch (error) {\n console.log(\n ` Error fetching reactions for issue #${issue.number}:`,\n error.message,\n );\n }\n }\n }\n\n // Fetch stargazers\n try {\n const stargazers = await fetchStargazers(owner, repo, config.maxStargazers);\n console.log(`Found ${stargazers.length} stargazers`);\n for (const username of stargazers) {\n engagedUsers.add(username);\n }\n } catch (error) {\n console.log(` Error fetching stargazers:`, error.message);\n }\n\n // Fetch forkers\n try {\n const forkers = await fetchForks(owner, repo, config.maxForks);\n console.log(`Found ${forkers.length} forkers`);\n for (const username of forkers) {\n engagedUsers.add(username);\n }\n } catch (error) {\n console.log(` Error fetching forkers:`, error.message);\n }\n\n console.log(`Total unique engaged users: ${engagedUsers.size}`);\n return Array.from(engagedUsers);\n}\n",[],[182],{"_102":189,"_95":190,"_154":191,"_156":-5,"_157":136,"_158":135,"_159":160,"_104":192,"_99":32,"_162":176,"_164":193,"_166":22,"_167":-5,"_168":194,"_98":195},"22df1706-a602-11f0-ad62-0224a6c84d84","main.ts","0199cf42-56bb-720d-b19c-c1ef4b400e51",["D",1760118855268],"import { fetchEngagedUsers } from \"./github.ts\";\nimport { sendToClay } from \"./clay.ts\";\n\n// GitHub repository to track (format: \"owner/repo\")\nconst GITHUB_REPO = \"val-town/vt\";\n\n// Optional: Limit number of issues to fetch (undefined = fetch all)\nconst ISSUE_LIMIT = 3 as number | undefined;\n\n// Optional: Limit number of stargazers to fetch (undefined = fetch all)\nconst MAX_STARGAZERS = 5 as number | undefined;\n\n// Optional: Limit number of forks to fetch (undefined = fetch all)\nconst MAX_FORKS = 3 as number | undefined;\n\n// Optional: Limit comments per issue (undefined = fetch all)\nconst MAX_COMMENTS_PER_ISSUE = 3 as number | undefined;\n\n// Optional: Skip fetching reactions (faster processing)\nconst FETCH_REACTIONS = false;\n\nexport default async function () {\n // Make sure to set your Clay Webhook URL in the Environment Variables!\n const clayWebhookUrl = Deno.env.get(\"CLAY_WEBHOOK_URL\");\n\n if (!clayWebhookUrl) {\n throw new Error(\"CLAY_WEBHOOK_URL environment variable is required\");\n }\n\n const [owner, repo] = String(GITHUB_REPO).split(\"/\");\n\n // Fetch engaged users\n const engagedUsernames = await fetchEngagedUsers(owner, repo, {\n issueLimit: ISSUE_LIMIT,\n maxStargazers: MAX_STARGAZERS,\n maxForks: MAX_FORKS,\n maxCommentsPerIssue: MAX_COMMENTS_PER_ISSUE,\n fetchReactions: FETCH_REACTIONS,\n });\n console.log(`Found ${engagedUsernames.length} engaged users`);\n\n // Format data for Clay integration - one record per user\n const userData = engagedUsernames.map((username) => ({\n github_username: username,\n source_repo: GITHUB_REPO,\n }));\n\n // Log data\n console.log(`\\n=== User Data (for Clay integration) ===`);\n userData.forEach((record) => {\n console.log(JSON.stringify(record, null, 2));\n });\n\n console.log(`\\n→ Sending ${userData.length} user records to Clay...`);\n\n // Send to Clay\n if (userData.length > 0) {\n await sendToClay(clayWebhookUrl, userData);\n console.log(`✓ Successfully sent ${userData.length} records to Clay`);\n } else {\n console.log(`⚠ No user records to send`);\n }\n\n console.log(`\\n✓ Cron job completed successfully`);\n}",[],[190],"files",[151,171,180,188],"counts",{"_200":32,"_201":135,"_202":32,"_203":204},"pulls","branches","forks","envVars",{"_205":135,"_206":135},"count","emptyCount","contents",[209,212,215,218],{"_102":152,"_95":153,"_154":155,"_156":-5,"_157":136,"_158":135,"_159":160,"_104":210,"_99":32,"_162":163,"_164":165,"_166":22,"_167":-5,"_98":211},["D",1760118855268],[153],{"_102":172,"_95":173,"_154":174,"_156":-5,"_157":136,"_158":135,"_159":160,"_104":213,"_99":32,"_162":176,"_164":177,"_166":22,"_167":-5,"_98":214},["D",1760118855268],[173],{"_102":181,"_95":182,"_154":183,"_156":-5,"_157":136,"_158":135,"_159":160,"_104":216,"_99":32,"_162":176,"_164":185,"_166":22,"_167":-5,"_98":217},["D",1760118855268],[182],{"_102":189,"_95":190,"_154":191,"_156":-5,"_157":136,"_158":135,"_159":160,"_104":219,"_99":32,"_162":176,"_164":193,"_166":22,"_167":-5,"_98":220},["D",1760118855268],[190],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.environment-variables",{"_93":94,"_95":96,"_100":229,"_203":234},{"_102":103,"_95":96,"_104":230,"_106":-5,"_107":22,"_108":109,"_110":-5,"_111":-5,"_14":112,"_113":-5,"_114":22,"_115":-5,"_116":32,"_16":117,"_118":119,"_120":119,"_121":122,"_123":122,"_124":122,"_125":119,"_126":119,"_23":231,"_130":232,"_133":233,"_148":22},["D",1760118855268],{"_93":94,"_128":129},{"_93":94,"_132":129},{"_99":135,"_95":43,"_102":136,"_137":103,"_138":-5,"_139":-5,"_140":141,"_142":143,"_144":145,"_146":96,"_147":94},[235],{"_236":237,"_104":238,"_239":-5,"_110":240,"_241":160},"key","CLAY_WEBHOOK_URL",["D",1760118855268],"updatedAt","https://www.val.town/x/willemhelmet/GitHubIssuesToClay/code/README.md","isEmpty","actionData","errors"]