Change History Sheet

This is an example model of a sheet that you can manually populate to keep track of changes that affect your business. They can either be app releases, backend relesaes, marketing changes (e.g. incrementing budget, changing visuals), outages, external changes, etc.

To keep things simple to use, it uses two sheets, a "Recent Changes" one, that only contains changes from the last 14 days and a "Historical" one.

You can look at an example template sheet here

🗂 Move "Recent Changes" -> "Historical" Script

This repo has a Python script that moves "old" rows from "Recent Changes" into the a "Historical" sheet. It identifies old rows by looking at the "Change Timestamp" column and moving those older than 14 days. It also removes empty rows from the Recent Changes sheet to keep data compact.

---

📊 Example Spreadsheet Format

Your Google Spreadsheet must have a sheet named "Recent Changes" with the following columns:

Product Name	Version	Change Name	Change Details	Change Timestamp	End Change Timestamp	Change Type	Component	Platform	Link	Comments
Product Name 1	112.12.12	Testing		2025-05-01T17:34:00+03:00	2025-05-22	Full Rollout	Marketing	All
Product Name 2		Deploying		2025-03-27		Full Rollout	Marketing	All

✅ The Change Timestamp column must exist and be in one of these formats:

• ISO 8601: 2025-05-01T17:34:00+03:00 or 2025-05-01T17:34:00Z
• US-style: 05/01/2025 17:34:00

---

🛠 Script Behavior

• Moves rows from "Recent Changes" to "Historical" if the Change Timestamp is older than 14 days
• Keeps the header intact
• Removes gaps in "Recent Changes" by shifting non-empty rows upward

---

Prerequisites

1. Create a Google Service Account. The service account does not need to have any special roles.
2. Ensure the Google Cloud Project has the "Google Sheets API" enabled
3. Find your Spreadsheet ID for the sheet you want to modify. To find the ID, go to Share -> Copy Link and the id is found between /d/<ID IS HERE>/edit
4. Share the spreadsheet with the e-mail of the service account created at 1

🖥 Local Usage

1. Create a .env file

SERVICE_ACCOUNT_JSON=service-account-creds.json
SPREADSHEET_ID=your_spreadsheet_id_here

2. Install dependencies

pip install gspread google-auth python-dotenv

3. Run the script

python move_old_changes.py

---

☁️ GitHub Actions Automation

1. Add Secrets to GitHub

In your GitHub repo → Settings → Secrets and variables → Actions → Add the following:

• SERVICE_ACCOUNT_JSON – paste contents of your service-account-creds.json.
• SPREADSHEET_ID – your sheet ID

2. Enable and Run the Workflow

If you've copied or forked this repo, GitHub disables Actions by default. To enable and run the workflow:

1. Go to the "Actions" tab of your repository.
2. You will see a banner asking if you want to enable workflows — click “I understand…” and Enable.
3. You will see a workflow named "Move Old Sheet Rows".
4. Click into it, then press "Run workflow" (top-right dropdown) to trigger it manually.

The script will also run automatically every day if the schedule is enabled.

---