Create real estate video listings using Zapier and Google Sheets

Real estate video marketing is one of the most powerful tools to market listings on social media. With video enjoying 20% more clicks than an image it is hard to deny the power of video on your marketing efforts.

The downside of video is the cost and time required to build high quality content.

We will show you a way to create high quality video using a set of automation tools at a fraction of the cost of traditional methods.

Our automation toolkit

For this automation we will be using Shotstack and Zapier. Shotstack is an automation tool that allows you to generate video. Zapier is a service that allows end users to integrate web applications.

You will need to create an account for both Shotstack and Zapier.

Shotstack's free account allows you to generate 20 minutes of video for free every month. Exactly enough to post 1 real estate listing per day on your Facebook Page.

Using these tools we will build an automation that posts new listings on your Facebook page.

Real estate video listing template

We will be using one of Shotstack's dynamic templates for real estate video listings.

Creating our Zap

To create our automation we will need to create a Zap. You can do this the manual way by clicking the Create Zap button in the Zapier dashboard, or by using this template.

The Zap consists out of 5 steps:

  1. Schedule the Zap to trigger daily
  2. Look up row in Google Sheets
  3. Create a video from a dynamic template
  4. Wait for the video to complete
  5. Retrieve the video status
  6. Post the video on Facebook

Real estate video listing Zapier template

Schedule your zap

The first module is our scheduler module. Every day at 9am we want to run this trigger to start the process of posting a new video listing on Facebook.

Zapier schedule module

Look up row in Google Sheets

When the Zap runs we want to retrieve information about our listings from Google Sheets. This spreadsheet contains all the information we need to fill in our template. We will search for the date presented by the scheduling trigger to retrieve the data we want to build a video with.

Zapier Google Sheets module

Generate video from dynamic template

We use Shotstack's Dynamic Template module to select our real estate template. You can choose a range of different styles and colours. You can use your brand colours but for this example we use the following presets:

  1. Overlay Style: Arrow Sharp
  2. Overlay Color: Black
  3. Icon Color: Light
  4. Font: Manrope
  5. Soundtrack: Ambisax
  6. Primary Color: #F0C20C
  7. Secondary Color: #FFFFFF

For all the other values we map those retrieved in the Google Sheets module.

Zapier Shotstack Dynamic Template module

Wait for the video to render

We add a 1 minute delay as it takes about 30 seconds to render this template.

Zapier Delay module

Retrieve video URL

Use the Shotstack Poll Render Status module to retrieve the status of our video. Here you map the Render ID from the Dynamic Template module to the ID field. After the 1 minute delay this should provide us with the finished video URL.

Zapier Shotstack Poll Render Status module

Post to Facebook

Map the URL retrieved in the previous module to the video field. Then map the address and content fields to create a suitable Title and Description for your post.

Zapier Facebook Pages module

Turn on your Zap

The only step left is to turn on your Zap. Sit back and enjoy while the Zap posts a new video listing to your Facebook page, every day.

Facebook Page with real estate video listing

Derk Zomer

BY DERK ZOMER
28th September, 2021

Become an Automated Video Editing Pro

Every month we share articles like this one to keep you up to speed with automated video editing.


You might also like