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 Excel workbook. 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 Excel workbook. 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 worksheet in one operation.
Get Wrike history for folder 12345678 tasks and populate this Excel sheet with change records: Task Title, Field, Previous Value, New Value, User Name, Timestamp
What You Get
- Every field-level change event for every task in the folder written into the workbook.
- Columns: task title, field changed, previous value, new value, user name, timestamp.
- 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 specific task IDs, not all tasks in a folder
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
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" worksheet — then write a summary in the "Summary" worksheet 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 workbook, then ask it to pull the full modification history from Wrike before your client delivery deadline. Also see bulk creating tasks from a workbook or the Wrike hub.