This tutorial shows how to turn reviews (Google My Business, Etsy, TrustPilot, G2, Yelp, etc.) into video shorts for Instagram, TikTok, Twitter, Facebook and more using video automation.
If you run a business, you'd like your customers to leave reviews about their experience with your product or service. It's these reviews that help new customers decide whether or not to buy from you. But collecting reviews alone isn't enough. They should be used in your marketing. Social media works well for this, as it's a great place to build trust and engage your audience.
Nowadays, social media is all about visual content, particularly videos. But it's time-consuming to make videos by hand for every review. Here's where video automation comes in. With a reusable template, you can turn all your customer reviews into on-brand social media videos – in a matter of minutes. Better yet, you could even automatically post the video on social media using a no-code platform like Zapier and Make. That's what this tutorial is all about.
For this guide, we're going to automate the following video. However, be sure to check out the template editor as well, which lets you make your own video templates.
Note to developers: you can also build custom solutions with the video generation API.
To follow along, you'll need a Creatomate account. You can sign up for free here.
We'll also need a few reviews from your customers from which to create our videos. Maybe you collect them on your website, keep them in a spreadsheet, or use third-party tools like G2, TrustPilot, TripAdvisor, etc. In any case, you'll probably want to cherry-pick the reviews for your videos, and you can do so by copy-pasting the reviews into Creatomate. Alternatively, you can import them from a CSV file. This tutorial will show you how.
Once the review videos have been created you might want to share them on social media. This can be done manually by downloading all the videos at once, but it's also possible to automate this process as well (see optional steps 4 to 6 in the outline). This article doesn't cover scheduling posts using Buffer or Hootsuite, but you can do so perfectly by using the Zapier or Make workflows discussed further in this guide.
The first step in automating our videos is to create a video template. This is the design of the video that serves as the foundation for our review videos. You can choose from ready-made templates, but you can also create your own designs with the template editor.
Next, we'll create a feed. A feed is essentially a spreadsheet that generates lots of videos at once based on a video template.
Lastly, I'll show you how to use Zapier and Make to post the generated videos automatically to social media. You can skip these step if you want.
Let's get started!
Log in to your account and navigate to the Templates page. Click the + New button to browse the template gallery. Pick a template you like, for example, the Animated Review template from the Social Media category. Select a size based on the type of video you want to post. Let's go with 1:1 Square size for now and click Create Template to open it in the video editor:
Let's take a look at the left-side panel. Here we can find the text, image, and video elements that make up the template. An important thing to know about a template is that an element can be marked as dynamic. This just means that it's a placeholder, that we'll later replace in our automated workflow. In this example, the Review-Text, Date, Name, Profile-Picture, and Photo elements are all dynamic:
To keep things simple, I'll use the template as-is. Let's move on to the next step: creating a feed.
Click the blue Use Template button at the top right of the template editor. Click on Spreadsheet to Video and select Create new feed. After clicking Continue, we'll be brought to our newly created feed:
You can think of a feed as a spreadsheet based on a video template. As you can see, the template's dynamic elements are mapped to the columns of the feed; Photo, Profile-Picture, Name, etc. As a result, each row of the feed will create a unique video since it corresponds to different text values or images.
There are a few ways to insert data into your feed. One of them is adding them manually. By clicking Add row, you'll add another row to the feed. A preview of the video is shown at the right side of the table. Let's upload an image from our device or enter a URL to an image for both the Photo and Profile-Picture columns. Enter some text in the Name, Date, and Review-Text columns. When you're done, click Save. After saving, the status column updates from Unsaved Row to No Render. This means your data is saved, but the video has not yet been generated (which is called a render):
There's another, more efficient way: import existing data. If you want to use reviews from, say, Trustpilot or Shopify, you can export them as a CSV and import it into the feed. Click Import Data and choose the file from your computer. Here you can map the columns in the CSV to the columns in the feed. Then click Continue. It's optional, but recommended, to select a merge column with unique data, like Name, then click Continue. The summary tells you how many rows will be updated or imported. If everything looks okay, click Import Data to add your reviews to the feed. And don't forget to click Save:
In the next step, we'll generate the videos.
The right side shows a preview of the final video for each row. If the preview looks as desired, click Create render to generate this video. The video is complete when the status is Rendered:
You can also render multiple rows at once. This can be done by selecting some rows, clicking × Rows Selected, and clicking Create Renders:
When your videos are ready, you can download a single video by clicking the Download render button under the preview screen. Alternatively, you can download multiple videos at once by selecting the corresponding rows, clicking × Rows Selected and select the Download Renders option. You can choose a file name by selecting a column and click Download. A ZIP file will be downloaded to your computer:
You can now use the videos wherever you want. This concludes the tutorial when there is no need to automate the workflow any further.
However, if you want to automatically process the videos once they have been rendered, I will show you how in the following steps through the use of the no-code platforms Zapier and Make.
The following steps are only necessary if you want to automate your workflow even further.
Say you intend to post the review videos on social media. If that is the case, it would be cumbersome to download the videos, and then manually post each of them on social media. Fortunately, there is a better way, and that is by creating a workflow that runs automatically when a video has finished rendering. That's what we'll do in the remainder of this tutorial.
For this example, we will automatically post the videos that were created in our feed on YouTube, Facebook, and Twitter. This means that once we click the Create render button, we will not need to perform any further manual tasks, since the automated workflow will handle them for us.
We will automatically post videos to social media, so we will need to pass along the content of the posts. To accomplish this, we can add additional columns to the feed, which we can then access through our automated workflow.
From your feed, click Edit Columns. Click + Add Column and give it the name Title. Let's click + Add Column again with the name Description. You can reorder the columns as shown in the video below. When done, click OK:
We will begin by using Zapier, which is the recommended no-code platform for automating video with Creatomate. Zapier provides integrations with YouTube, Facebook, and Twitter. In this case, we will create a Zap as follows:
Log in to your Zapier account. From your dashboard, click + Create Zap. Choose the Creatomate app and select the New Render event:
Continue by selecting your account from the list or signing in with your project's API key. You can find it under Project Settings in your account. Copy and paste it, then click Yes, Continue. When your account is selected, click Continue:
On the set up trigger page, we'll select our Feed for Animated Review in the Filter by this feed field. Then, click Continue:
Click Test trigger on the last screen to make sure Zapier is able to find the videos from our feed. This should result in a test video along with all the info, like the Title and Description columns. Earlier in this tutorial, we rendered some videos without titles and descriptions, so you'll see 'empty column'. This is fine, because we just need Zapier to find them so we can link to them in our next actions. Click Continue when the test was successful:
Add action: Upload Video in YouTube
Find the YouTube app, select Upload Video and click Continue. You'll need to select your account or sign in with Google first. Then, click Continue.
On the Set up action screen, map the columns and the video to the required fields as follows:
You can set the optional fields according to your needs. When done, click Continue.
Click Test step on the last page to make sure Zapier passes the right data. This won't upload a video to your YouTube channel, as it's just a test.
Add action: Create Page Video in Facebook Pages
Click + to add the Facebook Pages app and select the Create Page Video event. Continue by selecting your account or signing in first. Then, click Continue.
On the Set up action screen, select your page first. In the Video field, select Creatomate -> Url. You can add a title and description to your posts by linking to one of the feed columns. When done, click Continue:
You can check if everything is set up right by clicking Test step. There will be a test video posted right away, so you might want to delete it.
Add action: Create Tweet in Twitter
Click + to add the Twitter app and select the Create Tweet event. Continue by selecting your account or signing in. Then, click Continue.
The Set up action page lets you customize your tweets. Because Twitter doesn't allow duplicate tweets, the message for each tweet needs to be unique. If you link the Message field to a column of the feed with different data for each row, it'll work. Don't forget that Twitter only allows 280 characters per tweet. To add the video, select Creatomate -> Url in the Image, Video or GIF field. When done, click Continue:
Finally, click Test step to post a test tweet to Twitter. Your tweet will be posted immediately, so you might want to remove it.
Note: You can also skip this test if you get an error because you used an empty column for the required message field or if you tested it before resulting in a duplicated tweet.
Turn on your workflow by clicking Publish Zap.
Next, I'll show you how to use Make auto-posts videos to Instagram and LinkedIn.
Log in to your Make account. Click + Create a new scenario from your dashboard. As a trigger, we'll choose the Webhooks app and select the Custom webhooks event. We'll create a new webhook by clicking Add and naming it Customer Review Videos, for example. Then click Save:
Copy the URL of the newly generated webhook and click OK:
We have to connect the webhook to our Creatomate project so we can get our feed videos. Click …, select Project Settings and paste the webhook URL in the corresponding field. Click Save:
Back in Make, right-click the module and select Run this module only to test it:
The Webhooks module is now waiting for data, so let's return to your Creatomate feed. Render one of the videos. Once the video is complete, Creatomate will call the Make webhook that was set up in the Project Settings. Back in Make, the Webhooks module should now report that it has received data:
The webhook trigger is set up correctly. We'll now proceed to setting up the scenario to post the video to Instagram and LinkedIn.
Add module: Router (optional)
By adding a Router module to our scenario, we will be able to use both the Instagram and LinkedIn modules in the same Make scenario. However, you can skip this step if you're only going to post on one social media platform.
Add module: Instagram for Business - Create a Video/Reel Post
Add the Instagram for Business module and select the Create a Video or Reel Post event. First, connect your Instagram for Business account and select your page.
Let's set up our post now. Select 1. url in the Video URL field and connect the 1. columns: Description in the Caption field. When done, click OK:
Add module: HTTP - Get a file
This module will let you download the videos. We have to do this because LinkedIn expects a file, not a URL. Posting videos on Twitter and Facebook works the same way.
Right-click to add the HTTP module and select Get a file. Connect 1. url to the URL field and click OK:
Note: There's a maximum file size that you can process depending on your Make subscription. Free accounts are limited to 5 MB.
Add module: LinkedIn - Create a Video Post
Right-click to add a LinkedIn module and select Organization - Create a Video Post. Then, connect your account and select the organization first.
For the File field, make sure to select HTTP - Get a file. You can link to the appropriate columns for the Title and Content fields. Set the other options however you like and click OK when you're done:
To make sure everything is set up correctly, click Run Once and make a render with the feed. Switch the Scheduling button to ON when you're happy with your workflow.
There you have it. As you can see, it takes only a few simple steps (steps 1 to 3) to convert your customer reviews into social media videos. If you want to go even further, you can automate the video processing with Zapier or Make (steps 4 to 6).
Hope you enjoyed this tutorial on automating your social media videos!