Home Service Data
Back to API docs

Use the data without code.

Send selected Home Service Data fields into spreadsheets, CRMs, and team workflows without writing a backend service.

Google Sheets
Google Sheets

Review CSV responses in calculators and costing sheets.

HubSpot
HubSpot CRM

Attach trusted context to accounts, deals, and tasks.

Airtable
Airtable

Maintain a lightweight operations table from API output.

ZapierMake
Zapier / Make

Route webhooks and scheduled lookups into business tools.

Start with the tool you know.

Pick a tool below, then adapt the fields and approval step to your team, data rights, and access level.

Pull API data into Google Sheets

Use a CSV endpoint to bring finance fees, equipment specs, or utility context into a spreadsheet for analysis and review.

  1. 1Copy the Sheets `=IMPORTDATA()` formula provided at the bottom.
  2. 2Open your target Google Sheet and paste it in cell A1.
  3. 3Replace 'YOUR_API_KEY' with your active sandbox or production key.
  4. 4Use the resulting sheet for internal review before pushing values into a quote workflow.

Build a controlled automation.

Example
application/json
{
  "event": "finance.fees.updated",
  "timestamp": "2026-05-27T10:45:00Z",
  "data": {
    "lender": "Sunlight Financial",
    "product_name": "25-Year 3.99% Low Fee",
    "dealer_fee": 0.185,
    "interest_rate": 0.0399
  }
}
Click copy or adjust selectors to refresh outgoing field values.

Pull data into Google Sheets.

Google Sheets can import CSV endpoints with `=IMPORTDATA()`. Paste this formula in a controlled workbook, then replace the key and query parameters for the dataset you are reviewing.

=IMPORTDATA("https://api.homeservicedata.com/api/v1/finance/fees?format=csv&x-api-key=YOUR_API_KEY")

Need help mapping fields?

Share the target tool, dataset, and access level you are working with. We can help define the field mapping and review step before production use.

Open DashboardTalk to our team