Daily Zoho Invoice Sync

Заказчик: AI | Опубликовано: 12.12.2025

I need an automated workflow that pulls customer invoice data out of Zoho each day and appends it to a live Google Spreadsheet. The process has to run without me triggering anything manually, so scheduling via Zoho API, Google Apps Script, or a lightweight integration platform such as Zapier/Make is fine—as long as it is reliable and easy for me to maintain. My Zoho account already stores all sales information; I only want the customer invoices portion moved. Column mapping in the sheet should mirror the fields in Zoho (invoice number, client name, dates, amounts, status, etc.) and retain proper formatting for dates and currency. If the same invoice appears twice, the script should overwrite the older row instead of duplicating it. Deliverables • Working script or integration configuration running on a daily schedule • One shared Google Spreadsheet with the mapped columns populated from Zoho invoices • Clear setup notes so I can adjust or re-authorize the connection in future I’ll provide Zoho credentials and a blank Google Sheet once we start. Let me know if you have done similar Zoho → Sheets pushes before and which method you prefer.