AutomationFlowsEmail & Gmail › Look for New Usecases

Look for New Usecases

Look for new UseCases. Uses googleSheets, openAi, gmail. Scheduled trigger; 7 nodes.

Cron / scheduled trigger★★★★☆ complexityAI-powered7 nodesGoogle SheetsOpenAIGmail
Email & Gmail Trigger: Cron / scheduled Nodes: 7 Complexity: ★★★★☆ AI nodes: yes Added:

This workflow follows the Gmail → Google Sheets 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
{
  "name": "Look for new UseCases",
  "nodes": [
    {
      "parameters": {
        "rule": {
          "interval": [
            {
              "daysInterval": 2,
              "triggerAtHour": 18
            }
          ]
        }
      },
      "type": "n8n-nodes-base.scheduleTrigger",
      "typeVersion": 1.2,
      "position": [
        0,
        0
      ],
      "id": "d0324398-d6e3-4240-b726-aa95391da532",
      "name": "Schedule Trigger"
    },
    {
      "parameters": {
        "documentId": {
          "__rl": true,
          "value": "https://docs.google.com/spreadsheets/d/137r7IASQtPOdFFVyHlrrhSzYUwVVyOXv8_IRnydcP5E/edit?gid=0#gid=0",
          "mode": "url"
        },
        "sheetName": {
          "__rl": true,
          "value": "gid=0",
          "mode": "list",
          "cachedResultName": "UseCases",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/137r7IASQtPOdFFVyHlrrhSzYUwVVyOXv8_IRnydcP5E/edit#gid=0"
        },
        "options": {
          "dataLocationOnSheet": {
            "values": {
              "rangeDefinition": "specifyRangeA1",
              "range": "A:C"
            }
          },
          "outputFormatting": {
            "values": {
              "general": "UNFORMATTED_VALUE",
              "date": "FORMATTED_STRING"
            }
          }
        }
      },
      "type": "n8n-nodes-base.googleSheets",
      "typeVersion": 4.6,
      "position": [
        240,
        0
      ],
      "id": "b342e1e3-f6eb-43b6-81dd-b240181b69b2",
      "name": "Google Sheets",
      "credentials": {
        "googleSheetsOAuth2Api": {
          "name": "<your credential>"
        }
      }
    },
    {
      "parameters": {
        "modelId": {
          "__rl": true,
          "value": "gpt-4.1",
          "mode": "list",
          "cachedResultName": "GPT-4.1"
        },
        "messages": {
          "values": [
            {
              "content": "=\u0417\u0434\u0435\u0441\u044c \u0441\u043f\u0438\u0441\u043e\u043a \u0443\u0436\u0435 \u0440\u0430\u043d\u0435\u0435 \u0438\u0437\u0432\u0435\u0441\u0442\u043d\u044b\u0445 UseCases:\n\n{{ $json[\"known_titles\"] }}\n\n\u041d\u0430\u0439\u0434\u0438 \u0432 \u0438\u043d\u0442\u0435\u0440\u043d\u0435\u0442\u0435 \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u044e \u043e \u043d\u043e\u0432\u044b\u0445, \u043f\u0435\u0440\u0441\u043f\u0435\u043a\u0442\u0438\u0432\u043d\u044b\u0445 UseCases, \u0433\u0434\u0435 \u043c\u043e\u0436\u043d\u043e \u043f\u0440\u0438\u043c\u0435\u043d\u0438\u0442\u044c AI \u0430\u0433\u0435\u043d\u0442\u043e\u0432 \u0432 \u043c\u0430\u043b\u043e\u043c \u0438 \u0441\u0440\u0435\u0434\u043d\u0435\u043c  \u0431\u0438\u0437\u043d\u0435\u0441\u0435 \u0434\u043b\u0430 \u0441\u043d\u0438\u0436\u0435\u043d\u0438\u044f \u0432\u0440\u0435\u043c\u0435\u043d\u043d\u044b\u0445 \u0438 \u0444\u0438\u043d\u0430\u043d\u0441\u043e\u0432\u044b\u0445 \u0437\u0430\u0442\u0440\u0430\u0442 \u0437\u0430 \u0441\u0447\u0435\u0442 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u044f AI \u0432\u043c\u0435\u0441\u0442\u043e \u0442\u0440\u0443\u0434\u0430 \u0441\u043e\u0442\u0440\u0443\u0434\u043d\u0438\u043a\u043e\u0432. \u0418\u0449\u0438 \u043d\u043e\u0432\u044b\u0435 \u0438\u0434\u0435\u0438, \u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u044f \u043c\u043e\u0433 \u0431\u044b \u0440\u0435\u0430\u043b\u0438\u0437\u043e\u0432\u0430\u0442\u044c, \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044f \u0441\u0442\u0430\u043d\u0434\u0430\u0440\u0442\u043d\u044b\u0435 \u0438\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442\u044b \u043d\u0430\u043f\u043e\u0434\u043e\u0431\u0438\u0435 N8N \u0430\u0432\u0442\u043e\u043c\u0430\u0442\u0438\u0437\u0430\u0446\u0438\u0438, chatgpt, google clod  \u0438 \u043d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, \u0440\u0435\u0430\u043b\u0438\u0437\u0443\u044f \u0438\u0445 \u0447\u0435\u0440\u0435\u0437 telegram \u0438 \u0434\u043e\u0441\u0442\u0443\u043f \u043a \u0434\u0430\u043d\u043d\u044b\u043c \u0438\u043b\u0438 \u0434\u0440\u0443\u0433\u0438\u0445 \u0432\u043d\u0435\u0448\u043d\u0438\u0445 \u0438\u0441\u0442\u043e\u0447\u043d\u0438\u043a\u0430\u0445 \u0434\u0430\u043d\u043d\u044b\u0445. \u042f \u043e\u0431\u043b\u0430\u0434\u0430\u044e \u043d\u0430\u0432\u044b\u043a\u0430\u043c\u0438 \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f python, java, c++, sql, shell, linux, windows, \u043f\u0440\u043e\u043c\u0442 \u0438\u043d\u0436\u0435\u043d\u0435\u0440\u0438\u043d\u0433\u0430, LLP , \u043d\u0430\u0432\u044b\u043a\u0438 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0430 telegram API, OpenAI API, \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0430 \u0431\u0430\u0437 \u0434\u0430\u043d\u043d\u044b\u0445 \u0438 web \u0442\u0435\u0447\u043d\u043e\u043b\u043e\u0433\u0438\u0439, \u0443 \u043c\u0435\u043d\u044f \u0435\u0441\u0442\u044c \u0441\u0432\u043e\u0439 VPS \u0441\u0435\u0440\u0432\u0435\u0440 \u0434\u043b\u044f  \u0440\u0435\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u0438 \u043f\u0440\u043e\u0435\u043a\u0442\u043e\u0432. \u041c\u0435\u043d\u044f \u0432 \u043f\u0435\u0440\u0432\u0443\u044e \u043e\u0447\u0435\u0440\u0435\u0434\u044c \u0438\u043d\u0442\u0435\u0440\u0435\u0441\u0443\u044e\u0442 \u0411\u0438\u0437\u043d\u0435\u0441 \u0438\u0434\u0435\u0438, \u0430 \u043d\u0435 \u0442\u043e, \u043a\u0430\u043a \u0438\u0445 \u0440\u0435\u0430\u043b\u0438\u0437\u043e\u0432\u0430\u0442\u044c \u0441 \u0443\u043a\u0430\u0437\u0430\u043d\u043d\u044b\u043c\u0438 \u0442\u0435\u0445\u043d\u043e\u043b\u043e\u0433\u0438\u044f\u043c\u0438. \u0412\u044b\u0434\u0430\u0439 \u043c\u0430\u043a\u0441\u0438\u043c\u0443\u043c 5 \u043b\u0443\u0447\u0448\u0438\u0445, \u0440\u0435\u0430\u043b\u0438\u0437\u0443\u0435\u043c\u044b\u0445 \u0438 \u043f\u0435\u0440\u0441\u043f\u0435\u043a\u0442\u0438\u0432\u043d\u044b\u0445 \u0438\u0434\u0435\u0439 \u0438 \u0434\u0430\u0439 \u043e\u043f\u0438\u0441\u0430\u043d\u0438\u044f \u043a \u043d\u0438\u043c, \u0443\u043a\u0430\u0436\u0438 \u0441\u0441\u044b\u043b\u043a\u0438 \u043d\u0430 \u0442\u043e, \u0433\u0434\u0435 \u0442\u044b \u0438\u0445 \u043d\u0430\u0448\u0435\u043b. \u041f\u0440\u043e\u0432\u0435\u0440\u044c \u043d\u0430 \u043f\u0435\u0440\u0441\u043f\u0435\u043a\u0442\u0438\u0432\u043d\u043e\u0441\u0442\u044c \u0438\u0434\u0435\u0438, \u043e\u0446\u0435\u043d\u0438 \u0437\u0430\u0442\u0440\u0430\u0442\u043d\u043e\u0441\u0442\u044c \u0440\u0435\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u0438 \u0438\u0445 \u043e\u0434\u043d\u0438\u043c \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u0438\u0441\u0442\u043e\u043c \u0438 \u043e\u0434\u043d\u0438\u043c \u0431\u0438\u0437\u043d\u0435\u0441 \u0430\u043d\u0430\u043b\u0438\u0442\u0438\u043a\u043e\u043c.\n\u0412\u044b\u0434\u0430\u0439  \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442\u044b \u0432 \u0432\u0438\u0434\u0435 \u0441\u043f\u0438\u0441\u043a\u0430 UseCases \u0432 JSON  \u0424\u043e\u0440\u043c\u0430\u0442\u0435\n[\n  {\n\"Titel\": \"\u0441\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u0440\u0435\u043a\u043b\u0430\u043c\u043d\u043e\u0439 \u043a\u0430\u043c\u043f\u0430\u043d\u0438\u0438 \u0441 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435\u043c AI\",\n\"Description\": \"AI \u0410\u0433\u0435\u043d\u0442 \u0434\u043b\u044f \u043f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u043a\u0438 \u0440\u0435\u043a\u043b\u0430\u043c\u043d\u043e\u0439 \u043a\u0430\u043c\u043f\u0430\u043d\u0438\u0438 \u043f\u043e\u0438\u0441\u043a \u0438\u0434\u0435\u0439, \u0433\u0435\u043d\u0435\u0440\u0430\u0446\u0438\u0438 \u0442\u0435\u043a\u0441\u0442\u043e\u0432, \u043a\u0440\u0435\u0430\u0442\u0438\u0432\u043e\u0432 \u0438 \u043e\u043f\u0440\u0435\u0434\u0435\u043b\u0435\u043d\u0438\u0435 \u043f\u043e\u0442\u0435\u043d\u0446\u0438\u0430\u043b\u044c\u043d\u043e\u0439 \u0430\u0443\u0434\u0438\u0442\u043e\u0440\u0438\u0438. \u0421\u043e\u0437\u0434\u0430\u043d\u044b\u0439 \u0441 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435\u043c \u0430\u0432\u0442\u043e\u043c\u0430\u0442\u0438\u0437\u0430\u0446\u0438\u0438 n8n \u0438 \u043f\u0440\u0435\u0434\u043b\u0430\u0433\u0430\u0435\u0442 \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0435 \u0444\u0443\u043d\u043a\u0446\u0438\u0438 ... . \u0418\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442 \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0435 ... \u0438 \u043f\u0440\u0435\u0434\u043e\u0441\u0442\u0430\u0432\u043b\u044f\u0435\u0442 \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442\u044b \u0432 \u0432\u0438\u0434\u0435 ...\",\n\"Potential_customers\": \"\u043c\u0430\u0440\u043a\u0435\u0442\u0438\u043d\u0433 \u0441\u043f\u0435\u0446\u0438\u0430\u043b\u0438\u0441\u0442\u044b \u0438\u0437 \u0440\u0430\u0437\u043d\u044b\u0445 \u043e\u0431\u043b\u0430\u0441\u0442\u0435\u0439 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044e\u0449\u0438\u0435 \u0441\u043e\u0446\u0438\u0430\u043b\u044c\u043d\u044b\u0435 \u0441\u0435\u0442\u0438\",\n\"Financial_potential_to_earn\": \"\u0410\u0431\u043e\u043d\u0435\u043c\u0435\u043d\u0442 200$ \u0432 \u043c\u0435\u0441\u044f\u0446 \u0438\u043b\u0438 1000$ \u043d\u0430 \u0433\u043e\u0434. \u0411\u0435\u0437\u043b\u0438\u043c\u0438\u0442\u043d\u043e 2000$ per client\",\n\"Costs_to_realize_in_hours\": \"80\",\n\"Perspective_marketing_ranking\": \"0.8\",\n\"Source_links\" : \"https://news.com; https://forum.copywriter-discussions.ru\"\n  },\n\u2026\n]\n\u0432\u044b\u0434\u0430\u0432\u0430\u0439 \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442\u044b \u043d\u0430 \u0440\u0443\u0441\u0441\u043a\u043e\u043c \u044f\u0437\u044b\u043a\u0435 \u0432 \u0441\u0442\u0440\u043e\u0433\u043e\u043c \u0441\u043e\u043e\u0442\u0432\u0435\u0442\u0441\u0432\u0438\u0435 \u0443\u043a\u0430\u0437\u0430\u043d\u043d\u043e\u0433\u043e \u0444\u043e\u0440\u043c\u0430\u0442\u0430 , \u043d\u0435 \u0438\u0437\u043c\u0435\u043d\u044f\u0439 \u043d\u0430\u0437\u0432\u0430\u043d\u0438\u044f \u043f\u043e\u043b\u0435\u0439. \u0412\u0441\u0442\u0430\u0432\u043b\u044f\u0439 \u0432 \u043f\u043e\u043b\u0435 Source_link \u0442\u043e\u043b\u044c\u043a\u043e \u043f\u0440\u043e\u0432\u0435\u0440\u0435\u043d\u043d\u044b\u0435 \u0438 \u0440\u0435\u0430\u043b\u044c\u043d\u044b\u0435 \u0441\u0441\u044b\u043b\u043a\u0438 \u0438\u0437 \u0438\u043d\u0442\u0435\u0440\u043d\u0435\u0442\u0430, \u043d\u0435 \u0434\u043e\u0431\u0430\u0432\u043b\u044f\u0439 \u043d\u0435\u043f\u0440\u043e\u0432\u0435\u0440\u0435\u043d\u043d\u044b\u0435 \u0441\u0441\u044b\u043b\u043a\u0438, \u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u0442\u044b \u043d\u0435 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043b \u0434\u043b\u044f \u0441\u0432\u043e\u0435\u0433\u043e \u043f\u043e\u0438\u0441\u043a\u0430. \u041e\u0441\u0442\u0430\u0432\u043b\u044f\u0439 \u043f\u043e\u043b\u0435 \u043f\u0443\u0441\u0442\u044b\u043c, \u0435\u0441\u043b\u0438 \u0442\u044b \u043d\u0435 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043b \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u044e \u0438\u0437 \u0438\u043d\u0442\u0435\u043d\u0435\u0442\u0430 \u0434\u043b\u044f \u0433\u0435\u043d\u0435\u0440\u0430\u0446\u0438\u0438 \u0438\u0434\u0435\u0438 \u0438 \u043e\u043f\u0438\u0441\u0430\u043d\u0438\u0435 Use Case, \u043c\u043e\u0436\u0435\u0448\u044c \u0434\u043e\u0431\u0430\u0432\u0438\u0442\u044c \u0442\u0443\u0434\u0430 \u0441\u0441\u0432\u043b\u043a\u0438 \u0441 \u043f\u0440\u0438\u043c\u0435\u0440\u0430\u043c\u0438 \u0438 \u043e\u043f\u0438\u0441\u0430\u043d\u0438\u044f\u043c\u0438 \u0440\u0435\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u0438 \u043d\u0430 \u043e\u0441\u043d\u043e\u0432\u0435 \u043f\u043e\u0434\u043e\u0431\u043d\u044b\u0445 \u0438\u043b\u0438 \u0442\u0430\u043a\u0438\u0445 \u0436\u0435 \u0442\u0435\u0445\u043d\u043e\u043b\u043e\u0433\u0438\u0439, \u043a\u043e\u0442\u043e\u0440\u044b\u043c\u0438 \u044f \u0432\u043b\u0430\u0434\u0435\u044e.\n\n  ",
              "role": "assistant"
            }
          ]
        },
        "jsonOutput": true,
        "options": {}
      },
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "typeVersion": 1.8,
      "position": [
        660,
        0
      ],
      "id": "c3f7476b-fa09-45f9-a4bf-71cb6e921dd2",
      "name": "OpenAI",
      "notesInFlow": false,
      "credentials": {
        "openAiApi": {
          "name": "<your credential>"
        }
      }
    },
    {
      "parameters": {
        "jsCode": "const titles = items.map(item => item.json.Titel);\nconst promptList = titles.map((t, i) => `${i + 1}. ${t}`).join('\\n');\nconsole.log(items);\nreturn [{ json: { known_titles: promptList } }];"
      },
      "type": "n8n-nodes-base.code",
      "typeVersion": 2,
      "position": [
        420,
        0
      ],
      "id": "272fe346-a58e-421a-a013-dcb859eb1c82",
      "name": "Code"
    },
    {
      "parameters": {
        "operation": "append",
        "documentId": {
          "__rl": true,
          "value": "https://docs.google.com/spreadsheets/d/137r7IASQtPOdFFVyHlrrhSzYUwVVyOXv8_IRnydcP5E/edit?gid=0#gid=0",
          "mode": "url"
        },
        "sheetName": {
          "__rl": true,
          "value": "gid=0",
          "mode": "list",
          "cachedResultName": "UseCases",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/137r7IASQtPOdFFVyHlrrhSzYUwVVyOXv8_IRnydcP5E/edit#gid=0"
        },
        "columns": {
          "mappingMode": "autoMapInputData",
          "value": {},
          "matchingColumns": [],
          "schema": [
            {
              "id": "Created_at",
              "displayName": "Created_at",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true,
              "removed": false
            },
            {
              "id": "ID",
              "displayName": "ID",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true,
              "removed": false
            },
            {
              "id": "Titel",
              "displayName": "Titel",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true,
              "removed": true
            },
            {
              "id": "Description",
              "displayName": "Description",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true,
              "removed": false
            },
            {
              "id": "Potential_customers",
              "displayName": "Potential_customers",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true,
              "removed": false
            },
            {
              "id": "Financial_potential_to_earn",
              "displayName": "Financial_potential_to_earn",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true,
              "removed": false
            },
            {
              "id": "Costs_to_realize_in_hours",
              "displayName": "Costs_to_realize_in_hours",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true,
              "removed": false
            },
            {
              "id": "Perspective_marketing_ranking",
              "displayName": "Perspective_marketing_ranking",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true,
              "removed": false
            },
            {
              "id": "Source_links",
              "displayName": "Source_links",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true,
              "removed": false
            }
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {}
      },
      "type": "n8n-nodes-base.googleSheets",
      "typeVersion": 4.6,
      "position": [
        1300,
        0
      ],
      "id": "a9357b6b-ed51-4da0-a971-43f5a5fa1871",
      "name": "Google Sheets1",
      "credentials": {
        "googleSheetsOAuth2Api": {
          "name": "<your credential>"
        }
      }
    },
    {
      "parameters": {
        "sendTo": "soulsoul-003@yandex.ru",
        "subject": "New update of AI USeCases added",
        "message": "s. https://docs.google.com/spreadsheets/d/137r7IASQtPOdFFVyHlrrhSzYUwVVyOXv8_IRnydcP5E/edit?gid=0#gid=0",
        "options": {
          "ccList": "stas.ulmer@gmail.com"
        }
      },
      "type": "n8n-nodes-base.gmail",
      "typeVersion": 2.1,
      "position": [
        1520,
        0
      ],
      "id": "7f15da34-e450-4b74-9435-dc7a854d78c7",
      "name": "Gmail"
    },
    {
      "parameters": {
        "language": "python",
        "pythonCode": "import hashlib\nfrom datetime import datetime\n\n# Zugriff auf die Ideen aus GPT\nuse_cases = items[0]['json']['message']['content']['UseCases']\n\n# Aktueller Zeitstempel (einmal erzeugen, f\u00fcr alle gleich)\nnow = datetime.utcnow().isoformat()\n\nresults = []\nfor use_case in use_cases:\n    base = use_case['Titel']\n    hash_id = hashlib.md5(base.encode('utf-8')).hexdigest()[:6]\n    \n    results.append({\n        'json': {\n            'ID': hash_id,\n            'Titel': use_case['Titel'],\n            'Description': use_case['Description'],\n            'Potential_customers': use_case['Potential_customers'],\n            'Financial_potential_to_earn': use_case['Financial_potential_to_earn'],\n            'Costs_to_realize_in_hours': use_case['Costs_to_realize_in_hours'],\n            'Perspective_marketing_ranking': use_case['Perspective_marketing_ranking'],\n            'Source_links': use_case['Source_links'],\n            'Created_at': now  # \u23f1 Zeitstempel\n        }\n    })\n\nreturn results\n"
      },
      "type": "n8n-nodes-base.code",
      "typeVersion": 2,
      "position": [
        1020,
        0
      ],
      "id": "14245941-b03c-4947-ba1c-67ee180b0e6b",
      "name": "Code1"
    }
  ],
  "connections": {
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets": {
      "main": [
        [
          {
            "node": "Code",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Code": {
      "main": [
        [
          {
            "node": "OpenAI",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI": {
      "main": [
        [
          {
            "node": "Code1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets1": {
      "main": [
        [
          {
            "node": "Gmail",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Code1": {
      "main": [
        [
          {
            "node": "Google Sheets1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "active": false,
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "379f5c52-af4b-4fe4-a965-730002399636",
  "id": "nZq1Z9nZTpvg4WpC",
  "tags": []
}

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

Look for new UseCases. Uses googleSheets, openAi, gmail. Scheduled trigger; 7 nodes.

Source: https://github.com/stas-ka/sintaris-srv/blob/bbc2e3b15f970d54d781649510f4bf4f0e6f5b96/n8n/Look_for_new_UseCases.json — 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

Stop finding out you're out of stock after a customer already tried to buy. This workflow monitors your entire product inventory daily, calculates how fast each SKU is selling, and automatically raise

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

The scoreboard shows you what happened. This workflow tells you why it happened. Every time an IPL match ends this automation detects the completed result, fetches the full scorecard, and sends it to

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

Automate weekly pet wellness emails with AI-generated, location and age-specific advice.

OpenAI, Gmail, SendGrid +1
Email & Gmail

Send A Chatgpt Email Reply And Save Responses To Google Sheets. Uses openAi, gmailTrigger, stickyNote, gmail. Event-driven trigger; 49 nodes.

OpenAI, Gmail Trigger, Gmail +2
Email & Gmail

Code. Uses openAi, gmailTrigger, stickyNote, gmail. Event-driven trigger; 49 nodes.

OpenAI, Gmail Trigger, Gmail +2