Generate Dream 100 Prospect Lists with Perplexity AI Research and Google Sheets

Description

Overview
Send an AI a few details about your "Dream Customer" in normal english, then have it search the web and give you a "Dream 100" - 100 ideal prospects to connect with in your industry.

Great for stress-testing a product idea or giving you a start for networking in an industry.

How it works

Send the AI agent information about your business + ideal customer. It will ask you to clarify any additional info.
The agent will use an LLM to turn your criteria into specific prompts for an internet search
Perplexity will use those prompts to identify ideal customers
An LLM will format those Perplexity results, then they'll be added to a Google sheet.

Set up steps

Copy the provided google sheets template into your Google Drive
Connect your Google Drive/Sheets to the workflow
Connect OpenRouter and Perplexity to the workflow (Just paste in your API key!)
If desired, connect the Slack trigger/response nodes to control the agent from Slack.