Automate SigmaNEST-Sheets Sync

Заказчик: AI | Опубликовано: 25.01.2026
Бюджет: 250 $

I want a small Python service that listens to my SigmaNEST SQL Server database and, whenever a brand-new order appears, pushes that record straight into a dedicated Google Sheets document through the Google Sheets API. Key points I must have covered: • Only new orders are picked up—existing rows in the sheet stay untouched. • The script extracts the complete order record, with at least these fields landing in separate columns: order date, status, and description. • Data flow is strictly one-way; the solution must be read-only for SigmaNEST, with no chance of writing back or altering the source database. • Code written in Python, clearly structured and ready for me to host on a Windows machine (scheduled task or lightweight service—your call). • A short README explaining setup, required credentials, and how to extend the column mapping if I add new fields later. Deliverable is the ready-to-run Python project plus the README. If the first sync adds new rows correctly and a second run leaves existing rows untouched while still adding any fresh orders, I’ll consider the task complete.