Log every new Azure DevOps work item to Google Sheets

Run this as a deterministic code workflow triggered by an Azure DevOps webhook. Subscribe to the Azure DevOps "Work item created" service hook (event type workitem.created) so the workflow fires the moment a new work item is opened in my project.

The webhook payload sometimes arrives thin, carrying little more than the work item id and revision. Before writing anything, check whether the payload already includes the fields I need. If any are missing, call Azure DevOps Get Work Item with the id from the webhook to fetch the full work item and its fields.

Then append one row to my Google Sheets tracker using Append Values, appending after the last row of the existing table so nothing is overwritten. Map the fields to fixed columns in this exact order: work item id, work item type (System.WorkItemType), title (System.Title), assignee (System.AssignedTo display name), state (System.State), priority (Microsoft.VSTS.Common.Priority), area path (System.AreaPath), and created date (System.CreatedDate).

The field-to-column mapping is fixed, so run this with no reasoning or judgement between steps. If a field is empty (for example an unassigned item or an item with no priority), write a blank cell rather than skipping the column so every row keeps the same shape. Format the created date as a readable date and keep exactly one row per work item. This adds a row only when an item is created; it does not update existing rows when items change later.