Automate legal lien documents with Gemini AI, Apify, and Google Workspace
Ready for 3.0What this workflow does
This AI workflow has 22 nodes and runs on Google Sheets events (row added) (plus 1 other trigger). Along the way it connects Gmail, Google Gemini Chat Model, Google Drive and Google Docs and 1 more. It also calls api.apify.com over HTTP.
How it runs
Trigger: On Google Sheets events (row added) (plus 1 other trigger).
- Apify Playwright script to find property info (HTTP Request): calls api.apify.com (POST)
- If: checks a condition and branches into true / false
- Get file for property (HTTP Request): calls an HTTP API
- Playwright error inform (Gmail): uses Gmail
- Create folder For Output Files (Google Drive): work with folder
- Transform to base (Extract from File): extracts data from a file (binary to propery)
- Make Copy of Template (Google Drive): copy
- Upload legal doc (Google Drive): uses Google Drive
- Change Custom Variables (Google Docs): update
- Call Gemini API for legal desc (HTTP Request): calls an HTTP API (POST)
…plus 9 more steps. See the full node list below.
Services it uses
HTTP calls to: api.apify.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 (10)
- Extract from File
n8n-nodes-base.extractFromFile - Gmail
n8n-nodes-base.gmail - HTTP Request
n8n-nodes-base.httpRequest - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Information Extractor
@n8n/n8n-nodes-langchain.informationExtractor - Google Drive
n8n-nodes-base.googleDrive - Google Docs
n8n-nodes-base.googleDocs - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets - Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger
From the author
Automate Legal Document Generation with n8n, Apify, Google Drive, and AI This tutorial details an end-to-end automation solution for streamlining the lien filing process for Homeowners Associations (HOAs) using an n8n workflow. It significantly reduces manual…