Log every IdentityCheck verification decision in a Google Sheets audit log
Each time IdentityCheck sends the result of a KYC verification, this workflow adds it to a Google Sheets row, building an audit log of verification decisions your compliance team can review and export.
IdentityCheck
Google Sheets2 steps Setup ~5 min Used on 2.3k sites Free to import
What this workflow does
When you verify customers' identities, someone usually needs a record of each decision outside the verification tool, for audits, disputes or a monthly compliance review. Pulling those results together by hand is slow. This workflow writes each decision to a spreadsheet as it arrives.
The IdentityCheck trigger is Verification Decision, which per FlowMattic's catalog fires when the KYC process sends its results. Every decision starts a run, whatever the outcome, so approvals and rejections both reach the log. The result's details become values to map.
The Google Sheets step adds a new row with the values you map to each column, such as the person or reference, the decision and the time it was made, depending on what your test run shows. Rows are only ever added, so a person verified twice appears twice, giving you the full history.
Identity results are personal data. Keep the sheet's sharing limited to the people who need it, and only map the fields your audit requires.
Fintech onboarding audit trail
A lending startup keeps a sheet of every customer verification result, so the compliance officer can answer an auditor's question without exporting reports.
Marketplace seller checks
A marketplace that verifies sellers before payouts logs each IdentityCheck decision, so the operations team can see who was approved and when.
Reviewing rejected checks
A support lead sorts the sheet by decision each week to look at rejected verifications and follow up with customers who may need to try again.
How this workflow runs
What happens at each step once the workflow is on, and what you need before you import it.
IdentityCheck Verification DecisionFires when IdentityCheck sends the results of a KYC verification. Approvals, rejections and any other decision all start a run and pass their details on.
- Google Sheets Add New Row
Records the decision as a new row in the Google Sheets spreadsheet you choose. Map the verification details to columns and connect your Google account.
What you need
- FlowMatticCore
- IdentityCheck AccountAccount
- Google Sheets AccountAccount
After importing, map your own data. To keep the template universal, not every step is pre-filled. Open each step in the builder and connect your accounts and fields (channels, lists, sheets, recipients) before you switch the workflow on.
Make it yours
Changes worth making after you import it.
- Keep the decision in a column of its own, so you can filter the audit log by outcome in Google Sheets when a reviewer asks for rejections only.
- Want alerts on rejected checks? Add a Filter after the Sheets step that continues only when the decision is a rejection, followed by a Slack or email step.
- Map only the fields your audit needs. Leaving out document images or extra personal details keeps the sheet smaller and limits what is shared.
Questions about this workflow
Are rejected IdentityCheck verifications logged too?
Yes. The Verification Decision trigger fires for each result the KYC process sends, so every outcome gets its own row.
What happens if a customer is verified more than once?
Each decision adds a new row. The sheet keeps every attempt rather than overwriting the earlier one, which suits an audit log.
Which IdentityCheck details can go into the sheet?
Whatever the decision event carries. Run one verification after import, then map the values it shows to your sheet's columns.
Can I keep the log inside WordPress instead of Google?
Yes. Replace the Google Sheets step with a FlowMattic Tables step, which stores the rows on your own site.
More Spreadsheets & Data workflows
Other ready-to-import templates from the same category.
Import this workflow into your WordPress site
Download the JSON, import it from the Workflows screen and connect your accounts. Every run stays on your server, with no per-task fees.
30-day money-back guarantee Unlimited workflows and runs Self-hosted