10 Ways to Export Reports from ServiceTitan (And Which Ones Break at Scale)

ServiceTitan's reporting API rate limit is 5 of the same report per minute per tenant. That means if you want to refresh a job-profitability report every 5 minutes across 3 locations, you are already at 60% of your quota on a single report. Running a full dashboard stack brings you to the ceiling fast.

You want reports out of ServiceTitan so you can analyze them without paying for another Phones Pro or Marketing Pro upsell. Here are 10 methods ranked by which ones survive past 500 jobs per month.

1. Manual report export to XLS from the ServiceTitan reports tab

The factory-shipped path. You run a report in ServiceTitan, click export, and get an XLS file.

• Log in to ServiceTitan web app
• Open Reports and pick the report template
• Set date range, location, and filter parameters
• Click Run
• Click Export and choose XLS (or PDF)
• Download the file
• Open in Excel or upload to Google Sheets

Ongoing cost: 1 to 3 hours per week of office-manager time for a full weekly refresh across 5 to 10 reports.

Right for single-location shops that use 3 to 5 canonical reports and do not need daily freshness.

Text Sully: "Give me the same revenue-by-business-unit numbers the weekly report shows."

2. Scheduled email of ServiceTitan reports in PDF or XLS

The hands-off version of method 1. You configure ServiceTitan to email a report on a schedule.

• Open the report in ServiceTitan
• Click the schedule icon
• Choose daily, weekly, or monthly cadence
• Pick PDF or XLS as the output format
• Enter the email distribution list
• Set the time the report generates
• Save the schedule

Ongoing cost: $0 in tooling, 15 minutes of setup per report, and however many hours per week your team spends reading PDFs. The hidden cost is that PDFs are not queryable, and you cannot join them to marketing spend or payroll data without manual re-entry.

Right for ownership-level review where the PDF is the artifact, not the source of further analysis.

Text Sully: "Read my ServiceTitan numbers and tell me what changed since last week."

3. Power BI direct connection to ServiceTitan API

The enterprise reporting move. You build a Power BI dataset that hits ServiceTitan's API on a refresh schedule.

• Confirm your ServiceTitan plan is The Works or Legacy (API access is not on Starter or Essentials)
• Register an app in the ServiceTitan Developer Portal
• Go through the integration approval flow
• Get tenant ID, client ID, client secret, and app keys
• In Power BI desktop, use Web connector with custom headers
• Write Power Query M to paginate through /jobs, /customers, /invoices
• Respect the 60-calls-per-second regular API limit with Table.Buffer and small batch sizes
• Build relational data model across jobs, customers, locations, technicians
• Write DAX measures for revenue, gross profit, capacity utilization
• Publish to Power BI Service and schedule daily refresh

Ongoing cost: $14/user/month for Power BI Pro as of April 2025, plus $5,000 to $25,000 one-time build cost for a consultant, plus 10 to 20 hours per month of DAX and pipeline maintenance.

Right for multi-location shops over $5M with an in-house BI analyst or a retained consultant. The build-vs-buy tradeoff on operational tooling tracks the same logic we covered in AI dispatcher build vs buy for home services.

Text Sully: "Show me revenue by business unit month-over-month and which locations are dragging."

4. Looker Studio via community connector or custom warehouse

The Google-shop path. You either use a community connector or load ServiceTitan data into BigQuery first.

• Option A: Buy a ServiceTitan-to-Looker community connector ($50 to $200/month)
• Option B: Set up Fivetran to BigQuery ($500 to $2,500/month as of January 2026)
• Option C: Self-host Airbyte on a VPS with community-maintained ServiceTitan source
• Define views or dbt models for jobs, invoices, capacity, marketing attribution
• Connect Looker Studio free tier or Pro at $9/user/month
• Build dashboards with filters and scheduled email snapshots

Ongoing cost: $50 to $2,500/month depending on warehouse path, plus $9/user/month for Looker Studio Pro, plus 6 to 15 hours per month of pipeline maintenance.

Right for ops teams already on Google Workspace who want one dashboard source of truth across departments.

Text Sully: "What are my top 10 revenue drivers this quarter across all locations?"

5. Zapier ServiceTitan triggers to Google Sheets or CRM

The automation-platform path. Zapier has a ServiceTitan integration that fires on triggers like new job, new invoice, or customer update.

• Confirm your ServiceTitan plan includes API access
• Create a Zapier account, Professional plan at $49/month for 2,000 tasks
• Build a Zap with ServiceTitan as trigger (new job created, invoice paid)
• Pick Google Sheets, Slack, or another CRM as action
• Map fields explicitly (ServiceTitan has deep nested objects)
• Filter out internal or test tenants
• Enable and monitor for a week

