Nightly Introw commission log to Google Sheets for finance

PromptCreate

Build 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.

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.

FAQs

Will voided or canceled commission lines show up in the sheet?

Yes. The run pulls every status, including voided lines, so finance can see exactly what was rolled back during the day.

What if Introw has thousands of commission lines?

The workflow pages through all of them in the background and only writes the ones that actually changed in the last 24 hours, so the sheet stays focused on the day's deltas.

Can I send the rows to a Notion database or Airtable base instead?

Yes. Tell the workflow author which tool you prefer and it will swap Google Sheets for that destination.

Does this overwrite the existing reconciliation history?

No. Each run appends new rows under whatever is already in the tab, so your running log keeps growing day by day.

What happens if a run is missed because of an outage?

The next run still captures its own 24 hour window. If you need to backfill, you can re-run the workflow on demand and ask it to look further back.

Related templates

Call overdue Xero customers with an AI collections agent

Every weekday at 10am, an AI voice agent phones your most overdue Xero accounts, logs what each customer promised, and reports back to finance in Slack.