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.
Remember for this zap to work you need to authenticate your YouTube account first.
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.
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):
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.
Next, youâll need to connect the YouTube API to your workspace. Just click on "Connect to an API" on the dashboard.
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.
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â.
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.
After adding the columns you'll need to assign it a type - âShort textâ for the video title and âURLâ for the video link.
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â.
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.