Nightly Introw commission log to Google Sheets

By General Input

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.

Integrations

  • Introw
  • Google Sheets

Type

Deterministic Code

Categories

  • Finance
  • Operations

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.

Related prompts

Explore more prompts
Call overdue Xero customers with an AI collections agentLocal listing health board for every location you manageLet support send one-off Loops emails without an engineerStop cold emails to anyone with a live deal in PipedriveiMessage campaign console with pre-flight checks and delivery boardLinkedIn Ads budget pacing dashboard for every client accountFront desk appointment confirmation board for the next 3 daysGive your team Looker numbers without buying more seatsBuild audience segments from product usage and push to LoopsTurn the people who engage with your posts into Pipedrive leads