Airtable - RealEstateAPI Zapier Integration

Step 1: Create a new Zap

• Left side panel click on Zaps

  

• Click on the + Create button

• Select New Zap

  

• Select the trigger option.

• Search for Airtable then click on it

  

• In the Event field, click the "New Record" to trigger zap whenever there is a new lead input then click on Continue.

  

Step 2: Setup and test with your Airtable account

• Make sure that you connect your Airtable account in the next step then click on continue.

  

• Set the trigger by tracking your leads in your Airtable account. In this sample they are in Lead list (base) - Leads ( table ). Click on continue.

  

• Test your trigger in the next step

  

• It will pull one sample lead that you've created in your Airtable account.
  Click on the "Continue with the selected record".

  

Step 3: Create an Action using RealEstateAPI then test step

• In the next step, select the Action. Type in Realestateapi and click on it.
• 
• In the App & event step, select the action that you want to do. Get property detail for your lead in this example.

Click on continue.

• Next step, make sure that you connect your Reapi account/key to authorize pulling data.

  

• In the Action step, click on the data field that you'd want to use for getting the property details. In the sample, they are fields that you can find in Airtable. Select address so the zap will always pull information from the address field.

  

• Continue then test the step.

  

Step 4: Create another action to send back details to Airtable

• Adding another step into the Zap will make it possible for the results to actually reflect on your Airtable account.

  

• Select Airtable as your last Action.

  

• Select update record to update your lead in Airtable

  

• Use the same account in Airtable for this next step.

  

• Track the directories that you used in your Airtable account. ( Where is the lead you want to update, same as your initial trigger set up). On the Record field, select the Id of the lead that you want to update. This way it will always locate the Id of your record entry/lead.

  

• In the same action step, select the items that you want to update on Airtable. You can edit the fields that show up in this section when you're in your Airtable account. We'll use Bedrooms and Bathrooms information to pull from Reapi and update on Airtable.

  

Step 5: Edit your Airtable template with your preferred fields

• Manually add new fields into your Airtable account before going to the next step. While on your Lead list dashboard, click on the + Add field button at the far right side.

  

  • Name the field ( We'll add Bedroom and Bathroom fields in this sample ). Then select Single line text. Save.

  

• This is what it looks like inside the sample Airtable account once you've added the Bedroom and Bathroom fields. You can add more fields here like lot size, estimated equity, garage etc then set them up on Zapier. For now we'll use these two.
  

• Test the step.

  

• After clicking on "Test step", it should update your lead in Airtable which looks like this. It will populate the Bedroom and Bathroom fields.

  

• The whole Zapier process should look like this.