Screenshot Multiple URLs from Airtable with Make
This guide shows you how to automate capturing screenshots of multiple URLs stored in an Airtable base using Make (formerly Integromat). You’ll set up a scenario that reads each URL, generates a screenshot via a third-party service, and saves the image back to Airtable—saving you hours of manual work. Before starting, you’ll need a Make account, an Airtable base with a table containing URL records, and an API key from a screenshot service like ScreenshotOne or Urlbox (the steps below use ScreenshotOne as an example).
What You’ll Need
- A Make account (free or paid plan)
- An Airtable base with a table that includes a field for URLs (and ideally a field to store the screenshot attachment)
- An API key from a screenshot service (e.g., ScreenshotOne, Urlbox, or similar)
- Basic familiarity with Make’s scenario editor
Step-by-Step
- Create a new scenario in Make. Log in to Make, click “Create a new scenario,” and give it a name like “Airtable URL Screenshots.”
- Add the Airtable module as the trigger. Search for “Airtable” in the module list, choose “Search Records,” and connect your Airtable account. Select the Base and Table that contain your URLs.
- Set up the search criteria. In the Airtable module, configure it to fetch records where the URL field is not empty. You can also add a filter to only process records that don’t already have a screenshot (e.g., a checkbox field like “Screenshot Done” is empty).
- Add a loop module. Since Airtable returns multiple records, add a “Flow Control” > “Iterator” module after the Airtable search. Connect it and map the “Records” array from the Airtable module output.
- Add an HTTP module to call the screenshot service. After the iterator, add an “HTTP” > “Make a Request” module. Set the method to GET and enter the screenshot API endpoint. For ScreenshotOne, the URL format is:
https://api.screenshotone.com/take?url={URL}&access_key={YOUR_API_KEY}&format=png. Replace{URL}with the URL field from the iterator (via mapping) and{YOUR_API_KEY}with your actual API key. - Configure the HTTP module’s response. In the HTTP module settings, set “Response Type” to “File” so Make captures the image binary data.
- Add an Airtable “Update Record” module. Connect it after the HTTP module. Select the same Base and Table, and use the Record ID from the iterator to update the specific record.
- Map the screenshot to an attachment field. In the Update Record module, find your attachment field (e.g., “Screenshot”). Click the field and map the HTTP module’s “File” output. Make will attach the downloaded image to that record.
- Add a checkbox update (optional). If you have a field like “Screenshot Done,” set it to true in the Update Record module. This prevents re-processing the same record in future runs.
- Run the scenario. Click “Run once” to test with a small set. Check Airtable to verify screenshots appear. If successful, set the schedule (e.g., every 15 minutes) and activate the scenario.
Common Mistakes
- Not handling rate limits: Screenshot services often have API limits. If you have many URLs, add a “Sleep” module (e.g., 1 second) between iterations to avoid hitting limits.
- Using the wrong field type: The screenshot field must be an “Attachment” field in Airtable, not a URL or text field.
- Forgetting to map the URL correctly: In the HTTP module, you must map the URL field from the iterator, not type it manually. Otherwise, every screenshot will be of the same URL.
- Not setting the HTTP response to “File”: If you leave the default response type as “Text,” Make won’t be able to attach the image properly.
- Overlooking API key security: Never hardcode your API key in the URL if you share the scenario. Use Make’s “Set Variable” module or environment variables for better security.
Tips
- Use a delay between requests: Add a “Sleep” module (e.g., 1-2 seconds) to avoid overwhelming the screenshot service and to stay within rate limits.
- Filter records to process only new ones: Use a checkbox field like “Processed” and set it to true after successful capture. Then filter the Airtable search to only fetch records where that checkbox is empty.
- Test with a single record first: Before running on all records, use Airtable’s “Search Records” limit to fetch just one record to verify the flow works.
- Consider using a dedicated screenshot service: Services like ScreenshotOne, Urlbox, or Thum.io offer reliable APIs. Some have free tiers, but check their terms for commercial use.
- Store screenshots in Airtable as attachments: This keeps everything in one place. Alternatively, you could save them to cloud storage (like Google Drive) and store the link in Airtable.
Troubleshooting
- Screenshot is blank or broken: The URL might be inaccessible from the screenshot service’s servers (e.g., localhost, password-protected sites). Test the URL manually in a browser. Also, check that the screenshot service can reach the URL—some services block certain IPs or require a whitelist.
- HTTP module returns an error (e.g., 401): Your API key is likely incorrect or expired. Double-check the key in your screenshot service dashboard. Also, ensure you’re using the correct endpoint format.
- No records are fetched from Airtable: Verify that the Airtable module’s filter criteria are correct. For example, if you filter by “Screenshot Done is empty,” make sure the field exists and is named exactly as in Airtable.
- Attachment field shows a file but not an image: The HTTP module might be returning a non-image file (e.g., HTML error page). Check the HTTP module’s “Response” tab to see the content type. If it’s not an image, review the API URL and parameters.
- Scenario runs but doesn’t update Airtable: Ensure the Update Record module is connected to the iterator’s output and that the Record ID is correctly mapped. Also, check that the attachment field is set to accept files.
Frequently Asked Questions
Can I use a free screenshot service?
Yes, some services offer limited free tiers, but they often have usage caps or watermarks. Check the service’s pricing page for details.
How many URLs can I process at once?
Make’s free plan has a certain number of operations per month, and screenshot services have their own rate limits. Start with a small batch and monitor usage.
Can I capture full-page screenshots?
Yes, most screenshot APIs allow you to specify a full-page capture. For example, ScreenshotOne uses the full_page=true parameter. Add it to your API URL.
What if my URLs are behind a login?
Screenshot services generally cannot access pages that require authentication. You may need to use a service that supports session cookies or use a different approach, such as a headless browser.
Can I store screenshots in Google Drive instead of Airtable?
Yes, you can add a Google Drive module after the HTTP module to upload the file, then update Airtable with the Drive link.
How do I avoid re-screenshotting the same URLs?
Use a checkbox field like “Processed” and set it to true after successful capture. Then filter your Airtable search to only fetch records where that checkbox is empty.
Related
Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.