Ongoing cost: $49 to $599 per month for Zapier depending on volume. A full 5-trigger Zapier setup across jobs, invoices, payments, customers, and estimates at 1,000 jobs per month burns 100,000+ tasks, which is the $599 Team tier.

Right for shops that want real-time row writes to Sheets without a warehouse build and have budget room on Zapier.

Text Sully: "What jobs have been booked in the last 24 hours with revenue over $5,000?"

6. Celigo or Workato iPaaS with ServiceTitan pre-built connector

The enterprise iPaaS path. Celigo is a ServiceTitan-certified partner with pre-built flows for common integrations.

• Sign up for Celigo ($599+/month starting tier, typically $1,500 to $3,000 for contractor use cases)
• Activate the ServiceTitan connector
• Pick from pre-built flows (ST to NetSuite, ST to Sage Intacct, ST to custom API)
• Configure field mappings and transformation rules
• Schedule incremental sync cadence
• Set up error notifications and retry logic

Ongoing cost: $1,500 to $5,000 per month for Celigo subscription, plus $5,000 to $25,000 one-time professional services for the flow build.

Right for multi-location HVAC or plumbing shops over $20M moving ServiceTitan data into NetSuite or Sage Intacct for financial consolidation. Overkill for anyone under $10M.

Text Sully: "Match my ServiceTitan invoice totals to my NetSuite revenue and flag the variance."

7. Transactional and Export APIs for bulk historical pulls

ServiceTitan separates transactional APIs (real-time, low volume) from Export APIs (bulk, historical). Export APIs exist specifically for data warehouse loading.

• Provision Export API access through the ServiceTitan Developer Portal
• Use the continuation-token pattern to paginate large result sets
• Pull snapshots of jobs, invoices, payments, and customers into S3 or GCS
• Load into Snowflake, BigQuery, or Redshift
• Build dbt models or SQL views for reporting
• Schedule incremental exports based on modifiedOn timestamps
• Monitor for API version changes

Ongoing cost: $200 to $2,000 per month for warehouse compute and storage, plus 10 to 20 hours per month of pipeline babysitting, plus $15,000 to $50,000 one-time build cost if outsourced.

Right for data-mature shops with a real data engineer who is going to own this pipeline for the next 2 to 5 years.

Text Sully: "Pull the same data my warehouse holds and give me a quick sanity check on this month's numbers."

8. Custom Postman-driven API pull to CSV

The developer-hobbyist path. You write API calls manually in Postman or a script and dump to CSV.

• Import the ServiceTitan Postman collection starter kit
• Authorize with your tenant and app credentials
• Set up environment variables for tokens
• Write requests for /jobs, /invoices, /customers, /business-units
• Export responses as CSV or JSON
• Combine files manually in Excel or Python
• Accept that this is a one-shot effort, not an automation

Ongoing cost: $0 in tooling, 4 to 8 hours per manual run, which means it happens once and then gets abandoned.

Right for one-time investigations where you need to inspect the raw API shape before committing to a real pipeline.

Text Sully: "What are all my jobs from last month with specific fields I care about?"

9. Hire a ServiceTitan consultant like Home Service Engine

The trusted-expert path. You pay a ServiceTitan-certified consultancy to build and maintain your reporting stack.

• Contract with Home Service Engine, Titanpro Technologies, or a similar specialist
• Scope the reports and KPIs you need
• They build custom report templates in ServiceTitan and/or external BI tools
• They train your team on interpretation
• They stay on retainer for ongoing maintenance

Ongoing cost: $3,000 to $10,000 per month retainer plus $10,000 to $40,000 one-time build fee. The Owned and Operated podcast episode 140 with Danny Peavey of Home Service Engine documented exactly this pattern and the ongoing distrust of data that drives demand for the service.

Right for multi-location shops over $10M where getting KPIs wrong costs more than the retainer.

Text Sully: "Do the 5 KPIs my ServiceTitan consultant flagged last quarter look better or worse today?"

10. Skip the export pipeline. Ask Sully.

Sully connects directly to ServiceTitan, ingests your jobs, invoices, customers, and techs, and answers questions in plain language. No dashboard, no warehouse, no PDF.

• Connect Sully to ServiceTitan through the OAuth flow
• Wait for the initial backfill (a few hours for large tenants)
• Text Sully questions about any metric across your business
• Get answers with source links back to the ServiceTitan record
• Set up morning briefs, weekly summaries, or follow-up alerts
• Sully handles the API rate limits, schema drift, and version changes

