Nightly Introw commission log to Google Sheets
Every weekday at 6pm ET, drop the last 24 hours of Introw commission changes into a Google Sheets register so finance has a clean audit trail.
Introw
Google SheetsFinanceOperationsData SyncBuild me a deterministic code workflow that runs on a cron schedule every weekday at 6pm Eastern Time and exports the last 24 hours of Introw commission line activity into a Google Sheets register that our finance team uses for reconciliation.
Step 1. Call Introw List Commission Lines with no status filter so EXPECTED, PENDING, IN_PAYOUT, and VOIDED lines all come back. Paginate by following nextCursor on each response and stop when nextCursor is null. Use the maximum page size.
Step 2. Filter the collected lines client side to only those whose updated_at falls within the last 24 hours from the run time. Sort the kept lines by updated_at ascending so the spreadsheet reads in chronological order.
Step 3. Map each kept line to a row with exactly these columns in this order: commission line id, partner id, partner name, amount, currency, status, payout id, description, source amount, internal note, updated_at. Leave a cell blank if the field is missing rather than dropping the row.
Step 4. Call Google Sheets Append Values to append those rows to a configured spreadsheet and tab. The spreadsheet id and tab name should be workflow inputs. Use USER_ENTERED as the value input option so amounts and timestamps render correctly. If there are zero matching rows for the window, skip the append call and finish cleanly.
No summarization, no judgement, no AI rewriting. This is a structured nightly drop of the day's commission deltas for the finance team's audit trail. Keep the pipeline fixed and the I/O strictly structured.
Additional information
What does this prompt do?
- Runs automatically every weekday at 6pm Eastern with no manual steps.
- Pulls every Introw commission line that changed in the last 24 hours, across every status (expected, pending, in payout, and voided).
- Appends one tidy row per change to a Google Sheet tab finance already uses for reconciliation.
- Captures the full picture in each row: line id, partner, amount, currency, status, payout id, description, source amount, internal note, and the time it was last updated.
What do I need to use this?
- An Introw account with an API key that can read partners and commissions.
- A Google account that can edit the spreadsheet where finance keeps the commission register.
- The spreadsheet link and the name of the tab where new rows should land.
How can I customize it?
- Change the run time or run on weekends if your finance close happens daily.
- Switch the destination spreadsheet or tab, or point it at a brand new sheet for the next quarter.
- Adjust the look-back window if you would rather capture 12 hours or a full week per run.
- Add or remove columns to match the exact layout your reconciliation workbook expects.
Frequently asked questions
Will voided or canceled commission lines show up in the sheet?
What if Introw has thousands of commission lines?
Can I send the rows to a Notion database or Airtable base instead?
Does this overwrite the existing reconciliation history?
What happens if a run is missed because of an outage?
Related templates
Give finance a clean commission audit trail without lifting a finger.
Connect Introw and Google Sheets once, then let this run every weekday evening so the reconciliation log writes itself.