Verwenden Sie GPT-4.1 mini, um natürliche Sprache in Web-Suchanfragen umzuwandeln und in Google Sheets zu protokollieren

Fortgeschritten

Dies ist ein Content Creation, Multimodal AI-Bereich Automatisierungsworkflow mit 14 Nodes. Hauptsächlich werden Webhook, HttpRequest, GoogleSheets, Agent, HttpRequestTool und andere Nodes verwendet. Konvertieren Sie natürliche Sprache in Websuchen und loggen Sie sich mit GPT-4.1 mini in Google Sheets ein

Voraussetzungen
  • HTTP Webhook-Endpunkt (wird von n8n automatisch generiert)
  • Möglicherweise sind Ziel-API-Anmeldedaten erforderlich
  • Google Sheets API-Anmeldedaten
Workflow-Vorschau
Visualisierung der Node-Verbindungen, mit Zoom und Pan
Workflow exportieren
Kopieren Sie die folgende JSON-Konfiguration und importieren Sie sie in n8n
{
  "meta": {
    "instanceId": "0a25db4fd0692af64b58f35e01611f2ef0b5bb9d6654c57ef3741021e7d8cc11",
    "templateId": "6343",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "d324309d-a8e6-49a7-9aba-6539822ccc09",
      "name": "Site",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        640,
        256
      ],
      "parameters": {
        "url": "https://api.firecrawl.dev/v1/search",
        "method": "POST",
        "options": {},
        "jsonBody": "{\n  \"query\": \"nate herk site:www.geeky-gadgets.com\",\n  \"limit\": 5\n}",
        "sendBody": true,
        "sendHeaders": true,
        "specifyBody": "json",
        "headerParameters": {
          "parameters": [
            {}
          ]
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "0aea3a14-37ac-46c6-8e8c-a12c3750e801",
      "name": "In URL",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        640,
        448
      ],
      "parameters": {
        "url": "https://api.firecrawl.dev/v1/search",
        "method": "POST",
        "options": {},
        "jsonBody": "{\n  \"query\": \"nate herk inurl:skool\",\n  \"limit\": 5\n}",
        "sendBody": true,
        "sendHeaders": true,
        "specifyBody": "json",
        "headerParameters": {
          "parameters": [
            {}
          ]
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "f6c6becf-a6de-4523-846b-9ec51d485a2f",
      "name": "Exclusion",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        864,
        256
      ],
      "parameters": {
        "url": "https://api.firecrawl.dev/v1/search",
        "method": "POST",
        "options": {},
        "jsonBody": "{\n  \"query\": \"nate herk -inurl:skool\",\n  \"limit\": 6\n}",
        "sendBody": true,
        "sendHeaders": true,
        "specifyBody": "json",
        "headerParameters": {
          "parameters": [
            {}
          ]
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "8107f822-b505-4158-8c13-8f1bf7774db0",
      "name": "Pro",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        864,
        448
      ],
      "parameters": {
        "url": "https://api.firecrawl.dev/v1/search",
        "method": "POST",
        "options": {},
        "jsonBody": "{\n  \"query\": \"Nate Herk site:youtube.com -shorts intitle:automation\",\n  \"limit\": 5\n}",
        "sendBody": true,
        "sendHeaders": true,
        "specifyBody": "json",
        "headerParameters": {
          "parameters": [
            {}
          ]
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "d0a5315a-1d4a-41a7-b68c-ab31686370e1",
      "name": "GPT 4.1 mini",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
      "position": [
        304,
        576
      ],
      "parameters": {
        "options": {}
      },
      "credentials": {
        "openRouterApi": {
          "id": "d5XqPDl5wyBTf7S8",
          "name": "OpenRouter account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "19753a83-34d3-4d61-a1ab-4d7d90f5245d",
      "name": "Firecrawl Search",
      "type": "n8n-nodes-base.httpRequestTool",
      "position": [
        432,
        576
      ],
      "parameters": {
        "url": "https://api.firecrawl.dev/v1/search",
        "method": "POST",
        "options": {},
        "jsonBody": "={\n  \"query\": \"{{$fromAI(\"searchQuery\")}}\",\n  \"limit\": {{$fromAI(\"limit\",\"the number of search results requested\", number)}},\n  \"scrapeOptions\": {\n  \"formats\": [\"markdown\", \"screenshot@fullPage\"]}\n}",
        "sendBody": true,
        "specifyBody": "json",
        "toolDescription": "Use this tool to search the internet"
      },
      "typeVersion": 4.2
    },
    {
      "id": "34fa76be-ef2a-4962-9ff1-9d5268525e5f",
      "name": "Search Agent",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        288,
        352
      ],
      "parameters": {
        "options": {
          "systemMessage": "=# Overview\nYou are a Firecrawl Search Query Generator Agent.\n\nYou have access to a tool called FireCrawl Search.\n\nYour job is to:\n1. Convert natural language instructions into a properly formatted Firecrawl query string using supported operators.\n2. Send that query — along with a `limit` parameter — to the **FireCrawl Search** tool.\n\n## Query Construction Rules:\n\nUse the following rules to transform user input:\n\n- If the user specifies an exact phrase  \n  → `Nate Herk`\n\n- To exclude terms or domains, prefix them with `-`  \n  → `-linkedin`, `-site:facebook.com`\n\n- If the user wants to search within a specific site, use `site:`  \n  → `site:youtube.com`\n\n- If the user wants a word in the URL, use `inurl:`  \n  → `inurl:nateherk`\n\n- If the user wants multiple words in the URL, use `allinurl:`  \n  → `allinurl:nate herk agent`\n\n- If the user wants a word in the title of the page, use `intitle:`  \n  → `intitle:automation`\n\n- If the user wants multiple words in the title, use `allintitle:`  \n  → `allintitle:ai agent tutorial`\n\n- If the user wants results related to a domain, use `related:`  \n  → `related:truehorizonai.com`\n\n\n## Tool Usage Instructions:\n\nAlways call the **FireCrawls Search** tool with:\n- `query`: the final constructed query string  \n- `limit`: the number of results the user requested\n\nIf the user does **not specify a limit**, default to:  \n→ `limit: 5`\n\n## Output\n\nAlways return all of the important information for each item that the tool gives you. The the title, the URL, the results, etc. \n\nFor each 'data' object that is returned in the results, output every field that lives in that object.\n\n## Examples:\n\n**Input:** Search the internet for Nate Herk  \n**Action:** Call FireCrawls Search with:  \n```json\n{\n  \"query\": Nate Herk,\n  \"limit\": 5\n}\n```\n\n**Input:** Find pages with AI agent in the title from YouTube, show me 10  \n**Action:**  \n```json\n{\n  \"query\": intitle:AI agent site:youtube.com,\n  \"limit\": 10\n}\n```\n\n**Input:** Show me results that mention Nate Herk but exclude LinkedIn  \n**Action:**  \n```json\n{\n  \"query\": Nate Herk -site:linkedin.com,\n  \"limit\": 5\n}\n```\n"
        }
      },
      "typeVersion": 2
    },
    {
      "id": "0cf2ace2-d00e-4234-8ff1-3118951db009",
      "name": "Webhook",
      "type": "n8n-nodes-base.webhook",
      "position": [
        64,
        352
      ],
      "webhookId": "0d916768-023f-4d0e-8b76-4cbd5ffa07ee",
      "parameters": {
        "path": "0d916768-023f-4d0e-8b76-4cbd5ffa07ee",
        "options": {}
      },
      "typeVersion": 2.1
    },
    {
      "id": "a59522c9-c0af-42cf-ba29-c517482549ba",
      "name": "Zeile in Tabelle anhängen",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1088,
        352
      ],
      "parameters": {
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1EAA7t2lal9462X_CHmfZQ7LbAVsbrrkpGN1hpDI0p8o/edit#gid=0",
          "cachedResultName": "Tabellenblatt1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1EAA7t2lal9462X_CHmfZQ7LbAVsbrrkpGN1hpDI0p8o",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1EAA7t2lal9462X_CHmfZQ7LbAVsbrrkpGN1hpDI0p8o/edit?usp=drivesdk",
          "cachedResultName": "Founders Academy Waitlist"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "cjPjcwa3RdiMAu79",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "e16d710a-2d50-4209-b2b3-be66df110e09",
      "name": "Auf Webhook antworten",
      "type": "n8n-nodes-base.respondToWebhook",
      "position": [
        1312,
        352
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 1.4
    },
    {
      "id": "9c0850a0-d487-4be7-817f-89dc4722bb88",
      "name": "Haftnotiz",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -304,
        176
      ],
      "parameters": {
        "color": 4,
        "width": 520,
        "height": 140,
        "content": "## STEP 1 · Entry & Orchestration\n**Webhook** receives a natural-language search request.\n**Search Agent** (LLM) turns it into a Firecrawl query + limit and calls the tool.\nGoal: standardize queries and run repeatable searches."
      },
      "typeVersion": 1
    },
    {
      "id": "473b66f3-9de2-4484-bb12-9f6e3f991c04",
      "name": "Haftnotiz1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        288,
        16
      ],
      "parameters": {
        "color": 5,
        "width": 280,
        "height": 268,
        "content": "## STEP 2 · Agent & Tooling\n**LLM (OpenRouter)** powers the Search Agent.\n**Firecrawl Search tool** gets `query` + `limit` and returns results (incl. markdown / screenshots if enabled).\nTip: default to `limit: 5` when none provided."
      },
      "typeVersion": 1
    },
    {
      "id": "19065dd3-d693-4ed5-9d98-0a13cfe02d82",
      "name": "Haftnotiz2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        624,
        0
      ],
      "parameters": {
        "color": 6,
        "width": 432,
        "height": 218,
        "content": "## STEP 3 · Targeted Queries (HTTP)\nRuns multiple Firecrawl searches:\n• **Site:** `nate herk site:geeky-gadgets.com`\n• **In URL:** `nate herk inurl:skool`\n• **Exclusion:** `nate herk -inurl:skool`\n• **Pro (YouTube):** `Nate Herk site:youtube.com -shorts intitle:automation`\nUse these as parallel facets to widen coverage."
      },
      "typeVersion": 1
    },
    {
      "id": "826d9e61-6e3f-4ea4-a5b1-fdc2b754e116",
      "name": "Haftnotiz3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1088,
        144
      ],
      "parameters": {
        "color": 7,
        "width": 520,
        "height": 140,
        "content": "## STEP 4 · Persist & Respond\n**Append row in sheet** writes search outputs to Google Sheets.\n**Respond to Webhook** returns results to the caller.\nTip: map fields you want to persist (titles, urls, snippet, etc.)."
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "8107f822-b505-4158-8c13-8f1bf7774db0": {
      "main": [
        [
          {
            "node": "a59522c9-c0af-42cf-ba29-c517482549ba",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "d324309d-a8e6-49a7-9aba-6539822ccc09": {
      "main": [
        [
          {
            "node": "f6c6becf-a6de-4523-846b-9ec51d485a2f",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "0aea3a14-37ac-46c6-8e8c-a12c3750e801": {
      "main": [
        [
          {
            "node": "8107f822-b505-4158-8c13-8f1bf7774db0",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "0cf2ace2-d00e-4234-8ff1-3118951db009": {
      "main": [
        [
          {
            "node": "34fa76be-ef2a-4962-9ff1-9d5268525e5f",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "f6c6becf-a6de-4523-846b-9ec51d485a2f": {
      "main": [
        [
          {
            "node": "a59522c9-c0af-42cf-ba29-c517482549ba",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "d0a5315a-1d4a-41a7-b68c-ab31686370e1": {
      "ai_languageModel": [
        [
          {
            "node": "34fa76be-ef2a-4962-9ff1-9d5268525e5f",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "34fa76be-ef2a-4962-9ff1-9d5268525e5f": {
      "main": [
        [
          {
            "node": "d324309d-a8e6-49a7-9aba-6539822ccc09",
            "type": "main",
            "index": 0
          },
          {
            "node": "0aea3a14-37ac-46c6-8e8c-a12c3750e801",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "19753a83-34d3-4d61-a1ab-4d7d90f5245d": {
      "ai_tool": [
        [
          {
            "node": "34fa76be-ef2a-4962-9ff1-9d5268525e5f",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "a59522c9-c0af-42cf-ba29-c517482549ba": {
      "main": [
        [
          {
            "node": "e16d710a-2d50-4209-b2b3-be66df110e09",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
Häufig gestellte Fragen

Wie verwende ich diesen Workflow?

Kopieren Sie den obigen JSON-Code, erstellen Sie einen neuen Workflow in Ihrer n8n-Instanz und wählen Sie "Aus JSON importieren". Fügen Sie die Konfiguration ein und passen Sie die Anmeldedaten nach Bedarf an.

Für welche Szenarien ist dieser Workflow geeignet?

Fortgeschritten - Content-Erstellung, Multimodales KI

Ist es kostenpflichtig?

Dieser Workflow ist völlig kostenlos. Beachten Sie jedoch, dass Drittanbieterdienste (wie OpenAI API), die im Workflow verwendet werden, möglicherweise kostenpflichtig sind.

Verwandte Workflows

Automatisierte Lead-Anrufe: VAPI, Google Sheets-Protokollierung und Kalendertermine
Automatisierung der Lead-Anrufe: VAPI, Google Sheets-Protokollierung und Kalendereinbuchung
Set
Code
Webhook
+
Set
Code
Webhook
13 NodesMeak
Content-Erstellung
Automatisierung von Bildbearbeitung und Instagram-Veröffentlichung mit Nano Banana + GPT-5
Automatisierung der Bildbearbeitung und Instagram-Veröffentlichung durch Nano Banana und GPT-5
If
Wait
Http Request
+
If
Wait
Http Request
19 NodesMeak
Content-Erstellung
AI-Lead-Scoring und -Routing (Google Gemini, Sheets und Slack-Benachrichtigung)
AI-Lead-Scoring und -Routing (Google Gemini, Sheets und Slack-Benachrichtigung)
Set
Merge
Slack
+
Set
Merge
Slack
13 NodesMeak
Content-Erstellung
KI-gesteuertes Lebensmittelbestellverarbeitungssystem, integriert mit Facebook Messenger, Google Tabellen und Kalender
KI-gesteuertes Lebensmittelbestellverarbeitungssystem, integriert mit Facebook Messenger, Google Tabellen und Kalender
If
Code
Webhook
+
If
Code
Webhook
26 NodesHans Wilhelm Radam
Lead-Pflege
Automatische Veröffentlichung von Instagram-Karussells mit Google Sheets, Drive, Cloudinary und Graph API
Automatisches Veröffentlichen von Instagram-Karussells mit Google Sheets, Drive, Cloudinary und Graph API
Set
Aggregate
Google Drive
+
Set
Aggregate
Google Drive
15 NodesMeak
Content-Erstellung
Automatisierte Bewerbungsjagd von mehreren Jobbörsen
Automatisierung der Jobsuche und -Bewerbung mit 5 Jobplattformen und AI-Lebenslaufgenerator
If
Set
Code
+
If
Set
Code
34 NodesGerald Denor
Persönliche Produktivität
Workflow-Informationen
Schwierigkeitsgrad
Fortgeschritten
Anzahl der Nodes14
Kategorie2
Node-Typen8
Schwierigkeitsbeschreibung

Für erfahrene Benutzer, mittelkomplexe Workflows mit 6-15 Nodes

Autor
Meak

Meak

@meak

I help people build $5k+/month online by starting their own AI agency. Without BS.

Externe Links
Auf n8n.io ansehen

Diesen Workflow teilen

Kategorien

Kategorien: 34