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 this integration does

This workflow connects three tools into one simple automation:

  • Google Sheets stores the website URLs and capture settings.
  • Make.com monitors the spreadsheet and triggers the automation.
  • PeekShot API generates screenshots based on the data you send.

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 setup is useful for website monitoring, reporting, testing, documentation, and client previews.

Requirements before you begin

Make sure you have:

  • An active PeekShot account
  • A Make.com account
  • A Google account with Sheets access
  • A basic understanding of spreadsheets
  • A 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.

  1. Log in to your PeekShot dashboard.
  2. Click Projects from the sidebar.
  3. Enter a project name such as Make.com.
  4. Click Create Project.

Create a project in PeekShot

Step 2: Generate your PeekShot API key

The API key allows Make.com to access PeekShot securely.

  1. Go to Account from the sidebar.
  2. Open the API Keys tab.
  3. Click Create New Key.
  4. Enter a name such as Make.com.
  5. Select your created project.
  6. Click Create Key.

Copy the generated API key and store it safely.

Create a PeekShot API key

Step 3: Copy the API endpoint and request format

You need the correct endpoint and payload structure before configuring Make.com.

  1. Go to Projects and open your project.
  2. Select Capture URL Screenshot.
  3. Click API Details.
  4. Copy the endpoint URL.
  5. Copy the request body example.

This information will be used in Make.com.

Copy API endpoint and payload

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 sheet with a clear name such as Url to Capture.

Create the Google Sheet

Step 5: Create a new scenario in Make.com

Scenarios control automation in Make.com.

  1. Log in to Make.com.
  2. Click Create scenario.
  3. Open the scenario editor.

Create a scenario in Make.com

Step 6: Connect Google Sheets to Make.com

This module monitors new spreadsheet rows.

  1. Click the plus icon.
  2. Search for Google Sheets.
  3. Select Watch New Rows.
  4. Connect your Google account.
  5. Select your spreadsheet.
  6. Choose the correct sheet.
  7. Set Table contains headers to Yes.
  8. Set Row with headers to A1:Z1.

Save the module.

Connect Make.com with Google Sheets

Step 7: Add the HTTP module for PeekShot API

This module sends requests to PeekShot.

  1. Click the plus icon next to Google Sheets.
  2. Search for HTTP.
  3. Select Make a request.

Find the HTTP module in Make.com

Step 8: Configure the HTTP request

Configure the API request carefully.

Set the following values:

  • Authentication: No authentication
  • URL: Paste the 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.

Add the API key in the HTTP module

Step 9: Map Google Sheet data to API fields

Connect spreadsheet columns to the API parameters.

Example mapping:

  • url -> Website_Url
  • full_page -> Full_Page
  • file_type -> File_Type

This ensures each row is processed individually.

Map Google Sheet fields to the API

Step 10: Test the automation

Testing ensures everything works correctly.

  1. Click Run once in Make.com.
  2. Add a new row in Google Sheets.
  3. Wait for execution.
  4. Check whether the HTTP module succeeds.

If errors appear, review the headers, endpoint URL, and mapped fields.

Test the Make.com scenario

Step 11: Verify the screenshot in PeekShot

Confirm that PeekShot captured the image successfully.

  1. Open the PeekShot dashboard.
  2. Go to File Manager.
  3. Open your project folder.
  4. Locate the generated screenshot.

You can download or share it from there.

Validate the screenshot in PeekShot

Step 12: Activate the scenario

Once testing is successful, enable automation.

  1. Turn on the scenario.
  2. Set an execution schedule if needed.
  3. Save the 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 the spreadsheet organized

Troubleshooting common issues

If screenshots are not generated:

  • Verify that the API key is valid
  • Check the HTTP headers
  • Confirm the endpoint URL
  • Review the JSON structure
  • Ensure the sheet headers match the mapping

Most issues can be resolved by correcting the configuration.

Conclusion

Integrating Google Sheets with PeekShot using Make.com gives you a powerful no-code workflow for automated screenshot generation.

This setup reduces manual work, improves consistency, and supports scalable reporting and monitoring. Once configured, it can run continuously and grow with your team’s needs.