Facebook Ads Mockup Generator

Beginner

About this Tutorial

Create a simple facebook ad mockup with image and primary text in a google sheet. Get character count too!

Sheet Resources

Access Sheet

Copy Sheet

Preview Sheet

Featured Formulas

IMAGE() LEN()

Video Transcript

<div>0:01 So I do everything in Google sheets, even mocking up Facebook ads. Uh, I made this Facebook mock up generator, and I wanted to share it with you because I think it adds, there's a couple of things that it does that if you're a beginner, this is gonna be really cool. 0:20 If you're intermediate, maybe you didn't know, um, a little bit about this, but I wanted to share with you a few things that makes it easy to like write some Facebook ads and, and generate sort of a mock up of it. 0:32 Right? This makes it look like a Facebook ad.

Um, if we zoom out a little bit, you can see the whole thing. 0:39 There is a headline and description down here I can add, but I wanna focus up here on this image and the primary text. 0:47 So couple things first off, I really just did, um, 600 pixels wide of the sea column and the, uh, uh, four, uh, row here and to get the image I used, let's, uh, zoom in a little bit. 1:05 So you can see this image and it goes to a, a five. Why is that? Well, in a five is a URL. 1:13 So I posted this image on Twitter first, and then I just grabbed the image URL.

Uh, you can host this image anywhere you want online. 1:22 Um, you can also insert, uh, an image into the cell if you wish I used a square, uh, image , and then I just use the image URL to grab it. 1:33 All right. That's the image . That's probably like the coolest thing to be honest next. Uh, I did a character count cuz Facebook recommends 125 characters for the primary text. 1:45 Um, so I want to know what, uh, I was at as I was writing this.

Um, it's probably odd to write things in Google sheets, right. 1:54 But I do everything in Google sheets and I don't really want to know, uh, I do wanna know how money characters I have. 2:00 I don't wanna like find out later, I wanna see right away, hit enter, see the character count. I don't wanna have to copy paste it into a, a character counter or like highlight it and do on Google docs, like a character count, um, menu option. 2:12 Right. I just wanna hit, enter and see the character count. So what I did is I used the formula called lend L E N. 2:19 This is short for length.

That's why it's so weird. It's not like a lens thing. It's, it's short for length. 2:25 What's the length of this? Um, this cell and length is the number of characters. So if I write out some morph, um, interesting stuff I hit enter and right there is the character count. 2:42 Uh, I did that as well on the headline and the description. Um, and you can get this sheet if you go to the URL here, um, and I'll put the URL in the description as well. 2:53 You can grab this, uh, Facebook ad mockup generator.

And I just thought that would be really cool for You to see, um, the character count how I did. 3:03 Uh, I just did a actually I'll show you how I, uh, right click here, resize column . And I just typed in 600 there. 3:12 And I made sure that the row was also resized to 600 and see, this is pixel so 600 by 600. 3:20 It seems like is the Facebook minimum pixel count? You can set your, um, images, however you want. Right? However many pixels and Google sheets allows you to do that. 3:30 Set exact pixels. And then the image just using image your, uh, the image formula here.

Again, you can also insert, uh, an image in cell and you can mock up your Facebook ads there. 3:45 So thought that would be pretty cool. Hope you enjoy this little te this little check bite.</div>