Automating website screenshots helps developers, marketers, and product teams save time and eliminate repetitive manual work. By connecting Google Sheets with PeekShot using Make.com, you can create a reliable workflow that automatically captures website screenshots whenever new URLs are added to a spreadsheet.
This guide explains every step required to build a complete automation using PeekShot API, Google Sheets, and Make.com. It is designed for beginners and advanced users who want a clear, error free setup.
What Is This Integration and How It Works
This integration connects three tools into one workflow:
Google Sheets stores the website URLs and capture settings.
Make.com monitors the spreadsheet and triggers automation.
PeekShot API generates screenshots based on the data.
When a new row is added to the spreadsheet, Make.com detects it and sends the data to PeekShot. PeekShot captures the screenshot and stores the result in your account.
This workflow is commonly used for website monitoring, reporting, testing, documentation, and client previews.
Requirements Before You Begin
Before starting, make sure you have:
An active PeekShot account
A Make.com account
A Google account with Sheets access
Basic understanding of spreadsheets
Stable internet connection
Having these ready will prevent setup issues later.
Step 1: Create a Project in PeekShot
Projects in PeekShot help you organize screenshots and API usage.
Log in to your PeekShot dashboard.
Click on Projects from the sidebar.
Enter a project name such as Make.com.
Click Create Project.
Step 2: Generate Your PeekShot API Key
The API key allows Make.com to access PeekShot securely.
Go to Account from the sidebar.
Open the API Keys tab.
Click Create New Key.
Enter a name such as Make.com.
Select your created project.
Click Create Key.
Copy the generated API key and store it safely.
Step 3: Get API Endpoint and Request Format
You need the correct endpoint and payload structure.
Go to Projects and open your project.
Select Capture URL Screenshot.
Click API Details.
Copy the endpoint URL.
Copy the request body example.
This information will be used in Make.com.
Step 4: Prepare Your Google Sheet
Create a spreadsheet that will act as your automation trigger.
Create the following columns in row 1:
Website_Url
Full_Page
File_Type
Example values:
Website_Url: https://example.com
Full_Page: TRUE or FALSE
File_Type: png or jpg
Save the file with a clear name such as Url to Capture.
Step 5: Create a New Scenario in Make.com
Scenarios control automation in Make.com.
Log in to Make.com.
Click Create scenario.
Open the scenario editor.
Step 6: Connect Google Sheets to Make.com
This module monitors new spreadsheet rows.
Click the plus icon.
Search for Google Sheets.
Select Watch New Rows.
Connect your Google account.
Select your spreadsheet.
Choose the correct sheet.
Set Table contains headers to Yes.
Set Row with headers to A1:Z1.
Save the module.
Step 7: Add HTTP Module for PeekShot API
This module sends requests to PeekShot.
Click the plus icon next to Google Sheets.
Search for HTTP.
Select Make a request.
Step 8: Configure the HTTP Request
Configure the API request carefully.
Set the following values:
Authentication: No authentication
URL: Paste PeekShot API endpoint
Method: POST
Under Headers, add:
Name: x-api-key
Value: Your PeekShot API key
Set Body type to Raw JSON.
Paste the request body and map fields from Google Sheets.
Step 9: Map Google Sheet Data to API Fields
Connect spreadsheet columns to API parameters.
Example mapping:
url → Website_Url
full_page → Full_Page
file_type → File_Type
This ensures each row is processed individually.
Step 10: Test the Automation
Testing ensures everything works correctly.
Click Run once in Make.com.
Add a new row in Google Sheets.
Wait for execution.
Check if the HTTP module succeeds.
If errors appear, review headers, URL, and mapping.
Step 11: Verify Screenshot in PeekShot
Confirm that PeekShot captured the image.
Open PeekShot dashboard.
Go to File Manager.
Open your project folder.
Locate the generated screenshot.
You can download or share it from here.
Step 12: Activate the Scenario
Once testing is successful, enable automation.
Turn on the scenario.
Set execution schedule if needed.
Save changes.
The workflow will now run automatically.
Common Use Cases
Website change monitoring
Marketing campaign reports
UI testing automation
Client website previews
Visual documentation
Best Practices
Validate URLs before submission
Protect API keys
Limit bulk requests
Monitor execution logs
Keep spreadsheet organized
Troubleshooting Common Issues
If screenshots are not generated:
Verify API key validity
Check HTTP headers
Confirm endpoint URL
Review JSON structure
Ensure sheet headers match mapping
Most issues can be resolved by correcting configuration.
Conclusion
Integrating Google Sheets with PeekShot using Make.com provides a powerful no-code solution for automated screenshot generation.
This workflow reduces manual work, improves consistency, and supports scalable reporting and monitoring.
Once configured, it operates continuously and adapts easily to growing requirements.