Log deployments to a tracking spreadsheet
Record deployment details from GitHub to a Google Sheet automatically
Overview
Deployment logs are only useful if theyre complete, but relying on people to update them manually means entries get missed. This template reads the release history and logs each deployment automatically, skipping duplicates so your sheet stays accurate without extra effort.
How it works
- Reads the most recent deployment from your repositorys release history
- Extracts the version tag, commit SHA, environment, timestamp, and who triggered it
- Checks if a row with that commit SHA already exists in your sheet
- Adds a new row with the deployment details if no duplicate is found
- Keeps your deployment log complete without manual entry
Who this is for
Engineers and DevOps practitioners who want a reliable deployment history without depending on manual updates.
Suggested prompt
Read the most recent deployment from this repositorys release history, including the version tag, commit SHA, environment, timestamp, and the GitHub username that triggered it. Add a new row to my Google Sheet called [1. Deployment log sheet name] with those values in the corresponding columns: Version, Commit, Environment, Deployed At, and Deployed By. If a row with that commit SHA already exists, skip it.
Frequently asked questions
Can I log to Datadog instead of Google Sheets?
Yes, swap Google Sheets for Datadog in the prompt to send deployment events to your monitoring stack.
Can I add more columns?
Yes, modify the prompt to include additional fields like branch name, PR number, or deployment duration.
What if I use GitLab instead of GitHub?
Swap GitHub for GitLab in the prompt and connect GitLab to your MCP server.
Can I also post a notification to Slack?
Yes, add an instruction to post a message to a Slack channel after logging the deployment.