Find your top 3 most profitable services in under 5 minutes and make smarter pricing decisions that add $500+/month in profit.
~3 hrs
Saved / wk
Advanced
Setup
AI-Assisted
AI
This workflow pulls completed job data and costs from QuickBooks Online into a simple report that ranks each service type by profit margin. You see which services make you the most money and which ones you might want to reprice or drop. It runs automatically on the first of each month so you always have fresh numbers.
~3 hrs
Saved / Week
Professional setup recommended
Setup Complexity
AI Status
Destination
Step 1: Make sure every job in QuickBooks Online is tagged with a service type (e.g., 'HVAC tune-up', 'drain cleaning')
Step 2: Connect QuickBooks Online to Metabase using Make to sync completed job revenue and costs
Step 3: Build a Metabase report that groups jobs by service type and calculates profit margin for each
Step 4: Use ChatGPT (an AI assistant) via Make to write a plain-English summary of the report each month
Step 5: Schedule the report to run on the 1st of each month and email it to you automatically
Step 6: Review the summary and adjust your pricing or marketing focus for the next month
Upgrade to Plus for AI-powered step-by-step guides
See PlansChatGPT is an AI-powered assistant built by OpenAI that helps you write content, answer questions, analyze data, generate images, and automate everyday tasks through a conversational interface. It works on web, desktop, and mobile, and connects with 60+ business apps on its Team and Business plans. The free plan handles basic writing and research. The $20/month Plus plan unlocks image generation (DALL-E), video creation (Sora), deeper reasoning, file analysis, and Deep Research mode for multi-source reports. Over 300 million people use ChatGPT weekly. Custom GPTs let you build mini AI apps tailored to your specific workflows.
Most widely used US small business accounting. Invoicing, expense tracking, payroll, tax prep, and financial reporting. Intuit Assist AI automates invoices, reminders, and cash flow insights. 750+ integrations. Solopreneur: $20/month. Simple Start: $38/month. Plus: $105/month. No free tier.
Visual workflow automation connecting 3,000+ business apps. Build multi-step automations with branching logic, data transformation, and error handling — all by dragging and dropping on a visual canvas. Formerly Integromat. Free: 1,000 credits/month. Core: $9/month. Pro: $16/month. SOC 2 and GDPR compliant.
Open-source business intelligence — explore data, build dashboards, and answer questions without writing SQL. Self-host free or use managed cloud. Connects to your databases and turns raw data into charts, reports, and alerts. Open source: free (unlimited). Starter cloud: $85/month. Metabot AI: $100/month add-on.
