Research people with Perplexity AI and log results to Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 15 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets and Slack. It also calls api.perplexity.ai over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Get All Rows (Google Sheets): uses Google Sheets
- Filter: keeps only the items that match a condition
- Loop Over Rows (Loop Over Items (Split in Batches)): loops over the items in batches
- Set Status — Processing (Google Sheets): update
- Get Config Tab (Google Sheets): uses Google Sheets
- Build Dynamic Prompt (Code): runs custom JavaScript code
- Perplexity — Research Call (HTTP Request): calls api.perplexity.ai (POST)
- Parse Perplexity Response (Code): runs custom JavaScript code
- Write Error to Sheet (Google Sheets): update
- Map Fields to Sheet Columns (Code): runs custom JavaScript code
…plus 4 more steps. See the full node list below.
Services it uses
HTTP calls to: api.perplexity.ai
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (8)
- Google Sheets
n8n-nodes-base.googleSheets - Filter
n8n-nodes-base.filter - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - If
n8n-nodes-base.if - Slack
n8n-nodes-base.slack - Manual Trigger
n8n-nodes-base.manualTrigger
From the author
What This Workflow Does You have a Google Sheet where you type in a person's name and set their status to Pending. This workflow checks that sheet on a schedule, finds anyone marked Pending, and automatically researches them using the Perplexity AI API. The…