The Scenario
A client is requesting a formal change log for a 50-task Wrike project — who changed what, from which value to which, and when. The contract requires it. The project ran for 90 days. You have no idea how you're going to produce this without opening each task individually and reading through the history panel.
The bad version:
- Open the first task. Click on the history icon. Read through the modification events — field changed, old value, new value, timestamp, user. Copy each event into a text document.
- Open the second task. Repeat.
- Fifty tasks, some with a dozen history events each. You've been doing this for an hour and you're on task 11.
- Paste everything into the Google Sheet. Realize the timestamps from Wrike's history panel show in your local timezone, but the contract requires UTC. Fix every timestamp by hand.
The client doesn't care that the data was hard to get. They care that the change log is accurate and delivered on time.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It queries Wrike's task history API for all tasks in a folder and writes every modification event — field, old value, new value, user, timestamp — into your sheet in one operation.
Fetch modification history for all Wrike task IDs listed in column A and write: Task Name, Field Changed, Old Value, New Value, Changed By, Changed Date into this sheet
What You Get
- Every field-level change event for every task in column A written into the sheet.
- Columns: task name, field changed, old value, new value, changed by, changed date.
- Timestamps in a consistent format.
- A complete audit trail the client can review without further data work on your end.
What If the Data Is Not Quite Ready
You need history for all tasks in a folder, not just those with IDs in the sheet
Get Wrike history for all tasks in folder 12345678 and populate this sheet with change records: Task Title, Field, Previous Value, New Value, User Name, Timestamp — sorted by timestamp ascending
You only want status and due date changes, not every field
Fetch modification history for all tasks in Wrike folder 12345678 and write Task Name, Field Changed, Old Value, New Value, Changed By, and Changed Date into this sheet — filter to only rows where the field changed is "Status" or "Due Date"
You need to filter to a specific date range to match the contract period
Pull Wrike task modification history for all tasks in folder 12345678 where the change date falls between the dates in cells A1 and B1 — write Task Name, Field Changed, Old Value, New Value, Changed By, Changed Date into this sheet
Client-ready change log in one shot
Fetch modification history for all tasks in Wrike folder 12345678 from the past 90 days, filter to status and due date changes only, sort by task name then timestamp, write Task Name, Field Changed, Old Value, New Value, Changed By, Changed Date into the "Change Log" tab — then write a summary in the "Summary" tab counting changes per user and per field type
One prompt produces both the detailed log and the executive summary.
Try It
Get the 7-day free trial of SheetXAI and open your project change log sheet, then ask it to pull the full modification history from Wrike before your client delivery deadline. Also see bulk creating tasks from a sheet or the Wrike hub.