Automatisierte Erstellung von Upwork-Vorschlägen in Echtzeit mit Apify, Google Gemini und Sheets

Name: Automatisierte Erstellung von Upwork-Vorschlägen in Echtzeit mit Apify, Google Gemini und Sheets
Rating: 4.5 (10 reviews)
Author: Intuz

Experte

Dies ist ein Lead Generation, Multimodal AI-Bereich Automatisierungsworkflow mit 25 Nodes. Hauptsächlich werden If, Set, Gmail, Summarize, GoogleSheets und andere Nodes verwendet. Automatisierte Erstellung von KI-Upwork-Vorschlägen mit Apify, Google Gemini und Sheets

Voraussetzungen

•Google-Konto + Gmail API-Anmeldedaten
•Google Sheets API-Anmeldedaten
•Google Gemini API Key

Verwendete Nodes (25)

OutputParserStructured

Kategorie

Lead-Generierung

Multimodales KI

Workflow-Vorschau

Visualisierung der Node-Verbindungen, mit Zoom und Pan

Bei Klick auf 'Workflow ausführen'

Upwork Actor für gelistete Jobs ausführen

Dataset vom Upwork Actor abrufen

Extrahierten Daten in Sheets hinzufügen

Neue Jobs zählen

E-Mail-Benachrichtigung senden

Wenn

Google Gemini Chat Model

Structured Output Parser

Zeile(n) in Sheet abrufen

Felder bearbeiten

Nachricht senden

Zusammenfassen

Zeile in Sheet anhängen/aktualisieren

Angebotserstellung

React Flow

Workflow exportieren

Kopieren Sie die folgende JSON-Konfiguration und importieren Sie sie in n8n

