GitHub pull request merge audit report in Google Sheets
Build a scheduled workflow that queries the GitHub API for pull requests merged in a given window across the target repositories. For each PR capture title, author, URL, and merge date. Write the rows to a new timestamped Google Sheet (or tab). Paginate results, handle repos with no merges, retry rate-limited calls, and exclude bots if configured. Output the report link and the count of PRs captured.
What this prompt builds
Compile merged GitHub PRs (title, author, URL, merge date) into a timestamped Google Sheet for review.
The problem
Change-management auditors need evidence of who merged what and when, but pulling that from GitHub manually across repos is slow and error-prone. Without it, code-change controls fail review.
Solution and impact
This workflow collects merged pull requests and writes a structured, timestamped audit report to Google Sheets. Change evidence is produced on demand, satisfying auditors without engineers compiling it by hand.