Qualify and email literary agents with GPT‑4.1, Gmail and Google Sheets
UnknownUnknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 43 nodes and runs on a schedule (every day at 12:00) (plus 1 other trigger). Along the way it connects OpenAI Chat Model, Gmail, Google BigQuery and Azure Storage and 5 more.
How it runs
Trigger: On a schedule (every day at 12:00) (plus 1 other trigger).
- HTTP Request: calls an HTTP API
- Google BQ (Google BigQuery): uses Google BigQuery
- Msft Azure Blob (Azure Storage): get (blob)
- Amzn AWS S (AWS S3): uses AWS S3
- Goog Sheets (Google Sheets): uses Google Sheets
- Analysis Prompt (Code): runs custom JavaScript code
- Merge: merges the data from its input branches
- Merge: merges the data from its input branches
- Eligibility Agent (AI Agent): runs an AI agent, with model: OpenAI Chat Model
- Check (Google Sheets): append or update
…plus 22 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that n8n-nodes-powerbi is verified or supports 3.0 (used in PowerBi Dashboard).
Nodes used (19)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Switch
n8n-nodes-base.switch - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Simple Memory
@n8n/n8n-nodes-langchain.memoryBufferWindow - Code
n8n-nodes-base.code - Gmail
n8n-nodes-base.gmail - AI Agent
@n8n/n8n-nodes-langchain.agent - Google BigQuery
n8n-nodes-base.googleBigQuery - Azure Storage
n8n-nodes-base.azureStorage - AWS S3
n8n-nodes-base.awsS3 - HTTP Request
n8n-nodes-base.httpRequest - Google Sheets
n8n-nodes-base.googleSheets - Extract from File
n8n-nodes-base.extractFromFile - Merge
n8n-nodes-base.merge - Chat Trigger
@n8n/n8n-nodes-langchain.chatTrigger - QuickChart
n8n-nodes-base.quickChart - Google Analytics
n8n-nodes-base.googleAnalytics - Power Bi
n8n-nodes-powerbi.powerBi
From the author
Inspiration & Notes This workflow was born out of a very real problem. While writing a book, I found the process of discovering suitable literary agents and managing outreach to be manual, and surprisingly difficult to scale. Researching agents, checking…