Step 7
Unlock Deeper Insights: Tracking Field Changelogs
To answer the critical questions of "who, what, and when." The changelog feature lets you see the history of any field, whichis invaluable for auditing, process analysis, and understanding an issue's journey.
In the "Field Mappings" section, find the field you want to track (e.g., "Status," "Assignee," "Story Points").
Check the "Track Changelog" box associated with that field.
Save the configuraiton for future or run your sync.
Understanding the Changelog Format
The output in your sheet cell will be a JSON string that looks like this:
{"logs":[{"ChangedBy":"John Doe","ChangedAtTimestamp":"...","ValueFrom":"To Do","ValueTo":"In Progress"}], "changesCount":1}
changesCount: A simple count of how many times this field has changed.
logs: A list of every change, sorted from newest to oldest. Each change includes:
ChangedBy: The name of the user who made the update.
ChangedAtTimestamp: The exact date and time of the change.
ValueFrom: The value of the field before the change.
ValueTo: The value of the field after the change.
Pro-Tip: Getting Value from the JSON String
While the full JSON is great for detailed analysis, you can get quick insights directly in Google Sheets. Since the logs are sorted from newest to oldest, the first entry in the logs array is always the most recent change. For a quick report, you can simply scan the beginning of the string to see the latest ValueTo or ChangedBy without needing complex formulas. For advanced users, this structured data can be parsed with Regex formulas or Google Apps Script for custom reporting.