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
Reads from Google Sheets – Fetches all tools that have a “Status: Ready.”
Runs Research in Parallel – Sends multiple tools to Perplexity AI simultaneously for feature extraction.
Analyzes Each Tool – Uses OpenRouter GPT-4.1 mini with structured output to summarize business use cases and integrations.
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
Make a copy of this template:
Google Sheet – Parallel Workflow Accelerator TemplateAdd your list of tools under the “Tool” column.
Set Status = “Ready” for the rows you want processed.
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:
perplexityApiopenRouterApi
Assign these credentials to the
Perplexity Researchand4.1-mininodes 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"
}
]
}

