Generate comprehensive client brief reports with Llama 3 AI & Google Workspace
Ready for 3.0What this workflow does
This AI workflow has 35 nodes and runs on Google Drive events (file created). Along the way it connects Google Docs, Google Drive, HTTP Request and Gmail and 3 more. It also calls serpapi.com over HTTP.
How it runs
Trigger: On Google Drive events (file created).
- Workflow Configuration (Edit Fields (Set)): sets 4 fields: clientSummariesFolderId, accountManagerEmail, trackingSheetId…
- Process One Brief at a Time (Loop Over Items (Split in Batches)): loops over the items in batches
- Validate Configuration and File (Code): runs custom JavaScript code
- Prepare Error Notification (Code): runs custom JavaScript code
- Download Client Brief (Google Drive): download
- Can Notify Error (If): checks a condition and branches into true / false
- Validate Download Size (Code): runs custom JavaScript code
- Send Error Notification (Gmail): uses Gmail
- Stop Failed Processing (Stop and Error): stops the run with an error
- Check File Type (Switch): routes items into branches
…plus 18 more steps. See the full node list below.
Services it uses
HTTP calls to: serpapi.com
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 (19)
- Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Code
n8n-nodes-base.code - Stop and Error
n8n-nodes-base.stopAndError - If
n8n-nodes-base.if - Google Docs
n8n-nodes-base.googleDocs - Compression
n8n-nodes-base.compression - Google Drive
n8n-nodes-base.googleDrive - Http Request Tool
n8n-nodes-base.httpRequestTool - Gmail
n8n-nodes-base.gmail - Google Sheets
n8n-nodes-base.googleSheets - Groq Chat Model
@n8n/n8n-nodes-langchain.lmChatGroq - Wikipedia
@n8n/n8n-nodes-langchain.toolWikipedia - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - AI Agent
@n8n/n8n-nodes-langchain.agent - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Extract from File
n8n-nodes-base.extractFromFile - Switch
n8n-nodes-base.switch - Edit Fields (Set)
n8n-nodes-base.set - Google Drive Trigger
n8n-nodes-base.googleDriveTrigger
From the author
How It Works - Trigger: The workflow starts automatically when a new file (PDF, DOCX, or TXT) is uploaded to a specific Google Drive folder for client briefs. - Configuration: The workflow sets up key variables, such as the folder for storing reports, the…