SQL-Sheets Sync & Alerts
Budget: ₹12,500 – ₹37,500 INR
I need a reliable workflow that pulls Sales, Customer, and Inventory data from my Microsoft SQL Server into both Google Sheets and Excel on an automatic schedule. Once the feed is live, I want the data modeled and visualized in Google Data Studio so I can slice performance by product line, customer segment, and time period without manual intervention.
The last piece is real-time, rule-based notifications that reach mobile devices—push or SMS—whenever metrics cross predefined thresholds (for example, daily sales drop below target, inventory hits a reorder point, or a new high-value customer signs up).
Deliverables:
• Scripted or no-code connector that syncs SQL Server to Google Sheets and an Excel workbook on OneDrive/SharePoint, running at set intervals.
• A clean data layer (views or transformations) ready for Google Data Studio, with reusable dimensions and measures.
• At least three sample Data Studio dashboards showing sales trends, customer cohorts, and inventory status.
• Trigger logic and integration (Apps Script, Zapier, Power Automate, or similar) that pushes mobile alerts, plus documentation on how to adjust thresholds.
Acceptance criteria:
– Sync completes without errors for two consecutive cycles.
– Dashboards refresh automatically from the live Sheets data.
– Mobile notifications fire on test conditions and include dynamic values (e.g., “Inventory for SKU 123 is now 15 units”).
Please outline your proposed tech stack and timeline so we can get moving quickly.
The last piece is real-time, rule-based notifications that reach mobile devices—push or SMS—whenever metrics cross predefined thresholds (for example, daily sales drop below target, inventory hits a reorder point, or a new high-value customer signs up).
Deliverables:
• Scripted or no-code connector that syncs SQL Server to Google Sheets and an Excel workbook on OneDrive/SharePoint, running at set intervals.
• A clean data layer (views or transformations) ready for Google Data Studio, with reusable dimensions and measures.
• At least three sample Data Studio dashboards showing sales trends, customer cohorts, and inventory status.
• Trigger logic and integration (Apps Script, Zapier, Power Automate, or similar) that pushes mobile alerts, plus documentation on how to adjust thresholds.
Acceptance criteria:
– Sync completes without errors for two consecutive cycles.
– Dashboards refresh automatically from the live Sheets data.
– Mobile notifications fire on test conditions and include dynamic values (e.g., “Inventory for SKU 123 is now 15 units”).
Please outline your proposed tech stack and timeline so we can get moving quickly.