Generate Startup Ideas From Reddit Posts Using Gemini AI and Google Sheets

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 →

{
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "name": "Startup Idea Finder",
  "tags": [],
  "nodes": [
    {
      "id": "2376c641-4535-4fff-bca1-08bb4b6b145b",
      "name": "When clicking \u2018Execute workflow\u2019",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -128,
        -32
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "6558b598-e03a-437e-a1e4-a97305fcf2bf",
      "name": "Search for a post",
      "type": "n8n-nodes-base.reddit",
      "position": [
        80,
        -32
      ],
      "parameters": {
        "limit": 25,
        "keyword": "Why is there no tool that",
        "operation": "search",
        "subreddit": "crazyideas",
        "additionalFields": {
          "sort": "comments"
        }
      },
      "credentials": {
        "redditOAuth2Api": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "115087b0-dc35-4e54-8195-ad20079c3fc0",
      "name": "Edit Fields",
      "type": "n8n-nodes-base.set",
      "position": [
        528,
        0
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "c53a68f5-c7c4-4825-a392-b233c875c123",
              "name": "title",
              "type": "string",
              "value": "={{ $json.title }}"
            },
            {
              "id": "74c7e5fd-39c8-4509-8c41-954c9c7c4f58",
              "name": "selftext",
              "type": "string",
              "value": "={{ $json.selftext }}"
            },
            {
              "id": "4740304d-6688-4dcd-8a1a-0a9ec65ace0c",
              "name": "ups",
              "type": "number",
              "value": "={{ $json.ups }}"
            },
            {
              "id": "94b8d977-c02f-4264-a95e-e982a13896ed",
              "name": "created",
              "type": "number",
              "value": "={{ $json.created }}"
            },
            {
              "id": "a9c6a0f7-f1a2-44eb-8310-ee4c9af904a0",
              "name": "url",
              "type": "string",
              "value": "={{ $json.url }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "bade6326-13e7-4f3e-8f1a-83e2b5cc21e3",
      "name": "AI Agent",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        736,
        96
      ],
      "parameters": {
        "text": "=A Reddit user posted the following in r/SomebodyMakeThis:\n\n---\n**Title**: {{ $json[\"title\"] }}\n\n**Post Text**: {{ $json[\"selftext\"] }}\n\n**Upvotes**: {{ $json[\"ups\"] }}\n**Post URL**: {{ $json[\"url\"] }}\n**Created Date**: {{ $json.created }}\n---\n\nBased on the above, please do the following:\n\n1. **Explain the core problem or frustration described in this post.**\n2. **Determine if any existing products, tools, or companies are actively solving this issue.**\n3. **If you can't find any known solution**, propose a startup idea or product that could effectively address this pain point.\n4. **Include what type of user would benefit**, and how the solution could make their life easier or more efficient.\n5. Also give an overview of implemnting this startup idea.\n\nBe as insightful and practical as possible.\n",
        "options": {},
        "promptType": "define"
      },
      "typeVersion": 2.1
    },
    {
      "id": "12414406-44ac-4856-b8ad-9e5f7436da9b",
      "name": "Google Gemini Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        736,
        256
      ],
      "parameters": {
        "options": {},
        "modelName": "models/gemini-1.5-flash-8b-latest"
      },
      "credentials": {
        "googlePalmApi": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "a56fe401-e3b1-45c3-9eca-e995c794fc21",
      "name": "Append row in sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1248,
        16
      ],
      "parameters": {
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "name",
          "value": "",
          "cachedResultUrl": "",
          "cachedResultName": ""
        },
        "documentId": {
          "__rl": true,
          "mode": "id",
          "value": ""
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "fcfea3d1-7050-4aa9-b6c6-e065de892075",
      "name": "Merge",
      "type": "n8n-nodes-base.merge",
      "position": [
        1088,
        16
      ],
      "parameters": {
        "mode": "combine",
        "options": {},
        "combineBy": "combineByPosition"
      },
      "typeVersion": 3.2
    },
    {
      "id": "b098e537-63cc-45bb-87a3-4a7a9d5698da",
      "name": "Search for a post1",
      "type": "n8n-nodes-base.reddit",
      "position": [
        80,
        128
      ],
      "parameters": {
        "limit": 25,
        "keyword": "Why is there no tool that",
        "operation": "search",
        "subreddit": "Lightbulb",
        "additionalFields": {
          "sort": "comments"
        }
      },
      "credentials": {
        "redditOAuth2Api": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "20bea9e3-25a3-493a-bf8b-23510359b006",
      "name": "Search for a post2",
      "type": "n8n-nodes-base.reddit",
      "position": [
        80,
        -208
      ],
      "parameters": {
        "limit": 25,
        "keyword": "Why is there no tool that",
        "operation": "search",
        "subreddit": "sidehustle",
        "additionalFields": {
          "sort": "top"
        }
      },
      "credentials": {
        "redditOAuth2Api": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "7afc5f5d-8ebc-43d7-ae09-179410b2b9a2",
      "name": "Merge1",
      "type": "n8n-nodes-base.merge",
      "position": [
        304,
        -16
      ],
      "parameters": {
        "numberInputs": 3
      },
      "typeVersion": 3.2
    }
  ],
  "notes": "Setup Instructions: After importing this workflow into your n8n instance, you must set up your own credentials for Reddit, Google Gemini (PaLM), and Google Sheets. Replace the credential names 'YOUR_REDDIT_CREDENTIAL', 'YOUR_GOOGLE_GEMINI_CREDENTIAL', and 'YOUR_GOOGLE_SHEETS_CREDENTIAL' in the workflow with the names of your own credentials configured in n8n. No API keys or sensitive data are included in this workflow.",
  "active": false,
  "settings": {
    "executionOrder": "v1"
  },
  "connections": {
    "Merge": {
      "main": [
        [
          {
            "node": "Append row in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge1": {
      "main": [
        [
          {
            "node": "Edit Fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "AI Agent": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Edit Fields": {
      "main": [
        [
          {
            "node": "AI Agent",
            "type": "main",
            "index": 0
          },
          {
            "node": "Merge",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Search for a post": {
      "main": [
        [
          {
            "node": "Merge1",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Search for a post1": {
      "main": [
        [
          {
            "node": "Merge1",
            "type": "main",
            "index": 2
          }
        ]
      ]
    },
    "Search for a post2": {
      "main": [
        [
          {
            "node": "Merge1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Append row in sheet": {
      "main": [
        []
      ]
    },
    "Google Gemini Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "AI Agent",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "When clicking \u2018Execute workflow\u2019": {
      "main": [
        [
          {
            "node": "Search for a post",
            "type": "main",
            "index": 0
          },
          {
            "node": "Search for a post1",
            "type": "main",
            "index": 0
          },
          {
            "node": "Search for a post2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

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.

• googlePalmApi
• googleSheetsOAuth2Api
• redditOAuth2Api

About this workflow

This workflow contains community nodes that are only compatible with the self-hosted version of n8n.

Source: https://n8n.io/workflows/6094/ — original creator credit. Request a take-down →

More AI & RAG workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.