Ongoing cost: flat subscription pricing without per-report or per-query fees. The same answer that takes a Power BI build 6 months takes Sully under 10 seconds.

Right for contractors under $10M who want answers, not a BI department. The comparison pattern mirrors what we wrote about in ServiceTitan AI vs standalone AI for contractors.

Text Sully: "Give me revenue by business unit, tech utilization, and gross margin on installs for last month in one summary."

Contractor stories from the export trenches

On the Owned and Operated podcast episode 140, John Wilson and Jack Carr hosted Danny Peavey, founder of Home Service Engine, for an episode explicitly titled "Navigating the ServiceTitan KPI Minefield." Peavey's recurring client intake line:

"I don't trust the data, I want to understand how I'm performing."

• Recurring ServiceTitan operator feedback, Owned and Operated #140 with Danny Peavey

These are not small shops. These are multi-location HVAC and plumbing operators paying full ServiceTitan sticker plus $3,000 to $10,000 per month on Peavey's team, and they still do not trust the raw reports.

A ServiceTitan community forum thread titled "Automatically Exporting Data from Reports to Looker Studio" captured a mid-sized electrical contractor's attempt to wire ServiceTitan reports into Looker Studio. The thread documents weeks of back-and-forth about authentication, report-API throttling at 5 of the same report per minute, and eventually an admission that the simplest path was to export to XLS weekly and paste into Sheets.

"I spent 40 hours trying to automate this and the manual path is two hours a week, I'm done fighting the API."

• Mid-sized electrical contractor, ServiceTitan community forum

What actually breaks at scale

Methods 1 and 2 do not break. They just cost your time.

Methods 3 through 7 break when ServiceTitan ships an API change, when your tenant hits the rate limit, or when your BI consultant disappears. The Power BI path (method 3) is the most common failure mode because it looks achievable in a 2-week sprint and takes 6 months in reality. We see the same trap in other build-vs-buy contexts, which is why we keep writing about it.

Method 8 is not a pipeline, it is an investigation. Do not confuse one-shot Postman exports with a reporting system.

Method 9 works but costs real money. It also assumes your consultant stays alive. Danny Peavey's business exists because ServiceTitan reports are complex enough that an entire consultancy layer is profitable.

Method 10 is the honest alternative for $1M to $10M shops. You are not running a BI department. You are running a service business. Sully is the path where the reporting question stops requiring an engineering headcount to answer.

Frequently Asked Questions

What is ServiceTitan's reporting API rate limit?

ServiceTitan caps reporting APIs at 5 of the same report per minute per tenant, and regular APIs at 60 calls per second per application per tenant. That means if you refresh a job-profitability report every 5 minutes across 3 locations, you are already at 60% of quota on a single report. A full dashboard stack hits the ceiling fast.

How much does it cost to build a Power BI dashboard on ServiceTitan?

Power BI Pro is $14 per user per month. The ServiceTitan-to-Power-BI build runs $5,000 to $25,000 one-time for a consultant, plus 10 to 20 hours per month of DAX and pipeline maintenance. A $150K Power BI rebuild is a real number for multi-location HVAC shops, before any ongoing cost.

Can I export ServiceTitan reports to Google Sheets directly?

Only by going through Looker Studio with a community connector ($50 to $200/month) or a warehouse path like Fivetran to BigQuery ($500 to $2,500/month). The warehouse path adds dbt or SQL views plus 6 to 15 hours per month of pipeline maintenance.

Is API access included with every ServiceTitan plan?

No. API access only ships with The Works or Legacy service packages, which start around $250 to $400 per technician per month. If you are on Starter or Essentials, methods 3 through 8 in this post are blocked until you upgrade.

What does a ServiceTitan reporting consultant actually cost?

Consultancies like Home Service Engine or Titanpro Technologies charge $3,000 to $10,000 per month retainer plus $10,000 to $40,000 one-time build fees. Multi-location $10M+ shops routinely pay this because the cost of getting KPIs wrong exceeds the retainer.

Can I skip the export pipeline entirely?

Yes. Sully connects directly to ServiceTitan via OAuth, ingests your jobs, invoices, customers, and techs, and answers questions in plain language. The same answer that takes a Power BI build 6 months takes Sully under 10 seconds. Flat subscription pricing with no per-report or per-query fees.

Sources:

• ServiceTitan API Rate Limits
• ServiceTitan Developer Portal
• ServiceTitan Transactional and Export APIs
• ServiceTitan Pricing 2026
• ServiceTitan Custom Report Scheduling
• Owned and Operated #140 with Danny Peavey
• ServiceTitan Community Forum - Looker Studio Export Thread