AutomationFlowsEmail & Gmail › Capture URL Screenshots From Google Sheets with Screenshotone & Save to…

Capture URL Screenshots From Google Sheets with Screenshotone & Save to…

Original n8n title: Capture URL Screenshots From Google Sheets with Screenshotone & Save to Drive with Gmail Alerts

ByNiko @niko on n8n.io

This automation template streamlines the process of capturing screenshots for multiple URLs. Instead of manually visiting each URL, taking a screenshot, and organizing the results, this workflow automates everything. When a spreadsheet is added to a designated Google Drive…

Event trigger★★★★☆ complexity9 nodesHTTP RequestGoogle SheetsGoogle DriveGoogle Drive TriggerGmail
Email & Gmail Trigger: Event Nodes: 9 Complexity: ★★★★☆ Added:

This workflow corresponds to n8n.io template #3321 — we link there as the canonical source.

This workflow follows the Gmail → Google Drive recipe pattern — see all workflows that pair these two integrations.

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

Download .json
{
  "id": "rVZ45LaNVNhJI9Fi",
  "name": "Automated URL Screenshots: Google Sheets + ScreenshotOne with Email Alerts",
  "tags": [
    {
      "id": "hl1c8l8cX6WLDebn",
      "name": "Drive",
      "createdAt": "2025-03-24T11:58:31.377Z",
      "updatedAt": "2025-03-24T11:58:31.377Z"
    },
    {
      "id": "hydbGbGQBvdtg5yG",
      "name": "Spreadsheets",
      "createdAt": "2025-03-24T11:58:38.767Z",
      "updatedAt": "2025-03-24T11:58:38.767Z"
    },
    {
      "id": "afr1S4wdtRDjJnkM",
      "name": "Screenshotone",
      "createdAt": "2025-03-24T11:58:51.623Z",
      "updatedAt": "2025-03-24T11:58:51.623Z"
    },
    {
      "id": "iWYO3N8hYXIBrRoM",
      "name": "Gmail",
      "createdAt": "2025-03-24T11:58:54.595Z",
      "updatedAt": "2025-03-24T11:58:54.595Z"
    }
  ],
  "nodes": [
    {
      "id": "cd138bff-e429-4223-ae6a-7ffcb70250ec",
      "name": "Get screenshots",
      "type": "n8n-nodes-base.httpRequest",
      "maxTries": 3,
      "position": [
        500,
        0
      ],
      "parameters": {
        "url": "https://api.screenshotone.com/take?",
        "options": {},
        "sendQuery": true,
        "sendHeaders": true,
        "queryParameters": {
          "parameters": [
            {
              "name": "url",
              "value": "={{ $json.Url }}"
            },
            {
              "name": "block_cookie_banners",
              "value": "true"
            }
          ]
        },
        "headerParameters": {
          "parameters": [
            {
              "name": "X-Access-Key",
              "value": "--YOUR SCREENSHOTONE ACCESS KEY--"
            }
          ]
        }
      },
      "executeOnce": false,
      "retryOnFail": true,
      "typeVersion": 4.2
    },
    {
      "id": "94825f14-fdef-41fe-ac5f-52da12e288e4",
      "name": "Get Urls",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        220,
        0
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "name",
          "value": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "id",
          "value": "={{ $json.id }}"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "025bc9b7-ffa0-44e5-903b-0a382c747119",
      "name": "Upload images to the same folder",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        740,
        0
      ],
      "parameters": {
        "name": "=screenshot_{{ $('Get schreenshots').item.json.Url }}",
        "driveId": {
          "__rl": true,
          "mode": "list",
          "value": "My Drive"
        },
        "options": {},
        "folderId": {
          "__rl": true,
          "mode": "id",
          "value": "={{ $('spreadsheets file with urls created').item.json.parents[0]}}"
        },
        "inputDataFieldName": "=data"
      },
      "typeVersion": 3
    },
    {
      "id": "83b6273b-1dbc-449d-9d4e-a580e3dfb9e0",
      "name": "spreadsheets file with urls created",
      "type": "n8n-nodes-base.googleDriveTrigger",
      "position": [
        -80,
        0
      ],
      "parameters": {
        "event": "fileCreated",
        "options": {
          "fileType": "application/vnd.google-apps.spreadsheet"
        },
        "pollTimes": {
          "item": [
            {
              "mode": "everyMinute"
            }
          ]
        },
        "triggerOn": "specificFolder",
        "folderToWatch": {
          "__rl": true,
          "mode": "id",
          "value": "--YOUR GOOGLE DRIVE FOLDER ID TO LISTEN--"
        }
      },
      "credentials": {
        "googleDriveOAuth2Api": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "dad9be9f-44b6-4f5b-a67e-33f99c29ab3d",
      "name": "Send email with folder link",
      "type": "n8n-nodes-base.gmail",
      "position": [
        980,
        0
      ],
      "parameters": {
        "sendTo": "--YOUR EMAIL ADDRESS--",
        "message": "=Your screenshots are ready!\nYou can find them in the following folder:\nhttps://drive.google.com/drive/folders/{{ $json.parents }}?usp=drive_link",
        "options": {},
        "subject": "Screenshots are ready",
        "emailType": "text"
      },
      "executeOnce": true,
      "typeVersion": 2.1
    },
    {
      "id": "68da222b-9960-49fb-b2c8-d2e0a8f68093",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -140,
        -240
      ],
      "parameters": {
        "content": "## This node initiates the workflow by monitoring the designated folder"
      },
      "typeVersion": 1
    },
    {
      "id": "e9679272-3aa3-4180-b9c5-9b223b7ef131",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        140,
        -240
      ],
      "parameters": {
        "height": 180,
        "content": "## Ensure your spreadsheet\u2019s \u2018Url.\u2019 column contains valid URLs"
      },
      "typeVersion": 1
    },
    {
      "id": "030a29bc-a180-45fa-9dc7-74831d1222e7",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        420,
        -240
      ],
      "parameters": {
        "height": 180,
        "content": "## Replace the placeholder with your actual ScreenshotOne  [Access key](https://dash.screenshotone.com/access)"
      },
      "typeVersion": 1
    },
    {
      "id": "a921e62a-cfc4-48cc-8202-555c6b65fc7d",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        900,
        -240
      ],
      "parameters": {
        "height": 180,
        "content": "## Review your email settings to ensure notifications are sent correctly"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "94542ebe-a9e6-406a-9ead-5e4ec094dbdd",
  "connections": {
    "Get Urls": {
      "main": [
        [
          {
            "node": "Get screenshots",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get screenshots": {
      "main": [
        [
          {
            "node": "Upload images to the same folder",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Upload images to the same folder": {
      "main": [
        [
          {
            "node": "Send email with folder link",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "spreadsheets file with urls created": {
      "main": [
        [
          {
            "node": "Get Urls",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

Credentials you'll need

Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.

Pro

For the full experience including quality scoring and batch install features for each workflow upgrade to Pro

About this workflow

This automation template streamlines the process of capturing screenshots for multiple URLs. Instead of manually visiting each URL, taking a screenshot, and organizing the results, this workflow automates everything. When a spreadsheet is added to a designated Google Drive…

Source: https://n8n.io/workflows/3321/ — original creator credit. Request a take-down →

More Email & Gmail workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.

Email & Gmail

Shopify and E-Commerce store owners often struggle to create engaging 3D videos from static product images. This workflow automates that entire process—from image upload to video delivery—so store own

Form Trigger, Google Drive, HTTP Request +2
Email & Gmail

This workflow automates the bulk generation and delivery of personalized certificates using Google Sheets, Google Slides, Google Drive, and Gmail.

HTTP Request, Google Drive, Google Sheets +1
Email & Gmail

Hiring teams often struggle with document follow-ups, offer letter generation, and stakeholder communication. Manual checks, email back-and-forth, and missing files slow down hiring and create chaos d

Google Sheets Trigger, HTTP Request, Slack +3
Email & Gmail

Paste your interview recording URL into a simple form, describe the moments you want to find, and the workflow takes care of everything else. WayinVideo AI scans the full recording and extracts only t

Form Trigger, HTTP Request, Google Drive +2
Email & Gmail

Submit a new employee's details and your onboarding recording URL via a simple form and the workflow automatically extracts the specific training moments relevant to that employee. WayinVideo's Find M

Form Trigger, HTTP Request, Google Drive +2