Automatisez vos recherches de domaine avec Icypeas et Google Sheets

{
    "meta": {
        "instanceId": "257476b1ef58bf3cb6a46e65fac7ee34a53a5e1a8492d5c6e4da5f87c9b82833"
    },
    "nodes": [
        {
            "id": "bfbd4299-0c8d-4368-b156-c76602ca068c",
            "name": "When clicking \"Execute Workflow\"",
            "type": "n8n-nodes-base.manualTrigger",
            "position": [
                640,
                1700
            ],
            "parameters": [],
            "typeVersion": 1
        },
        {
            "id": "40cf87be-d9fc-434b-9099-0151968d2a0b",
            "name": "Sticky Note",
            "type": "n8n-nodes-base.stickyNote",
            "position": [
                500,
                1420
            ],
            "parameters": {
                "height": 259,
                "content": "## Domain scan with Icypeas (bulk search)\n\n\nThis workflow demonstrates how to perform domain scans (bulk search) using Icypeas. Visit https:\/\/icypeas.com to create your account."
            },
            "typeVersion": 1
        },
        {
            "id": "c646dddb-bcd4-4ac8-b08f-e61ec16c99c5",
            "name": "Authenticates to your Icypeas account",
            "type": "n8n-nodes-base.code",
            "position": [
                1140,
                1700
            ],
            "parameters": {
                "jsCode": "const API_BASE_URL = \"https:\/\/app.icypeas.com\/api\";\nconst API_PATH = \"\/bulk-search\";\nconst METHOD = \"POST\";\n\n\/\/ Change here\nconst API_KEY = \"PUT_API_KEY_HERE\";\nconst API_SECRET = \"PUT_API_SECRET_HERE\";\nconst USER_ID = \"PUT_USER_ID_HERE\";\n\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\nconst genSignature = (\n    url,\n    method,\n    secret,\n    timestamp = new Date().toISOString()\n) => {\n    const Crypto = require('crypto');\n    const payload = `${method}${url}${timestamp}`.toLowerCase();\n    const sign = Crypto.createHmac(\"sha1\", secret).update(payload).digest(\"hex\");\n\n    return sign;\n};\n\nconst apiUrl = `${API_BASE_URL}${API_PATH}`;\n\nconst data = $input.all().map((x) => [ x.json.company]);\n$input.first().json.data = data;\n$input.first().json.api = {\n  timestamp: new Date().toISOString(),\n  secret: API_SECRET,\n  key: API_KEY,\n  userId: USER_ID,\n  url: apiUrl,\n};\n\n$input.first().json.api.signature = genSignature(apiUrl, METHOD, API_SECRET, $input.first().json.api.timestamp);\nreturn $input.first();"
            },
            "typeVersion": 1
        },
        {
            "id": "f0fcf039-2508-429e-8b9a-4ec1ab929d97",
            "name": "Sticky Note1",
            "type": "n8n-nodes-base.stickyNote",
            "position": [
                780,
                1548.9314213779933
            ],
            "parameters": {
                "height": 523.2083276562503,
                "content": "## Read your Google sheet file\n\nThis node reads a Google Sheet. You need to create a sheet with :\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n**The first column** :\nHeader : company\n\n\n\n\nDon't forget to specify the path of your file in the node and your credentials."
            },
            "typeVersion": 1
        },
        {
            "id": "1d0d1805-f664-44d3-83be-9ea26d43526c",
            "name": "Sticky Note3",
            "type": "n8n-nodes-base.stickyNote",
            "position": [
                1021.0092314499475,
                1458.51011235955
            ],
            "parameters": {
                "width": 392.0593078758952,
                "height": 1203.3290499048028,
                "content": "## Authenticates to your Icypeas account\n\nThis code node utilizes your API key, API secret, and User ID to establish a connection with your Icypeas account.\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nOpen this node and insert your API Key, API secret, and User ID within the quotation marks. You can locate these credentials on your Icypeas profile at https:\/\/app.icypeas.com\/bo\/profile. Here is the extract of what you have to change :\n\nconst API_KEY = \"**PUT_API_KEY_HERE**\";\nconst API_SECRET = \"**PUT_API_SECRET_HERE**\";\nconst USER_ID = \"**PUT_USER_ID_HERE**\";\n\nDo not change any other line of the code.\n\nIf you are a self-hosted user, follow these steps to activate the crypto module :\n\n1.Access your n8n instance:\nLog in to your n8n instance using your web browser by navigating to the URL of your instance, for example: http:\/\/your-n8n-instance.com.\n\n2.Go to Settings:\nIn the top-right corner, click on your username, then select \"Settings.\"\n\n3.Select General Settings:\nIn the left menu, click on \"General.\"\n\n4.Enable the Crypto module:\nScroll down to the \"Additional Node Packages\" section. You will see an option called \"crypto\" with a checkbox next to it. Check this box to enable the Crypto module.\n\n5.Save the changes:\nAt the bottom of the page, click \"Save\" to apply the changes.\n\nOnce you've followed these steps, the Crypto module should be activated for your self-hosted n8n instance. Make sure to save your changes and optionally restart your n8n instance for the changes to take effect.\n\n\n\n\n\n"
            },
            "typeVersion": 1
        },
        {
            "id": "999fda2a-50ba-4641-8842-7d62587e0ad5",
            "name": "Sticky Note4",
            "type": "n8n-nodes-base.stickyNote",
            "position": [
                1413,
                1460
            ],
            "parameters": {
                "width": 328.8456933308303,
                "height": 869.114109302513,
                "content": "## Performs domain scans (bulk).\n\n\nThis node executes an HTTP request (POST) to scan the domains\/companies.\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n### You need to create credentials in the HTTP Request node :\n\n➔ In the Credential for Header Auth, click on - Create new Credential -.\n➔ In the Name section, write “Authorization”\n➔ In the Value section, select expression (located just above the field on the right when you hover on top of it) and write {{ $json.api.key + ':' + $json.api.signature }} .\n➔ Then click on “Save” to save the changes.\n\n### To retrieve the results :\n\nAfter some time, the results, which are downloadable, will be available in the Icypeas application  in this section : https:\/\/app.icypeas.com\/bo\/bulksearch?task=domain-search, and you will receive the scan results via email from no-reply@icypeas.com, providing you with the results of your scans.\n\n\n\n\n"
            },
            "typeVersion": 1
        },
        {
            "id": "0f5382ae-cd84-47a7-9818-ad252c9d62c3",
            "name": "Reads lastname,firstname and company from your sheet",
            "type": "n8n-nodes-base.googleSheets",
            "position": [
                840,
                1700
            ],
            "parameters": {
                "sheetName": {
                    "__rl": true,
                    "mode": "list",
                    "value": ""
                },
                "documentId": {
                    "__rl": true,
                    "mode": "list",
                    "value": ""
                }
            },
            "typeVersion": 4.1
        },
        {
            "id": "ce00b713-6ddc-4625-a9cc-e9badc2022d4",
            "name": "Run bulk search (domain-search)",
            "type": "n8n-nodes-base.httpRequest",
            "position": [
                1480,
                1700
            ],
            "parameters": {
                "url": "={{ $json.api.url }}",
                "method": "POST",
                "options": [],
                "sendBody": true,
                "sendHeaders": true,
                "authentication": "genericCredentialType",
                "bodyParameters": {
                    "parameters": [
                        {
                            "name": "task",
                            "value": "=domain-search"
                        },
                        {
                            "name": "name",
                            "value": "dernierT"
                        },
                        {
                            "name": "user",
                            "value": "={{ $json.api.userId }}"
                        },
                        {
                            "name": "data",
                            "value": "={{ $json.data }}"
                        }
                    ]
                },
                "genericAuthType": "httpHeaderAuth",
                "headerParameters": {
                    "parameters": [
                        {
                            "name": "X-ROCK-TIMESTAMP",
                            "value": "={{ $json.api.timestamp }}"
                        }
                    ]
                }
            },
            "typeVersion": 4.1
        }
    ],
    "pinData": [],
    "connections": {
        "When clicking \"Execute Workflow\"": {
            "main": [
                [
                    {
                        "node": "Reads lastname,firstname and company from your sheet",
                        "type": "main",
                        "index": 0
                    }
                ]
            ]
        },
        "Authenticates to your Icypeas account": {
            "main": [
                [
                    {
                        "node": "Run bulk search (domain-search)",
                        "type": "main",
                        "index": 0
                    }
                ]
            ]
        },
        "Reads lastname,firstname and company from your sheet": {
            "main": [
                [
                    {
                        "node": "Authenticates to your Icypeas account",
                        "type": "main",
                        "index": 0
                    }
                ]
            ]
        }
    }
}