Automate SigmaNEST-Sheets Sync
Budget: $30 – $250 USD
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.
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.
Related categories:
Python
Linux
Software Architecture
MySQL
Data Integration
Automation
Database Management
API Development