Beginner
15 min
Zapier
Make

Connect Airbnb Data API to Zapier and Make

Automate STR data workflows with no-code platforms. Pull revenue estimates, send emails, and update spreadsheets automatically.

1

Create a New Zap or Scenario

Start by creating a new automation in your preferred platform. Both Zapier and Make support HTTP request modules that work perfectly with the AirROI API.

In Zapier, click Create Zap from your dashboard. Choose a trigger app that will kick off your automation — for example, “Schedule by Zapier” for recurring runs, or “Google Sheets” to react to new rows.

Configure your trigger and test it to make sure Zapier can pull sample data before moving on.

2

Add an HTTP Request Action

Now add the action that will call the AirROI API. Both platforms have built-in HTTP modules for making raw API requests.

Search for “Webhooks by Zapier” in the action step. Select Custom Request as the event type. This lets you make a raw HTTP GET request to any URL with custom headers.

3

Configure the API Request

Set up the HTTP request with the AirROI API endpoint, your API key header, and the query parameters for the property you want to estimate.

Configure your Webhooks by Zapier Custom Request with these settings:

zapier

Method:  GET
URL:     https://api.airroi.com/calculator/estimate

Headers:
  X-API-KEY    your-api-key

Query String Params:
  lat          34.052235
  lng          -118.243683
  bedrooms     2
  baths        1
  guests       4

You can also use dynamic values from your trigger. For example, if your trigger is a Google Sheets row, map the lat/lng/bedrooms columns to these fields.

4

Test and Parse the Response

Run a test to verify the API call works and see the response fields you can map to downstream actions.

Click Test step in Zapier. You should see a JSON response. Zapier automatically flattens nested fields so you can reference them directly in later steps.

The key response fields you will want to map are:

json

{
  "revenue": 52400,
  "average_daily_rate": 195,
  "occupancy": 0.74,
  "percentiles": {
    "revenue": {
      "avg": 52400,
      "p25": 38200,
      "p50": 49800,
      "p75": 62500,
      "p90": 78100
    },
    "average_daily_rate": {
      "avg": 195,
      "p25": 155,
      "p50": 189,
      "p75": 230,
      "p90": 285
    },
    "occupancy": {
      "avg": 0.74,
      "p25": 0.58,
      "p50": 0.72,
      "p75": 0.85,
      "p90": 0.93
    }
  },
  "currency": "usd"
}

5

Connect an Output Action

Now route the API response to a useful destination. Here are three common examples you can set up in minutes.

Google Sheets — Add a row with results

field mapping

Column A (Address):    {{trigger.address}}
Column B (Revenue):    {{step2.revenue}}
Column C (ADR):        {{step2.average_daily_rate}}
Column D (Occupancy):  {{step2.occupancy}}
Column E (P75 Rev):    {{step2.percentiles.revenue.p75}}
Gmail — Send results via email

email template

To:      {{trigger.agent_email}}
Subject: Revenue Estimate for {{trigger.address}}

Body:
Estimated Annual Revenue: ${{step2.revenue}}
Average Daily Rate: ${{step2.average_daily_rate}}
Occupancy Rate: {{step2.occupancy}}

Revenue Range:
  Conservative (P25): ${{step2.percentiles.revenue.p25}}
  Moderate (P50): ${{step2.percentiles.revenue.p50}}
  Optimistic (P75): ${{step2.percentiles.revenue.p75}}
Slack — Post to a channel

slack message

Channel: #str-leads

Message:
New estimate for {{trigger.address}}:
  Revenue: ${{step2.revenue}}/yr
  ADR: ${{step2.average_daily_rate}}/night
  Occupancy: {{step2.occupancy}}

6

Example: CRM Lead to Revenue Email

Here is a complete end-to-end automation: when a new lead appears in your CRM spreadsheet, automatically estimate the property's Airbnb revenue and email the results to the assigned agent.

Complete automation flow

automation

TRIGGER: Google Sheets > New Row
  Spreadsheet: "CRM Leads"
  Worksheet:   "New Leads"
  Columns:     address | bedrooms | baths | guests | agent_email

ACTION 1: HTTP GET > AirROI Revenue Estimate
  URL: https://api.airroi.com/calculator/estimate
  Headers:
    X-API-KEY: your-api-key
  Query Params:
    address:  {{trigger.address}}
    bedrooms: {{trigger.bedrooms}}
    baths:    {{trigger.baths}}
    guests:   {{trigger.guests}}

ACTION 2: Gmail > Send Email
  To:      {{trigger.agent_email}}
  Subject: STR Revenue Estimate — {{trigger.address}}
  Body:
    Hi,

    A new lead has been evaluated for short-term rental potential.

    Property: {{trigger.address}}
    Configuration: {{trigger.bedrooms}} BR / {{trigger.baths}} BA

    REVENUE ESTIMATE:
    Annual Revenue: ${{action1.revenue}}
    Average Daily Rate: ${{action1.average_daily_rate}}/night
    Occupancy Rate: {{action1.occupancy}}

    REVENUE RANGE:
    Conservative (25th percentile): ${{action1.percentiles.revenue.p25}}
    Expected (50th percentile): ${{action1.percentiles.revenue.p50}}
    Optimistic (75th percentile): ${{action1.percentiles.revenue.p75}}
    Top Performer (90th percentile): ${{action1.percentiles.revenue.p90}}

    — AirROI Automated Report

This automation runs every time a new row is added to your CRM sheet. The agent gets an email within seconds with a full revenue breakdown, saving hours of manual research per lead.

Continue Learning

Keep exploring the AirROI API with these related tutorials.

Frequently Asked Questions

No. Both Zapier and Make are no-code platforms. You configure everything through a visual interface — selecting modules, filling in fields, and mapping data. The AirROI API works with their built-in HTTP request modules, so no custom code is required.

Each time your Zap or Scenario runs, it makes one API call to AirROI per HTTP request step. If you have a single HTTP action fetching a revenue estimate, that is one API call per run. Monitor your usage on the AirROI developer dashboard.

Yes. Both Zapier and Make support scheduled triggers. In Zapier, use the 'Schedule by Zapier' trigger to run at intervals (every hour, day, or week). In Make, use the scheduling options in your scenario settings to set a recurring run interval.

Both platforms have built-in error handling. In Zapier, failed steps will appear in your Zap History with error details. In Make, you can add error handler routes to retry, ignore, or alert on failures. Common errors include invalid API keys (401) or missing parameters (400).

Absolutely. Zapier connects to 6,000+ apps and Make connects to 1,500+ services. You can send AirROI data to Slack, Airtable, HubSpot, Salesforce, Notion, or any app that has a Zapier or Make integration. The HTTP request output can be mapped to any downstream action.

Ready to Automate?

Get your API key and connect AirROI to your favorite no-code platform in minutes.
made with