The Scenario
The audit request landed in your inbox on a Tuesday. You're the data-ops manager at a financial services firm, and the compliance team needs a report showing every Kadoa workflow that ran in the past 90 days — how many validation anomalies each one produced, which validation rules were disabled, and who made those changes. They need it by end of week for sign-off.
Kadoa's activity log exists, but it's paginated inside the platform's UI. There's no "export this to a spreadsheet" button. You know you can call the API. You also know that writing the script to paginate the log, join it against the validation rule status, and format it into the compliance template will eat most of your Thursday.
The bad version:
- Scroll through Kadoa's activity log page by page, taking notes on which workflows ran and when.
- Cross-reference each workflow name against the validation rules screen to check which rules are enabled or disabled, then type the status into a separate sheet tab by hand.
- Realize on Thursday afternoon that you missed the workflows that were archived mid-quarter and have to start the cross-reference over.
The compliance team's deadline doesn't care about any of this. A report that's 80% complete by Friday morning is not a report.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It connects to Kadoa, reads the activity log API, and writes the structured output to your sheet in whatever format the compliance template requires.
The prompt for this task:
Export the Kadoa activity log for the past 90 days to this sheet, one row per event, with columns for timestamp, workflow name, event type, and user email.
What You Get
- One row per activity event, written to the sheet in chronological order.
- Columns for timestamp (ISO 8601), workflow name, event type (run started, run completed, rule disabled, workflow archived, etc.), and the user email associated with the event.
- The sheet ready to hand to the compliance team without reformatting — column headers matching the audit template they provided.
- Events from archived workflows included, so nothing that ran in the 90-day window is silently missing.
What If the Data Is Not Quite Ready
You also need validation rule status consolidated into the same report
The compliance team wants the anomaly counts and any disabled rules in the same sheet, not a separate export:
Export the Kadoa activity log for the past 90 days to columns A through D of this sheet, one row per event. Then in a second pass, list all validation rules across all workflows in columns F through I — rule ID, workflow name, current status, and disable reason if applicable.
The report needs to be filtered by a specific set of workflow IDs
The audit scope covers only the workflows tagged for the "financial-data" project:
Export the Kadoa activity log for the past 90 days, but filter to only events belonging to workflow IDs in column A of my 'Scope' tab. Write the results to the 'Audit Log' tab with columns for timestamp, workflow name, event type, and user email.
You need anomaly counts per workflow, not raw events
The compliance format wants one row per workflow with a summary, not the raw event stream:
For each Kadoa workflow that ran in the past 90 days, write one summary row to this sheet: workflow name, total runs, total validation anomalies, count of disabled rules, and date of most recent run.
Full pipeline: pull the log, flag anomaly spikes, and mark workflows that had rules disabled during the period
Export the Kadoa activity log for the past 90 days to columns A–D, one row per event. Then compute a summary in columns F–J: workflow name, total anomaly events, whether any validation rule was disabled in this period (yes/no), the disable reason, and the user who disabled it. Sort the summary by total anomaly events descending.
The audit report assembles itself — raw log plus summary, sorted by risk, in a single prompt.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet set up as a compliance or audit template, then ask it to pull the Kadoa activity log for whatever time window you need. For related reading, see how to trigger ad-hoc URL extractions from a sheet or the Kadoa overview.