Make.com Integration

Automate U.S. surplus lines tax calculations in your Make.com scenarios. Connect the Surplus Lines Tax API to 1,500+ apps with a powerful visual workflow builder.

Why Use Make.com Integration?

• Visual Workflow Builder — Design automations with an intuitive drag-and-drop interface
• 1,500+ App Integrations — Connect to Google Sheets, Slack, Airtable, databases, and more
• Advanced Logic — Built-in routers, filters, iterators, and error handlers
• Real-Time Processing — Instant triggers via webhooks for immediate calculations
• Batch Operations — Process multiple policies efficiently with iterators
• Powerful Scheduling — Automate rate updates and batch calculations on your schedule

Prerequisites

Before using the Make.com integration, ensure you have:

1. Make.com Account

   Free or paid Make.com account. Sign up at make.com

2. Surplus Lines Tax API Key

   Get your API key at app.surpluslinesapi.com. New accounts include 100 free queries.

3. Connected Apps (Optional)

   Depending on your use case, you may need connections to Google Sheets, webhooks, databases, or other apps.

How It Works

The Make.com app connects your scenarios to the Surplus Lines Tax API with three modules:

Installation

The Surplus Lines Tax API app is available in the Make.com app directory and ready to use in your scenarios.

Quick Start

1. Log in to your Make.com account at make.com
2. Click Create a new scenario
3. Search for "Surplus Lines Tax API" in the module selector
4. Add the module to your scenario
5. Configure your API credentials (see Configuration below)

Configuration

Step 1: Create API Connection

1. In your scenario, add a Surplus Lines Tax API module
2. Click Add next to the Connection field
3. Enter a connection name (e.g., "Surplus Lines API")
4. Paste your API key from app.surpluslinesapi.com
5. Click Save

Step 2: Configure Module

1. Select your connection from the dropdown
2. Choose the module operation (Calculate Tax, Search Rates, or Get States)
3. Map input fields from previous modules or enter values manually
4. Click OK to save the module

Testing the Integration

Quick Test Scenario

1. Create a new scenario
2. Add a Tools → Set Variable module with test data:
   • state: Texas
   • premium: 10000
3. Add the Surplus Lines Tax API → Calculate Tax module
4. Map the state and premium variables
5. Click Run once

Expected Result: You should see tax calculation output with Texas tax ($485), stamping fee ($18), and total due ($10,503).

Template: Google Sheets Tax Calculator

Automatically calculate surplus lines taxes for new rows in Google Sheets. Perfect for batch processing policies.

How It Works

Required Google Sheet Columns

• State - State name (e.g., "Texas")
• Premium - Premium amount
• Tax Amount - Calculated tax (auto-filled)
• Total Due - Grand total (auto-filled)
• Status - Success/Error message (auto-filled)

Setup Steps

1. Click "Use This Template" above
2. Connect your Google Sheets account
3. Connect your Surplus Lines API key
4. Select your Google Sheet and worksheet
5. Turn the scenario ON

Template: Daily Tax Rate Sync

Automatically update a Google Sheet with the latest surplus lines tax rates for all states. Runs daily to keep your rates current.

How It Works

Google Sheet Structure

Creates/maintains a sheet with these columns:

• State - State name
• Rate - Current tax rate (%)
• Stamping Fee - Stamping fee rate (%)
• Last Updated - Timestamp of sync

Setup Steps

1. Click "Use This Template" above
2. Connect your Google Sheets account
3. Connect your Surplus Lines API key
4. Create a new Google Sheet with headers: State | Rate | Stamping Fee | Last Updated
5. Select your Google Sheet in the scenario
6. Turn the scenario ON

Template: Webhook-Based Calculator

Real-time tax calculations via webhook API. Perfect for integrating with external systems, apps, or custom forms.

How It Works

Webhook Request Format

POST https://hook.us2.make.com/YOUR-WEBHOOK-ID
Content-Type: application/json

{
  "state": "Texas",
  "premium": 10000
}

Success Response (200)

{
  "success": true,
  "data": {
    "state": "Texas",
    "premium": 10000,
    "totalTax": 489,
    "totalDue": 10489,
    "taxBreakdown": {
      "surplusLinesTax": 485,
      "taxRate": 0.0485,
      "stampingFee": 4,
      "stampingFeeRate": 0.0004
    }
  }
}

Error Response (400)

{
  "success": false,
  "error": "Invalid state provided",
  "message": "Invalid state or premium value provided"
}

Error Handling: The scenario includes an error handler that catches invalid inputs (e.g., invalid state names, negative premiums) and returns a properly formatted error response with HTTP 400 status code.

Setup Steps

