Create a Zap Adding New YouTube Videos to Airtable — Zapier Apps and Filter Tutorial!

View this thread on: d.buzz | hive.blog | peakd.com | ecency.com
·@jerrybanfield·
0.000 HBD
Create a Zap Adding New YouTube Videos to Airtable — Zapier Apps and Filter Tutorial!
<center>https://jerrybanfield.com/wp-content/uploads/2020/04/NBP088-00th.jpg</center> <br/><p>Would you like to create a <em>Zap</em> adding new <em>YouTube</em> videos to <em>Airtable</em> because this will be useful to make lists of videos in topics you selected using <em>Zapier</em>?</p>
<figure class="wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio"><div class="wp-block-embed__wrapper">
https://youtu.be/AxP73JNulmY
</div></figure>
<h2>Create a Zap Adding New YouTube Videos to Airtable — Zapier Apps and Filter Tutorial!</h2>
<p>Are you ready to learn how to use these <em>Zapier</em> apps to enhance the functionality of your automation in <em>Zapier?</em></p>
<img src="https://jerrybanfield.com/wp-content/uploads/2020/04/NBP088-00th.jpg" alt="Create a Zap Adding New YouTube Videos to Airtable — Zapier Apps and Filter Tutorial!"/>
<p>What we'll look at is how to use applications that are already built into <em>Zapier</em> in order to greatly expand the functionality you have by using third-party applications such as bringing data in from the <em>YouTube</em> app, <em>Facebook</em> app, <em>Twitter</em> app and email marketing app, et cetera.</p>
<p>These <a href="https://zapier.com/apps">applications on <em>Zapier</em></a> are about half of what I use in my own automations.</p>
<p>For example, several of my <em>Zaps</em> are using the <em>"SMS by Zapier."</em> I use that to send myself a text message when I get things like a new order.</p>
<p>You can use things like the filter application to help you process the data you get and turn it into something more useful.</p>
<p>For example, if you have a question form that you're doing, you can include a question on it that says, <em>"Do you want to join my email list?"</em> and if someone says <em>Yes</em> on that, then you can filter out everybody that says <em>No</em> and just put the people who say <em>Yes</em> onto your email list.</p>
<p>You also have apps like <em>"Paths by Zapier"</em> where you can split your automation based on what is happening in the data.</p>
<img src="https://jerrybanfield.com/wp-content/uploads/2020/04/NBP088-01.jpg" alt="Apps by Zapier"/>
<p>For example, you could say, if somebody says <em>No,</em> you could take a different action and send them a followup email and if they say <em>Yes,</em> you could just add them onto your email list.</p>
<p>This is accessible by searching for <em>Zapier</em> in the apps or to see the different apps by <em>Zapier,</em> or you can just search for what you need and the apps will come up while you're making an automation.</p>
<p>Let's show you how to use this in real time as we make a <em>Zap.</em></p>
<img src="https://jerrybanfield.com/wp-content/uploads/2020/04/NBP088-02.jpg" alt="Apps by Zapier"/>
<p>I'll start off with the idea of what I want to accomplish in my mind.</p>
<p>Let's say for example, I want to find <em>YouTube</em> videos that come out on a specific subject and put those into a spreadsheet that I then can track what people are making on this certain subject.</p>
<p>Let's click on <em>"Make a Zap."</em></p>
<p>With this to begin, we will pick an app and an event. In order to do this, I will type my app.</p>
<p>Here's <em>YouTube.</em></p>
<img src="https://jerrybanfield.com/wp-content/uploads/2020/04/NBP088-03.jpg" alt="Create a Zap Adding New YouTube Videos to Airtable — Zapier Apps and Filter Tutorial!"/>
<p>I'll click on <em>YouTube</em> and I'll click on the trigger event.</p>
<p>I will put to in <em>"New video by search"</em> here.</p>
<img src="https://jerrybanfield.com/wp-content/uploads/2020/04/NBP088-04.jpg" alt="Create a Zap Adding New YouTube Videos to Airtable — Zapier Apps and Filter Tutorial!"/>
<p>That will allow me to find the exact search result I want.</p>
<p>I will put <a href="https://www.youtube.com/c/jerrybanfield">my <em>YouTube</em> channel</a> in here.</p>
<img src="https://jerrybanfield.com/wp-content/uploads/2020/04/NBP088-05.jpg" alt="Create a Zap Adding New YouTube Videos to Airtable — Zapier Apps and Filter Tutorial!"/>
<p>Click on <em>"Continue."</em></p>
<p>Now, what I need to do is put in what exactly am I going to search for?</p>
<p>Let's say that I want to know every single thing that comes out about <em>Zapier</em> to help me make the very best course.</p>
<p>I put <em>Zapier</em> in.</p>
<img src="https://jerrybanfield.com/wp-content/uploads/2020/04/NBP088-06.jpg" alt="Create a Zap Adding New YouTube Videos to Airtable — Zapier Apps and Filter Tutorial!"/>
<p>Now I hit <em>"Continue."</em></p>
<p>I can test and review this to see what it looks like.</p>
<p>I'll hit <em>"Test &amp; Review"</em> to see if it gives me any kind of data for this.</p>
<p>It'll show me here the exact video.</p>
<img src="https://jerrybanfield.com/wp-content/uploads/2020/04/NBP088-07.jpg" alt="Create a Zap Adding New YouTube Videos to Airtable — Zapier Apps and Filter Tutorial!"/>
<p>Now I can look and see the exact kind of data I could expect to get out of this <em>Zap.</em> You'll notice this is all the information I have to work with.</p>
<p>I can also narrow it down to specific channels if I want to.</p>
<p>I'm already getting automatic searches right here.</p>
<p>This is great.</p>
<p>What I'm ready to do next is click on <em>"Done editing."</em></p>
<p>Now I want to filter this by certain channels. I could filter it by anything else I can come up with that I can filter out of the data.</p>
<p>This is very important to consider beforehand. If you want to be able to really filter the data effectively, you need to know exactly what data you've got to work with in that particular <em>Zap.</em></p>
<p>For this, let's say I just want videos longer than <em>10</em> minutes, that I want in depth tutorials. I don't want this video, which is <em>52</em> seconds.</p>
<img src="https://jerrybanfield.com/wp-content/uploads/2020/04/NBP088-08.jpg" alt="Create a Zap Adding New YouTube Videos to Airtable — Zapier Apps and Filter Tutorial!"/>
<p>That's probably not going to show me something I don't know.</p>
<p>I can scroll down here, this video is seven minutes, that might be good, but let's say I just want to keep an eye on people who are putting out in depth videos that I might be able to learn from, and then I can see who's doing the most detailed <em>Zapier</em> tutorials.</p>
<p>What I will do to do this is click on the <em>"Choose app"</em> and I'll do <em>"Filter by Zapier."</em></p>
<img src="https://jerrybanfield.com/wp-content/uploads/2020/04/NBP088-09.jpg" alt="Filter in Zapier"/>
<p>As I'm setting up the filter, I need to pull in the exact right data and this is all the data I've got to work with.</p>
<p>This is the exact data I need in order to do this: <em>Details duration.</em></p>
<img src="https://jerrybanfield.com/wp-content/uploads/2020/04/NBP088-10.jpg" alt="Create a Zap Adding New YouTube Videos to Airtable — Zapier Apps and Filter Tutorial!"/>
<p>That's what <em>YouTube</em> gives me.</p>
<p>That shows me how long the video is.</p>
<p>Now, I've got these different options and this you'll want to learn about how each of these works, which is why I'll explain it to you.</p>
<p>You've got data has to be in certain formats. It can be in text format, numbers or date time. If your data is not in the exact format you need, you may find it difficult to set up the automation, which is why you want to make sure that it has what you want in it.</p>
<p>What I can see is I've got a date time. This is not necessarily looking like it's going to do what I want because this has date and time after or before.</p>
<p>I'm not sure if that is exactly what I'm going to be able to work with effectively to see if the video is longer than <em>10</em> minutes because it's just date time before or after.</p>
<img src="https://jerrybanfield.com/wp-content/uploads/2020/04/NBP088-11.jpg" alt="Create a Zap Adding New YouTube Videos to Airtable — Zapier Apps and Filter Tutorial!"/>
<p>If I click on <em>"Date/Time After"</em> and let's say I want to do one minute, I'll do <em>0:01:00.</em></p>
<img src="https://jerrybanfield.com/wp-content/uploads/2020/04/NBP088-12.jpg" alt="Create a Zap Adding New YouTube Videos to Airtable — Zapier Apps and Filter Tutorial!"/>
<p>What you can do is test this out to see if it actually works and check on the sample data.</p>
<p>That is good because it is working.</p>
<p>Sometimes the only thing you can do to be sure if it will work is just trying it.</p>
<p>Now this one has this detail's duration here at three minutes and you can see it's matching it correctly.</p>
<img src="https://jerrybanfield.com/wp-content/uploads/2020/04/NBP088-13.jpg" alt="Create a Zap Adding New YouTube Videos to Airtable — Zapier Apps and Filter Tutorial!"/>
<p>Let's change this to four minutes to make sure it's working.</p>
<p>Now, this one did not match and that is very good. That is showing me that my filter is working the way I think it should work. It shows longer than four minutes.</p>
<p>I can put this now into <em>10</em> minutes. I want videos longer than <em>10</em> minutes.</p>
<p>I click on <em>"Continue,"</em> and it shows me the <em>Details Duration.</em></p>
<p>I'm checking and it says it would not have continued and I verified it would have continued if I put it down, which means the filter is operating correctly.</p>
<img src="https://jerrybanfield.com/wp-content/uploads/2020/04/NBP088-14.jpg" alt="Create a Zap Adding New YouTube Videos to Airtable — Zapier Apps and Filter Tutorial!"/>
<p>I click on <em>"Done editing."</em></p>
<p>Now I have the chance to put this into something else I might find useful.</p>
<p>What I can do is put this into an <em>Airtable</em> spreadsheet.</p>
<img src="https://jerrybanfield.com/wp-content/uploads/2020/04/NBP088-15.jpg" alt="Create a Zap Adding New YouTube Videos to Airtable — Zapier Apps and Filter Tutorial!"/>
<p>I could put it into an <em>Excel</em> spreadsheet. I could put it into <em>Google Sheets.</em> I could put it into <em>Google Drive.</em> I could put it in a <em>Word</em> document.</p>
<p>There are lots of different options.</p>
<p>Let's say for this one I want to do <em>Airtable</em> because I've already got that set up. I've got the <em>Airtable</em> app.</p>
<p>Now what I need to do is click on <em>"Create record."</em></p>
<img src="https://jerrybanfield.com/wp-content/uploads/2020/04/NBP088-16.jpg" alt="Create a Zap Adding New YouTube Videos to Airtable — Zapier Apps and Filter Tutorial!"/>
<p>That will make me a new entry in whatever spreadsheet I've got.</p>
<p>I click on <em>"Continue."</em></p>
<p>Now I need to pick my account. I've already got the <em>Airtable</em> account here.</p>
<img src="https://jerrybanfield.com/wp-content/uploads/2020/04/NBP088-17.jpg" alt="Create a Zap Adding New YouTube Videos to Airtable — Zapier Apps and Filter Tutorial!"/>
<p>I click on <em>"Continue"</em> again.</p>
<p>Now I need to pick exactly which one and exactly which table.</p>
<p>Let's say for example, I've already got this <em>"Videos"</em> spreadsheet that I want to put it in, which is what I actually use to fill my new videos.</p>
<p>I've got this base for videos and I've then got this <em>"Videos"</em> here.</p>
<img src="https://jerrybanfield.com/wp-content/uploads/2020/04/NBP088-18.jpg" alt="Create a Zap Adding New YouTube Videos to Airtable — Zapier Apps and Filter Tutorial!"/>
<p>Now I could add a new entry every time automatically into my spreadsheet.</p>
<p>I use this spreadsheet when I need some ideas or some inspiration for what kind of video to make today. I can literally set up automation to just put videos other people are already doing automatically when they come out that are longer than <em>10</em> minutes, to give me a list of videos and to inspire me.</p>
<p>Imagine if you put this on a certain hot search term or the exact right phrase you wanted, you could see exactly what other people were making and have a spreadsheet to look in every day that would have a complete list of those as they came out.</p>
<p>What you need to do to get this to work is you need to match every field up to what you wanted in your spreadsheet.</p>
<p>For example, I would take the title from the <em>YouTube</em> video and put it in the <em>Name</em> field.</p>
<img src="https://jerrybanfield.com/wp-content/uploads/2020/04/NBP088-19.jpg" alt="Create a Zap Adding New YouTube Videos to Airtable — Zapier Apps and Filter Tutorial!"/>
<p>Then in the <em>Notes,</em> to do this I would set this up with a specific <em>URL</em> field in <em>Airtable,</em> and here I can just put the <em>Notes</em> field with the <em>URL.</em></p>
<p>Then for the <em>Count,</em> I can put something like the exact length of time if I want to.</p>
<img src="https://jerrybanfield.com/wp-content/uploads/2020/04/NBP088-20.jpg" alt="Create a Zap Adding New YouTube Videos to Airtable — Zapier Apps and Filter Tutorial!"/>
<p>I can see the details it's using, even though the filter wouldn't have continued, it's still using the sample data that it's got.</p>
<p>As I continue through this, I could adjust each of these other fields to exactly how I wanted it to.</p>
<p>I could click on <em>"Continue"</em> and test it to see if it actually adds a record into my spreadsheet.</p>
<p>I've got this setup in <em>Airtable</em> to allow me then to click <em>"Done"</em> on it, which means I could look through all the new video ideas very easily, hit the checkmark for <em>"Done"</em> on the app idea that each single video, I could review it and click on <em>"Done"</em> or <em>"Reviewed,"</em> and then it would filter it out of the table in <em>Airtable.</em></p>
<p>That way it could have a running list of videos on a certain subject, and marked as <em>"Done"</em> every time I've looked over it.</p>
<p>For example, if there were videos in other languages that I didn't speak, I could just click <em>"Done"</em> and remove those.</p>
<p>There's probably some way to set up automation to do that. However, for this, the way I've done it, it doesn't have the language.</p>
<p><em>YouTube</em> does not give you the language the video is in unfortunately and for something like that I could just really easily click the ones in different languages, click on <em>"Done,"</em> or I could revise my search query to try to get something that might have more specific searches.</p>
<p>For example, I could put something up here in the search terms. I could call it <em>"Zapier tutorial."</em></p>
<p>Then when I call it <em>"Zapier tutorial"</em> and I click on <em>"Continue,"</em> then I get many different videos after clicking on <em>"Test &amp; Review."</em></p>
<p>Then I'm likely to get <em>Zapier</em> tutorials in <em>English.</em></p>
<p>Here we go: <em>"Integrating Zapier with Glide."</em></p>
<img src="https://jerrybanfield.com/wp-content/uploads/2020/04/NBP088-21.jpg" alt="Youtube data in Zapier"/>
<p>That's in <em>English</em>.</p>
<p>We scroll down here, and now I'm getting videos that are specifically <em>Zapier</em> tutorials, even though this one doesn't say tutorial in it, and it's not saying it in the title, I guess it is saying it's somewhere in the description because it's pulling it just off of search data.</p>
<p>What you can do as you're planning out your automation and you start working with it, is you can just see what happens, notice the data, and then adjust your <em>Zap</em> to give you the exact right information you're looking for.</p>
<p>This will allow you to make powerful automations with almost any data that's coming out online and this is a great example of how you use the built-in applications like a filter as a part of creating a workflow like this.</p>
<p>You can continue learning with us in the full class today <strong>“The Zapier Course — Save Time and Scale Digital Marketing With Automation!”</strong> at <em><a href="https://jerrybanfield.com/courses/zapier/">https://jerrybanfield.com/courses/zapier/</a></em></p>
<div class="wp-block-buttons"><div class="wp-block-button is-style-outline"><a class="wp-block-button__link has-text-color has-very-dark-gray-color has-background has-light-green-cyan-background-color" href="https://jerrybanfield.com/courses/zapier/">View the Zapier Course</a></div>
</div>
<p></p>
<h3>Final Words</h3>
<p>Thank you very much for watching this video from my <em>Zapier</em> course available at <em><a href="https://jerrybanfield.com/">Jerrybanfield.com</a>.</em></p>
<p>You can take your first course with me totally for free when you add a course to your cart and put the coupon code <em>"YouTube"</em> in at checkout.</p>
<img src="https://jerrybanfield.com/wp-content/uploads/2020/04/NBP095-003.jpg" alt="Jerry Banfield free course"/>
<p>If you'd like to level up your digital marketing skills, I've got a mastermind at <a href="https://jerrybanfield.com/dmm/"><em>Jerrybanfield.com/dmm/</em></a> where we have group calls on zoom every week.</p>
<p>You will love joining us there and find it really helpful to hear what everybody else is doing online and share with the group what you are doing and what you need help with.</p>
<img src="https://jerrybanfield.com/wp-content/uploads/2020/04/NBP095-004.jpg" alt="Jerry Banfield mastermind"/>
<p>For the best experience with me, I recommend you join me for a call.</p>
<p>I do absolute miracle work in helping people build their businesses online.</p>
<p>In my calls, go to <em><a href="https://jerrybanfield.com/call/">Jerrybanfield.com/call</a></em> today to view my schedule and to choose either a group call or a one-on-one call.</p>
<img src="https://jerrybanfield.com/wp-content/uploads/2020/04/NBP095-005.jpg" alt="Jerry Banfield calls"/>
<p>I appreciate you watching this and I trust if you found this helpful, you'll <a href="https://youtube.com/c/jerrybanfield">smash that subscribe button</a> on <em>YouTube</em> and turn those notifications on so that you'll never miss another amazing video like this.</p>
<p>I put new videos out every day at <em>11:00 PM Eastern</em> and I'll see you on the next one.</p>
<p>I love you.</p>
<p>You’re awesome.</p>
<p>I appreciate the chance to serve you today and I will see you again soon.</p>
<p>Love,<br><em>Jerry Banfield</em></p>
<p>Edits from video transcript by <em><a href="http://www.michelgerardonline.com">Michel Gerard</a></em>.</p>
 <br /><center><hr/><em>Posted from my blog with <a href='https://wordpress.org/plugins/steempress/'>SteemPress</a> : https://jerrybanfield.com/zap-youtube-airtable/ </em><hr/></center>
👍 , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,