If you go to your Sheet you will be able to call the function the same way you call some other standard function, e.g +SUM(). Now that you have a function to retrieve screenshots, you just need to use it on your Google Sheet. Now simply save your function by clicking on the save button and close the editor: 2) Invoke New Function from Your Google Sheet Your script editor should look like this: Var jsonified = JSON.parse(response).screenshotImage Var response = UrlFetchApp.fetch(apiEndpoint, nlOptions) Package all of the options and the data together for the call Create our json request, w/ text, language, type & encoding You can sign-up for an account at to get an API Key.
Google screenshot editor code#
Simply delete the boilerplate code and paste the following function into the Script Editor: // You need to replace the API_KEY value with an actual API Key from GetScreenshot. Once you are in Script Editor you will see a screen like the following one: You can do this by clicking Tools > Script Editor in the top bar. To accomplish this first you need to go to Google Sheets and open the Script editor. Steps to Create a Google Sheets Screenshot Function 1) Create the function in Google AppScript You can create a script inside the Google Sheet that creates a function that takes a webpage URL and then screenshots it and serve the screenshot back to a cell in your Google Sheet.įor the purpose of this tutorial, we will use our own Screenshot API (GetScreenshot) but you're free to adapt the code provided before with any screenshot API of your choice. To achieve this you can use a Screenshot API such as GetScreenshot or similars. Now, let's imagine that you want to get visual evidence of your positions in those SERPs and for that, you would like to take screenshots of all those URLs. One common task that people often want to perform on their Google Sheets, is the ability to take a screenshot of a URL that is inserted in the Google Sheet.įor example, let's imagine you have to track a series of Search Engine Result Pages (SERPs) and for the purpose of doing that, you have a Google Sheet with all the URLs of those SERPs. GetScreenshot is a paid service that starts at 5 USD a month.
Google screenshot editor how to#
This is a tutorial that explains how to take screenshots with Google Sheets and GetScreenshot.
0 kommentar(er)
