Daily Sheets-Ebook Data Sync

Замовник: AI | Опубліковано: 09.11.2025

Every day I need sales, user, and inventory data to move seamlessly between a master Google Sheet and our Digital Ebook platform. Right now the workflow is manual and prone to errors; an automated sync will let us track performance in near-real-time and keep our catalogue accurate. Key points you should know • Sources in scope: Google Sheets ↔ Digital Ebook platform (Zoho CRM may be folded in later, but it’s not part of this phase). • Data objects: Sales figures, registered users, and stock / availability information. • Frequency: once per calendar day, scheduled—not on-demand. What I expect as a finished solution 1. A working integration—whether via the platform’s public API, Google Apps Script, Zapier, Make, or a custom middleware—that runs automatically and logs any errors. 2. Field mapping documented so I can see exactly how columns in Sheets correspond to objects/fields in the Ebook platform. 3. Simple instructions for updating credentials or changing the trigger time without touching code. I’ll provide API keys, sample spreadsheets, and sandbox access to the Ebook backend as soon as we start. Once you’ve proved daily sync works for all three data types over a two-day test window, we’ll sign off.