Automatisierte URL-Screenshots: Google Tabellen + ScreenshotOne mit E-Mail-Benachrichtigung

• •Google-Konto + Gmail API-Anmeldedaten
• •Google Drive API-Anmeldedaten
• •Möglicherweise sind Ziel-API-Anmeldedaten erforderlich
• •Google Sheets API-Anmeldedaten

{
  "id": "rVZ45LaNVNhJI9Fi",
  "meta": {
    "instanceId": "30cb288538cc1d60f7858cc4f67b4e877a90549434f7edd08c97301dabbccb6c"
  },
  "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": "Screenshots abrufen",
      "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": "URLs abrufen",
      "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": "Bilder in denselben Ordner hochladen",
      "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": "Tabellendatei mit URLs erstellt",
      "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": {
          "id": "MDuPeE9G7Xl1N6Uc",
          "name": "nikushac@gmail.com"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "dad9be9f-44b6-4f5b-a67e-33f99c29ab3d",
      "name": "E-Mail mit Ordnerlink senden",
      "type": "n8n-nodes-base.gmail",
      "position": [
        980,
        0
      ],
      "webhookId": "243e0e93-4216-4206-95a3-4dccc3f328c7",
      "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": "Notizzettel",
      "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": "Notizzettel1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        140,
        -240
      ],
      "parameters": {
        "height": 180,
        "content": "## Ensure your spreadsheet’s ‘Url.’ column contains valid URLs"
      },
      "typeVersion": 1
    },
    {
      "id": "030a29bc-a180-45fa-9dc7-74831d1222e7",
      "name": "Notizzettel2",
      "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": "Notizzettel3",
      "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,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "94542ebe-a9e6-406a-9ead-5e4ec094dbdd",
  "connections": {
    "94825f14-fdef-41fe-ac5f-52da12e288e4": {
      "main": [
        [
          {
            "node": "cd138bff-e429-4223-ae6a-7ffcb70250ec",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "cd138bff-e429-4223-ae6a-7ffcb70250ec": {
      "main": [
        [
          {
            "node": "025bc9b7-ffa0-44e5-903b-0a382c747119",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "025bc9b7-ffa0-44e5-903b-0a382c747119": {
      "main": [
        [
          {
            "node": "dad9be9f-44b6-4f5b-a67e-33f99c29ab3d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "83b6273b-1dbc-449d-9d4e-a580e3dfb9e0": {
      "main": [
        [
          {
            "node": "94825f14-fdef-41fe-ac5f-52da12e288e4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}