Monthly Deel contractor invoice ledger in Google Sheets

On the first business day of every month, pull the previous month's contractor invoices from Deel and append every invoice as a new row to a Google Sheets ledger so finance has a single source of truth for reconciliation.

Trigger: cron, scheduled to fire on the 1st business day of each calendar month in the account's timezone. When it fires, compute the date range for the previous full calendar month (first day 00:00:00 through last day 23:59:59) so the workflow always exports a clean, closed month regardless of exactly when it runs.

Step 1: Call Deel's Retrieve Invoices to list every contractor invoice issued during that previous-month window. Page through results if the response is paginated so no invoices are missed. Filter to invoices where the issue date falls inside the target window.

Step 2: For each invoice, build a row in this fixed column order: invoice ID, contractor name, contract ID, country, currency, gross amount, status, issue date. Format the issue date as YYYY-MM-DD and keep the gross amount as a plain number (no currency symbol) so the sheet stays sortable and formula-friendly.

Step 3: Call Google Sheets' Append Values once with all rows for the month, targeting the user-supplied spreadsheet ID and sheet tab. Append after the last populated row so existing history and any manual columns stay intact. If the month had zero invoices, skip the append and finish silently.

The author should expose three inputs to the user: the destination Google Sheets spreadsheet ID, the sheet tab name (e.g. "Contractor Invoices"), and the monthly run day (default: 1st business day of the month). The workflow is deterministic — no drafting, no judgement, no LLM calls. Every step is a known operation on structured data.