How to Get Screenshots from URLs in Airtable

May 10, 2021Andy Cloke

In this guide, we'll create screenshots for a list of URLs in Airtable. We'll use the Data Fetcher Airtable extension along with the microlink service to create these screenshots as attachment files in Airtable. This tutorial is 100% no-code!

Create URL to Screenshot Table

Create a table called 'Screenshots'.

Create a field called 'URL' and add the URLs you want to screenshot. The URLs must be full URLs with https:// at the start.

Create a field called 'Screenshot' with type 'Attachment'.

screenshots-table.png

Create a new Grid view called 'Needs screenshot' with the following filters:

  • The 'URL' field is not empty.
  • The 'Screenshot' field is empty.
screenshots Needs screenshot.png

Install Data Fetcher

Install Data Fetcher from the Airtable marketplace. After the extension launches, sign up for a free Data Fetcher account by entering a password and clicking 'Sign up for free'.

Group 1Data Fetcher Sign Up .png

Get Screenshots from URLs in Airtable

On the home screen of the Data Fetcher extension, click 'Create your first request'. Requests in Data Fetcher are how you import data to or send data from your Airtable base.

click-create-your-first-request.png

On the create request screen in Data Fetcher, for Application, select 'Microlink'.

microlink-application-selected.png

For Endpoint, select 'Create screenshots from URLs'.

microlink-screenshots-endpoint.png

Enter a Name for your request, e.g. 'Import Screenshots'. Then click 'Save & Continue'.

microlink-screenshots-save-continue.png

For URL, we want to insert a reference to the values in our 'URL' Airtable field. First, click the + button.

microlink-url-add-icon.png

On the modal that opens, select 'URL' for Field. Then select 'Needs screenshot' for Run for every record in view. Then click 'Confirm'.

microlink-url-reference-modal.png

URL should now contain a reference to the table.

microlink-url-reference.png

Make sure the Output Table & View is set to 'Screenshots' and 'Needs screenshot'.

microlink-output-table-view.png

Click 'Save & Run'.

microlink-screenshot-save-run.png

The request will run and the Response field mapping modal will open. This is where you set how the available fields from Microlink should map to the fields in the output table. Make sure the 'Screenshot' field is mapped to our existing 'Screenshot' field. Then click 'Save & Run'.

microlink-screenshot-rfm.png

Data Fetcher will then run the request for every record in 'Needs screenshot' and convert the URLs to screenshots in Airtable.

microlink-screenshot-output-data.png

Note: if you run into Microlink's free plan limits, you can buy a Microlink paid plan here, set the Authorization type to 'Header' and enter your API Key to increase your limit.

microlink-authorization.png

Create Screenshots from URLs on a Schedule

At the moment, we have to manually run the request to create the Screenshots. We can use Data Fetcher's scheduled requests feature to automatically create them every 15 minutes/ hour/ day etc.

In Data Fetcher, scroll to Schedule and click 'Upgrade'.

table-1-schedule-upgrade-button.png

A new tab will open where you can select a plan and enter your payment details to upgrade.

data fetcher upgrade pricing plans.png

Return to the Data Fetcher extension and click 'I've done this'.

table-1-schedule-ive-done-this-button.png

Under Schedule click '+ Authorize'.

Schedule Data Fetcher

A window will open where you'll be prompted to authorize which Airtable bases you want Data Fetcher to have access to.

We recommended selecting 'All current and future bases in all current and future workspaces' to avoid any issues with unauthorized bases in the future.

Click 'Grant access'.

schedule-authorize-bases.jpg

Back in Data Fetcher, you'll see Schedule this request is now toggled on.

Select how often you want the request to run, e.g. 'Every 15 mins'. Click 'Save' The request will now run create the Screenshots from URLs automatically on a schedule.

Group 11(2).png

Related Posts

How to Import Videos from YouTube URLs in Airtable

How to Import Videos from YouTube URLs in Airtable

Oct 6, 2022

Rosie Threlfall

microlink
How to Create Full-Page Screenshots in Airtable using Urlbox

How to Create Full-Page Screenshots in Airtable using Urlbox

Apr 28, 2022

Rosie Threlfall

ScreenshotUrlbox