{
  "id": "h7kye1TyifE8jVpQ",
  "meta": {
    "instanceId": "1a54c41d9050a8f1fa6f74ca858828ad9fb97b9fafa3e9760e576171c531a787"
  },
  "name": "Live-Automate AI Upwork Proposal Generation with Apify, Google Gemini & Sheets",
  "tags": [],
  "nodes": [
    {
      "id": "6de5e3c9-fbef-4fbb-863f-2f100e802601",
      "name": "Bei Klick auf 'Workflow ausführen'",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -256,
        240
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "ac26904f-2ee9-4417-bf60-3f059686c0be",
      "name": "Upwork Actor für gelistete Jobs ausführen",
      "type": "@apify/n8n-nodes-apify.apify",
      "position": [
        64,
        240
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "c86c636f-e414-4ba9-98d1-26a2f2a26175",
      "name": "Dataset vom Upwork Actor abrufen",
      "type": "@apify/n8n-nodes-apify.apify",
      "position": [
        288,
        240
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "78dd55ae-37a3-4178-9e70-167dd21666c2",
      "name": "Extrahierten Daten in Sheets hinzufügen",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        656,
        240
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "eb2586a4-6bb2-4302-acf5-5efe6e495076",
      "name": "Neue Jobs zählen",
      "type": "n8n-nodes-base.summarize",
      "position": [
        1008,
        240
      ],
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "6906f045-15e7-4bab-a0a4-97bcd6466257",
      "name": "E-Mail-Benachrichtigung senden",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1360,
        240
      ],
      "webhookId": "57c8be7f-1f81-469e-81b0-448ef55d6e2f",
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "06bbaf29-c309-484e-a711-0d6c3f7c3140",
      "name": "Haftnotiz",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        -48
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "d1013079-63ff-4c95-8974-fdf077c5412d",
      "name": "Haftnotiz 1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        576,
        96
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "e9ccf231-e7cd-42b6-a4ec-774e7a375c61",
      "name": "Haftnotiz 2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        928,
        112
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "c9f81e8f-c955-47bc-9f63-963b7c8de3b6",
      "name": "Haftnotiz 3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1280,
        96
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "070434c0-5503-455d-9e69-90522afac0e5",
      "name": "Wenn",
      "type": "n8n-nodes-base.if",
      "position": [
        32,
        560
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "42496b60-1d0a-41b7-be95-262981058f6a",
      "name": "Google Gemini Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        464,
        976
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "efee4d21-e839-4b5f-8c87-6234c6e44f11",
      "name": "Structured Output Parser",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        624,
        976
      ],
      "parameters": {},
      "typeVersion": 1.3
    },
    {
      "id": "963eef64-a1d1-4a1e-9266-93984739f118",
      "name": "Zeile(n) in Sheet abrufen",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -256,
        560
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "a84799f2-70ef-4980-81c3-afc7a8b51c91",
      "name": "Felder bearbeiten",
      "type": "n8n-nodes-base.set",
      "position": [
        848,
        560
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "9a168243-ebcf-4b0d-9761-cdec750908ff",
      "name": "Nachricht senden",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1664,
        560
      ],
      "webhookId": "57c8be7f-1f81-469e-81b0-448ef55d6e2f",
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "1723dd54-0806-4d3e-bf2e-53ddc5acd929",
      "name": "Zusammenfassen",
      "type": "n8n-nodes-base.summarize",
      "position": [
        1376,
        560
      ],
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "e3573056-1527-43b7-b724-03ac0f693dad",
      "name": "Zeile in Sheet anhängen/aktualisieren",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1184,
        560
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "e42d7f08-c1ab-4e08-bf9e-bc97d842de4b",
      "name": "Haftnotiz 4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -640,
        528
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "df087f1e-c45a-4363-a076-b28bfd0606cf",
      "name": "Haftnotiz 5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -80,
        688
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "33a8cdb2-5908-4201-ba34-9f52b641aaa4",
      "name": "Angebotserstellung",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        464,
        816
      ],
      "parameters": {},
      "typeVersion": 1.7
    },
    {
      "id": "26408e94-bf72-493d-8123-583aace9921f",
      "name": "Haftnotiz 6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        816,
        720
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "ebeb68c3-ac91-4bd0-91e4-03272cdf8c50",
      "name": "Haftnotiz 7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1536,
        400
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "492bac5d-11ce-45a1-9e57-2475b8895b85",
      "name": "Haftnotiz 8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1136,
        736
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "5d88a224-02ac-4c9d-8861-bd860673ce66",
      "name": "Haftnotiz 9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        352,
        496
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "72a480b8-38e5-4c96-b924-d07bad552e18",
  "connections": {
    "070434c0-5503-455d-9e69-90522afac0e5": {
      "main": [
        [
          {
            "node": "33a8cdb2-5908-4201-ba34-9f52b641aaa4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "1723dd54-0806-4d3e-bf2e-53ddc5acd929": {
      "main": [
        [
          {
            "node": "9a168243-ebcf-4b0d-9761-cdec750908ff",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "a84799f2-70ef-4980-81c3-afc7a8b51c91": {
      "main": [
        [
          {
            "node": "e3573056-1527-43b7-b724-03ac0f693dad",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "33a8cdb2-5908-4201-ba34-9f52b641aaa4": {
      "main": [
        [
          {
            "node": "a84799f2-70ef-4980-81c3-afc7a8b51c91",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "eb2586a4-6bb2-4302-acf5-5efe6e495076": {
      "main": [
        [
          {
            "node": "6906f045-15e7-4bab-a0a4-97bcd6466257",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "963eef64-a1d1-4a1e-9266-93984739f118": {
      "main": [
        [
          {
            "node": "070434c0-5503-455d-9e69-90522afac0e5",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "6906f045-15e7-4bab-a0a4-97bcd6466257": {
      "main": [
        [
          {
            "node": "963eef64-a1d1-4a1e-9266-93984739f118",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "42496b60-1d0a-41b7-be95-262981058f6a": {
      "ai_languageModel": [
        [
          {
            "node": "33a8cdb2-5908-4201-ba34-9f52b641aaa4",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "efee4d21-e839-4b5f-8c87-6234c6e44f11": {
      "ai_outputParser": [
        [
          {
            "node": "33a8cdb2-5908-4201-ba34-9f52b641aaa4",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "e3573056-1527-43b7-b724-03ac0f693dad": {
      "main": [
        [
          {
            "node": "1723dd54-0806-4d3e-bf2e-53ddc5acd929",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "78dd55ae-37a3-4178-9e70-167dd21666c2": {
      "main": [
        [
          {
            "node": "eb2586a4-6bb2-4302-acf5-5efe6e495076",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ac26904f-2ee9-4417-bf60-3f059686c0be": {
      "main": [
        [
          {
            "node": "c86c636f-e414-4ba9-98d1-26a2f2a26175",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "c86c636f-e414-4ba9-98d1-26a2f2a26175": {
      "main": [
        [
          {
            "node": "78dd55ae-37a3-4178-9e70-167dd21666c2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "6de5e3c9-fbef-4fbb-863f-2f100e802601": {
      "main": [
        [
          {
            "node": "ac26904f-2ee9-4417-bf60-3f059686c0be",
            "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?

Experte - Lead-Generierung, 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.