Parallel Workflow Accelerator in n8n

Automate Tool Research and Analysis with Parallel Execution

The Parallel Workflow Accelerator template is designed to help automation builders, marketers, and AI teams research and analyze multiple tools at the same time — massively cutting down manual effort.

It pulls a list of tools from a Google Sheet, uses AI to research each one via Perplexity, and then runs parallel sub-workflows to summarize features, business use cases, and workflow integrations for each tool — all within minutes.


What It Does

  1. Reads from Google Sheets – Fetches all tools that have a “Status: Ready.”

  2. Runs Research in Parallel – Sends multiple tools to Perplexity AI simultaneously for feature extraction.

  3. Analyzes Each Tool – Uses OpenRouter GPT-4.1 mini with structured output to summarize business use cases and integrations.

  4. Updates Google Sheets – Automatically writes back “Features,” “Analysis,” and sets the status to “Processed.”

In short: you paste a list of tools → click run → get full AI-driven research done in parallel across all rows.


Step-by-Step Setup Guide

Step 1 — Copy the Google Sheet Template


Step 2 — Connect Your Google Account

  • In n8n → Credentials → New → Google Sheets, connect your Google account.

  • In the Get Tools and Update Tool nodes, assign your Google credential.

  • Replace the sheet and document IDs with your own.


Step 3 — Connect Perplexity and OpenRouter APIs

  • Create accounts on:

  • Add API credentials in n8n → Credentials:

    • perplexityApi

    • openRouterApi

  • Assign these credentials to the Perplexity Research and 4.1-mini nodes respectively.


Step 4 — Set Up Parallel Execution

  • Convert nodes after “Get Tools” into a sub-workflow.

  • Enable “Run Each Item in Parallel” in the main workflow settings.

  • This lets each tool be processed simultaneously — one Perplexity + one GPT-4.1 thread per tool.


Step 5 — Test Your Workflow

  • Run the workflow manually from the Manual Trigger node.

  • Watch multiple Perplexity calls execute concurrently.

  • Return to your Google Sheet — you’ll see the Features and Analysis columns automatically populated for each tool.


Step 6 — Extend the Workflow (Optional)

You can enhance it by:

  • Adding a Slack or Telegram notification node to share the completed sheet.

  • Using OpenAI Embeddings to tag tools by category.

  • Exporting summaries to Notion or Airtable.


 

Why This Workflow Matters

  • Time Saver: Automates repetitive AI research across 50+ tools in minutes.

  • Scalable: Parallel processing lets you run dozens of tool analyses simultaneously.

  • Reusable: You can adapt it for any dataset (brands, competitors, clients, products).

  • Collaborative: Output goes back to Google Sheets for easy sharing or integration.

{
  "name": "Parallelization",
  "nodes": [
    {
      "parameters": {},
      "type": "n8n-nodes-base.manualTrigger",
      "typeVersion": 1,
      "position": [-40, -880],
      "id": "1e17ba65-d067-4104-829e-b5d4274f132e",
      "name": "Manual Trigger"
    },
    {
      "parameters": {
        "documentId": {
          "__rl": true,
          "value": "1uNFhLb6zObDuS6iwGzV6ECk9g3DEj7df0afqfJ3thIo",
          "mode": "list"
        },
        "sheetName": {
          "__rl": true,
          "value": "gid=0",
          "mode": "list"
        },
        "filtersUI": {
          "values": [
            {
              "lookupColumn": "Status",
              "lookupValue": "Ready"
            }
          ]
        }
      },
      "type": "n8n-nodes-base.googleSheets",
      "typeVersion": 4.6,
      "position": [100, -880],
      "id": "50365b26-0ca0-40db-be0c-9a167c3b72a8",
      "name": "Get Tools"
    },
    {
      "parameters": {
        "model": "sonar",
        "messages": {
          "message": [
            {
              "content": "=Do research to find features about this tool: {{ $json.Tool }}."
            }
          ]
        }
      },
      "type": "n8n-nodes-base.perplexity",
      "typeVersion": 1,
      "position": [300, -880],
      "id": "afe12767-ff4c-4225-9ed2-51797f927530",
      "name": "Perplexity Research"
    },
    {
      "parameters": {
        "promptType": "define",
        "text": "=Tool: {{ $('Get Tools').item.json.Tool }}\\nResearch: {{ $json.choices[0].message.content }}",
        "hasOutputParser": true
      },
      "type": "@n8n/n8n-nodes-langchain.agent",
      "typeVersion": 2,
      "position": [520, -900],
      "id": "ec4125c0-630e-410a-8e8d-c3f86f73d4b3",
      "name": "Tool Analysis Agent"
    },
    {
      "parameters": {
        "operation": "update",
        "columns": {
          "mappingMode": "defineBelow",
          "value": {
            "Tool": "={{ $('Get Tools').item.json.Tool }}",
            "Features": "={{ $json.output.Features.join('\\n\\n') }}",
            "Status": "Processed",
            "Analysis": "={{ $json.output.Analysis }}"
          },
          "matchingColumns": ["Tool"]
        }
      },
      "type": "n8n-nodes-base.googleSheets",
      "typeVersion": 4.6,
      "position": [860, -880],
      "id": "a6ed737e-f534-4dc3-86b9-7aa2e7d35480",
      "name": "Update Tool"
    }
  ]
}

Leave a Reply

Your email address will not be published. Required fields are marked *