Daily Zoho CRM deal pipeline sync to Google Sheets

Every morning at 6am, mirror my entire Zoho CRM Deals pipeline into a designated Google Sheets tab so finance, ops, and execs can build dashboards and pivot reports without burning a CRM seat. This is a deterministic paginate, fetch, format, and write pipeline with no judgment calls, so please build it as a code workflow with discrete nodes.

Trigger: cron, daily at 6:00am in my local timezone.

Step 1. Use the Zoho CRM Get Records operation on the Deals module to pull every open and recently closed deal. Paginate through all results. For datasets above 2,000 records, switch from page-based pagination to page_token pagination using the next_page_token returned in the response info. Request only this fixed field set: Deal_Name, Account_Name, Owner, Stage, Amount, Probability, Closing_Date, Created_Time, Modified_Time, Last_Activity_Time, Lead_Source, and Pipeline.

Step 2. Normalize each record into a flat row with stable column ordering matching the field set above. Owner should be the owner name. Account_Name should be the account name. Dates should be written in a spreadsheet-friendly format that Google Sheets parses as a date or datetime.

Step 3. In Google Sheets, use Batch Update Spreadsheet to clear the existing data range on the designated tab while preserving the header row in row 1. The destination spreadsheet ID and tab name should be configurable inputs to the workflow.

Step 4. Use Update Values to write the fresh, normalized rows starting at A2 with valueInputOption USER_ENTERED so dates and numbers render natively.

Step 5. Write the run timestamp into cell A1 as a cell note (not a value, to preserve the header text), so consumers can confirm data freshness at a glance.

Keep the field list, spreadsheet ID, tab name, and run time exposed as configurable inputs so they can be edited without touching the workflow code.