How To Track YouTube Brand Mentions Automatically using Stackby and Zapier

If your business doesn’t leverage YouTube as a channel then you’re missing on a lot of visibility. You can not only benefit from uploading new videos there but also by monitoring for brand mentions.

But don't worry you don't need go through the videos manually to do that. You can track the mentions automatically using just two tools - Zapier and Stackby. Apart from mentions, you'll be able to track their metrics and popularity too.

In this post, I'm going to walk you through the exact steps you can follow to set up this tracking. The complete process shouldn’t take more than 10 minutes.

Creating a zap to monitor new Youtube uploads

As the first step you need to create a zap that triggers when a relevant new video is uploaded to YouTube.

Head over to Zapier, and, assuming you've already setup an account, click create a new zap, selecting “YouTube” as the trigger app and “New Video by Search” as the trigger type.

YouTube app on Zapier

Remember for this zap to work you need to authenticate your YouTube account first.

YouTube Account Authentication

In the query field add your business/app name. If it’s more than one word, then add quotes and a space between the words ( eg. “Rachit” “Stackby”). You're free to add as many words you want.

Add the keywords in the "Query" field

Once you’re done configuring the trigger, click “Continue” and test it.

If everything’s right, you’ll get some sample data like the following (check the screenshot below):

Video containing the search term

Creating your stack in Stackby

Before we finalise our zap, you need to go to Stackby and create a new template. Stackby brings together the best of spreadsheets, tables, databases and business APIs. To make it easier, Stackby has already a template created named “YouTube Channel Metrics”.  To test this zap out you can use our fully functional 7 days free trial. The paid plan starts at just 5$/month.

Template Gallery

Next, you’ll need to connect the YouTube API to your workspace. Just click on "Connect to an API" on the dashboard.

Click on "Connect to an API" to open the integrations page

Then just search “YouTube” and click on YouTube. The integeration page contains step by step instructions on how you can generate the API key to connect Stackby with YouTube.

Click on "Add your API key" to authenticate

Once this is done, just copy the YouTube Channel Metrics template to your workspace. To do this head over to the template page and click on “Copy Stack". You’ll then be prompted to add it to one of your workspaces. Just choose the relevant workspace.

The template is already filled with some example data. Just delete all rows except “YouTube API”.

YouTube Channel Metrics Tempalate 

We’re just going to add two more columns to make this extra useful for us. They’ll be for the video’s title and a link to the video for ease of viewing.

To add a column, scroll all the way to the right of the stack and click the plus icon.

Click on the plus icon to create an additional column

After adding the columns you'll need to assign it a type - “Short text” for the video title and “URL” for the video link.

Selecting appropriate column property

Once complete, drag both columns back across to the left of the stack like shown in the image below.

Connecting Zapier with Stackby

After this, you need to head back over to zap we were building.

Inside the zap editor, click the plus symbol to add an action step to your zap, selecting “Stackby” as the app and “Create Row” as the action type.

You’ll be prompted to connect your Stackby account using an API key which you can find on your account page.

The next part of configuring the zap requires you to select your workspace, stack and table from dropdown. This is quite straight forward.

Next, there are four additional fields you’ll need to map with data from the Youtube app.

We’ll add the Channel name to the first field. Just click the field and choose “Channel Title”.

Similarly map “Channel ID” column to “Channel ID” from the dropdown.

Finally, do the same for ‘Video Title’ and ‘Video URL’.

Mapping the columns with the right output

After this, you can click the “Continue” button and then the “Test & Review” button to activate the zap.

If you’re followed the correct steps, you’ll see a success message, and a new column would be created with the details on the Stackby template.

After this you can turn the zap on. Now whenever a new video containing your brand name is created, the channel name and other information will be added to the stack we created earlier on Stackby. Remember to refresh the YouTube API to fetch the channel metrics upon a new video addition to the stack.

-----

This is a guest post from Andrew Davison. He runs Luhhu, an automation agency that specializes in Zapier.