I want to turn a patchwork of manual updates into a smooth, fully-coded business process automation that keeps my sales dashboard current in real time. Right now data from the CRM, spreadsheets, and web forms has to be copied, cleaned, and pasted before management sees it; I’d prefer to trigger the whole chain automatically the moment a new deal is logged. What I need coded • A workflow that pulls fresh deal data from the CRM (HubSpot & Salesforce APIs are both available), merges it with weekly revenue numbers in Google Sheets, and pushes the results into our existing Power BI dashboard. • Automated status updates that fire a Slack or Teams message to the sales reps and managers when key metrics—pipeline value, win rate, or quota attainment—cross predefined thresholds. • A simple admin panel or config file where non-technical staff can change thresholds, add new data sources, or pause the workflow. Technical preferences Python or Node.js make the most sense for us, but if you can demonstrate the same result with Zapier, Make (Integromat), or similar iPaaS tools I’m open to that approach. The code should live in our private GitHub repo, run on AWS Lambda (or a small container), and include clear README instructions so we can redeploy it ourselves. Acceptance criteria 1. End-to-end demo showing a new deal entered in the CRM and the dashboard reflecting the change within five minutes. 2. Error handling and logging that captures any failed API call and alerts an admin email. 3. Documentation that covers environment setup, API keys, and how to add a new metric. If your expertise lines up with building reliable, maintainable automations, let’s talk timeline and milestones.