Templates / Generate comprehensive client brief reports with Llama 3 AI & Google Workspace

Generate comprehensive client brief reports with Llama 3 AI & Google Workspace

Ready for 3.0

by DigiMetaLab ✓ · 260 views · created 2025-12-17 · Market Research, AI RAG

Ready 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 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).

  1. Workflow Configuration (Edit Fields (Set)): sets 4 fields: clientSummariesFolderId, accountManagerEmail, trackingSheetId…
  2. Process One Brief at a Time (Loop Over Items (Split in Batches)): loops over the items in batches
  3. Validate Configuration and File (Code): runs custom JavaScript code
  4. Prepare Error Notification (Code): runs custom JavaScript code
  5. Download Client Brief (Google Drive): download
  6. Can Notify Error (If): checks a condition and branches into true / false
  7. Validate Download Size (Code): runs custom JavaScript code
  8. Send Error Notification (Gmail): uses Gmail
  9. Stop Failed Processing (Stop and Error): stops the run with an error
  10. Check File Type (Switch): routes items into branches

…plus 18 more steps. See the full node list below.

Services it uses

Google DocsGoogle DriveHTTP RequestGmailGoogle SheetsGroq Chat ModelWikipedia

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)

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…

Excerpt from DigiMetaLab's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.