1. Click "Use This Template" above
2. Connect your Surplus Lines API key
3. Copy the webhook URL from the trigger module
4. Turn the scenario ON
5. Test with cURL or Postman using the request format above

Module: Calculate Tax

Calculate surplus lines tax for any U.S. state and premium amount with detailed breakdowns.

Required Parameters

Optional Parameters

Example Output

{
  "State": "Texas",
  "State Code": "TX",
  "Premium": 10000,
  "Total Tax": 489,
  "Total Due": 10489,
  "Tax Breakdown": {
    "Surplus Lines Tax": 485,
    "Tax Rate": 0.0485,
    "Stamping Fee": 4,
    "Stamping Fee Rate": 0.0004
  }
}

Module: Search Rates

Retrieve current tax rates for all U.S. states and territories, or filter by a specific state.

Optional Parameters

Returns

Array of rate objects, each containing:

• State name
• Surplus lines tax rate (%)
• Stamping fee rate (if applicable)
• Special rules and notes

Example Output

{
  "success": true,
  "request_id": "req-1770111587080-zv53yfmdb",
  "count": 53,
  "data": [
    {
      "state": "Alabama",
      "state_code": "AL",
      "tax_rate": "6%",
      "stamping_fee": null,
      "filing_fee": null,
      "service_fee": null,
      "surcharge": null,
      "regulatory_fee": null,
      "fire_marshal_tax": null,
      "slas_clearinghouse_fee": null,
      "flat_fee": null,
      "special_notes": null,
      "payment_frequency": "Annually",
      "legislative_source": "https://law.justia.com/codes/alabama/..."
    },
    {
      "state": "Texas",
      "state_code": "TX",
      "tax_rate": "4.85%",
      "stamping_fee": "0.04%",
      "filing_fee": null,
      "service_fee": null,
      "surcharge": null,
      "regulatory_fee": null,
      "fire_marshal_tax": null,
      "slas_clearinghouse_fee": null,
      "flat_fee": null,
      "special_notes": null,
      "payment_frequency": null,
      "legislative_source": "https://statutes.capitol.texas.gov/..."
    }
    // ... remaining 51 states
  ],
  "account": {
    "balance": "9.62",
    "free_queries_remaining": 0,
    "was_free_query": false
  }
}

Module: Get States

Get a list of all supported U.S. states and territories as 2-letter postal codes.

Parameters

None required.

Returns

Array of 2-letter postal codes for all 50 states plus District of Columbia, Puerto Rico, and U.S. Virgin Islands.

Example Output

[
  "AL",
  "AK",
  "AZ",
  ...
  "TX",
  ...
  "WY"
]

Module: Get Historical Tax Rate

Look up tax rates that were in effect on a specific date. Perfect for policy audits, renewals, and historical compliance verification.

Parameters

Example Output

[
  {
    "success": true,
    "state": "Texas",
    "state_code": "TX",
    "query_date": "2024-01-02",
    "rate": {
      "tax_rate": "0.0485",
      "stamping_fee": "0.0004",
      "filing_fee": "0.0000",
      "service_fee": "0.0000",
      "surcharge": "0.0000",
      "regulatory_fee": "0.0000",
      "fire_marshal_tax": "0.0000",
      "slas_clearinghouse_fee": "0.0000",
      "flat_fee": "0.00",
      "effective_from": "2024-01-01T00:00:00.000Z",
      "effective_to": null,
      "legislative_source": "https://statutes.capitol.texas.gov/docs/IN/htm/IN.225.htm",
      "confidence": "unknown"
    },
    "account": {
      "balance": "0.00",
      "free_queries_remaining": 408,
      "was_free_query": true
    }
  }
]

Use Cases

• Policy Audits — Verify taxes were calculated correctly using rates in effect at policy inception
• Renewals — Compare current rates to prior year rates for renewal quotes
• Compliance — Document historical rate information for regulatory filings
• Retroactive Calculations — Calculate taxes for backdated policies

Troubleshooting

"Connection failed" error

Your API key is invalid or expired. Verify your key at app.surpluslinesapi.com.

"Insufficient balance" error

Your account balance is depleted. Add funds at app.surpluslinesapi.com.

"Invalid state" error

Check the state name spelling. Use full names (e.g., "Texas") or standard abbreviations (e.g., "TX").

Scenario not triggering

• Verify scenario is ON (toggle in top-right corner)
• Check webhook URL is correct (for webhook triggers)
• For Google Sheets triggers: verify polling interval (not instant)
• Check scenario execution history for errors

Getting Help

Contact us at support@undtec.com for assistance.

Pricing

Make.com integration usage follows the same pricing as the REST API:

Get Your API Key View Full Documentation