Take Screenshots from URLs in Google Sheets

Intermediate

About this Tutorial

Use Screenshot One api to quickly get cached images of Screenshots and then go and download them. Check this out and let me know how you'd use it.

Sheet Resources

Access Sheet

Copy Sheet

Preview Sheet

Featured Formulas

IMAGE()

Video Transcript

<div>0:00 Hey, so we're taking screenshots inside of Google Sheets. Uh, we can put a URL in here, get a download link with this equals get screenshot cache URL. 0:10 I'll show you this, uh, formula soon, or function in Apps Script . And we can wrap this with image to actually see it inside of a Google Sheet. 0:20 So, I'll show you how this works in Apps Script . and you can. Get this sheet down below with the, uh, in the description. 0:29 Get the, uh, URL of the sheet and actually copy it to your drive.

I'll show you how to change your API key. 0:35 But we're using screenshot 1 here, by the way. Uh, by the time you watch this video, I'll have rolled this access key. 0:42 But I'm using it for free for right now. And, um, you can get it for free as well for, I think, up to a hundred. 0:48 And screen shots, something like that. So make sure you get your screenshot 1 API key, again, for free. And what we're doing here is, this is really useful for, obviously I just took a screenshot of my own site. 1:01 But also for like maybe competitor pricing.

But also Google search results if you're doing SEO or something or monitoring some site with some kind of, uh, you need to take a s screenshot of something and you have this sort of search, kind of text. 1:19 Uh, something like search lord, by the way, it's absolutely free. You have a bunch of these links. Over at better sheets.co slash sheet lord. 1:29 Uh, this one Google sheet will give you links to a ton of search sites. So you create a, just write in your key. 1:36 And it'll give you a ton of links to different places. And you can now take screenshots of those, right?

With this app script that I'm going to show you here. 1:44 So, over in extensions app script . Uh, it has this function , get screenshot cache URL. You're going to have to update your API key right here. 1:53 Again, replace this with the one you have. This, your use, this access key will not work after this video. Uh, what we're doing is we're adding a bit of- of information to the URL. 2:02 We're saying cache equals true. We're saying the cache is going to last, I think, up to 30 days. And we want a response of just the JSON. 2:10 Then we're taking that JSON.

Actually, sorry, we're- we're going and fetching that URL. Then we're taking that JSON. And we're saying, hey, just get the content of that JSON. 2:20 And we need JSON.cache URL. So we're just parsing it at the end. 10. And saying, hey, parse this JSON that's coming in this structured format . 2:28 And just get the .cache URL. And we get that. Uh, I am working on also saving this to drive. So basically, this is sort of an extra little thing that I was working on. 2:43 But, uh, go find the screenshots. Uh, uhh, uhh, Google Drive folder.

If there's not one, we're going to make one here. 2:53 Drive app.create folder. And then we're going to save this blob, which is the cache URL. Uh, we're going to save that to our drive. 3:05 Um, I'm going to put this in another video I do believe. But right now, just, if you want to get some screenshots, go grab this sheet. 3:12 This. App Script right here is done for you.

You can take screenshots in Google Sheets, from Google Sheets, and then you can get the URL, and what you can do really simply is go to that cache URL, and right click and save image as, and you have an image . 3:28 It's going to have this crazy number here, so you can rename this. But again, I'm going to, um, try to work on this, and add. 3:36 it. This save to drive for you. So, really cool.

I think this is a really fun way to do screenshots. 3:43 If you have a bunch of URLs, and you need to take the screenshots of super simple way to do it. 3:49 Alright, enjoy, get the sheet, and everything inside.</div>