0:00 Welcome to this special presentation of Better Sheets. We're going to create a little hack to get Instagram follower accounts from any Instagram page.
0:10 We have a list of Instagram pages. We have the follower account. I'm going to show you exactly how to do that in this video.
0:15 Let's see. First off, let's let's go over what it is and then I'll show you how I did it. Step by step.
0:21 We are using import XML. We figured out the XML and then we split it because there's a whole bunch of stuff here.
0:29 You can sort of see it here. We split it around a text and then we used index to grab just the thing that we needed, which was the follower account.
0:37 So first off, let's go to an Instagram account. And I'll show you how I figured this out. So right click on 38 followers here or any follower account.
0:46 We can do this, even if it's not my own account. We can go to Instagram, miss excel, go to followers, right click, inspect.
0:58 We're gonna see here. Doesn't really give us much. We can right click and we can try to copy the full XPath and in that case here, I'll put in the URL bar.
1:10 Looks like that, but this is not very helpful. What I did find, however, is if we go up here, it's 850K.
1:20 So if we go up here, it's 850K. So if we go command F on this right side and we type in 805K, we have nothing.
1:30 Oh, 850K, not 805. We have three instances of it. Right now we have OG description. We also have content. Meta content.
1:43 And we have this 850K here in this little expand title. But this title is gonna be hard to get to.
1:52 So I opted for this one up here. Meta content, I think, yeah. Oh no, it's actually, that's not what we opted for.
2:01 OG description. So we ended up not going for meta content, cause that's also hard to get. But we went for a unique one, which is meta property, OG description.
2:12 There is only one OG description in this. See, one of one. We searched for it, OG description is only one.
2:19 It's meta, is the, HTML tag. We have a property equals OG description. But what we really want out of this is the content.
2:28 So that's why we ended up going with, I'm actually gonna delete all of this stuff. And go here. That's why the XML I chose to do, Let's look at it.
2:44 Is slash slash meta. We have at property, which is sort of a class signifier. Equals OG description. And then inside of this, once we've identified that little meta property, we then go do slash, at content to say, give me the content that exists there, not the XML.
3:07 So if we don't have content, I'll show you what that looks like. Equals import XML, URL is going to be C3, XPath query.
3:16 Let's just do this alone and see what that looks like. Imported content is empty because there's probably nothing there. The actual content we want is at a class signifier called at content.
3:32 So we do slash at content. This is what we are going to get. We get this sort of gibberish here.
3:38 Not gibberish at all. It's all this information. 38 followers, 11 followers. The following 18 posts. And it's all the text within that.
3:46 But what we really want is just that number 38. We just want to know how many followers does this account have.
3:51 That's where we then split. We wrap split around this, comma, the delimitator for our case is going to be followers.
4:02 And let's see what happens when we just do that. We get a reference error. C3. So what it's doing is it would override data in C3.
4:11 Let's do false. There. Okay, we have something now. And see, it didn't do anything. Let's do true for split by.
4:22 Each again reference error because it's trying to override in C3. If I actually move this over here, I can show you sort of what's going on.
4:33 Oh, see, it's splitting everything here. And we just want this first thing here. 38. So how do we do that?
4:42 Wrap it with index handy dandy index formula. Our reference is going to be all of this stuff that we just did, comma row is going to be one.
4:51 And we only want the first column of data. And the moment we put one over here in, you can see what we get 38.
4:58 We are on the right track. Now all we have to do is copy paste this all the way down. Oops.
5:05 And we're just getting the follower count of every single Instagram account that we have the URL for. And that's it.
5:12 Grab this sheet. If you're a BetterSheets member, down below, on BetterSheets.co, you're watching this video, you can get this exact Google Sheet.
5:20 If you're not a member, become a member today. I'll see you at BetterSheets.co.