This workflow follows the Google Drive → Informationextractor recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"name": "My workflow",
"nodes": [
{
"parameters": {},
"type": "n8n-nodes-base.manualTrigger",
"typeVersion": 1,
"position": [
0,
250
],
"id": "f63e803c-1362-44db-a515-93fb815b526f",
"name": "When clicking \u2018Test workflow\u2019"
},
{
"parameters": {
"operation": "download",
"fileId": {
"__rl": true,
"value": "1N1UWI6FO_6X4lw-cYf_C0LHfZyqEjEP7",
"mode": "list",
"cachedResultName": "MA_List - Sheet1 (3).csv",
"cachedResultUrl": "https://drive.google.com/file/d/1N1UWI6FO_6X4lw-cYf_C0LHfZyqEjEP7/view?usp=drivesdk"
},
"options": {}
},
"type": "n8n-nodes-base.googleDrive",
"typeVersion": 3,
"position": [
220,
250
],
"id": "f0ddd3df-28a3-4ebe-88c1-d517f6dce58a",
"name": "Google Drive",
"credentials": {
"googleDriveOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"options": {}
},
"type": "n8n-nodes-base.splitInBatches",
"typeVersion": 3,
"position": [
660,
250
],
"id": "5068b781-aca0-4099-93f7-e47752ea7d75",
"name": "Loop Over Items"
},
{
"parameters": {
"options": {}
},
"type": "n8n-nodes-base.extractFromFile",
"typeVersion": 1,
"position": [
440,
250
],
"id": "291d7413-f67e-41bb-ae87-9f5d98e07bb7",
"name": "Extract from File"
},
{
"parameters": {
"operation": "download",
"fileId": {
"__rl": true,
"value": "1q7nw2soeA3VHYtOVl2oD6F3-TmaqYeJo",
"mode": "list",
"cachedResultName": "All.csv",
"cachedResultUrl": "https://drive.google.com/file/d/1q7nw2soeA3VHYtOVl2oD6F3-TmaqYeJo/view?usp=drivesdk"
},
"options": {}
},
"type": "n8n-nodes-base.googleDrive",
"typeVersion": 3,
"position": [
1256,
0
],
"id": "0437ce8b-777c-42be-be8d-075c814ff7e9",
"name": "Google Drive1",
"credentials": {
"googleDriveOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"options": {}
},
"type": "n8n-nodes-base.extractFromFile",
"typeVersion": 1,
"position": [
1476,
0
],
"id": "6969c87e-901d-420d-80ff-f3a7619f233e",
"name": "Extract from File1"
},
{
"parameters": {
"text": "={{ $json.data }}",
"attributes": {
"attributes": [
{
"name": "title",
"description": "Description: A brief headline or summary of the M&A transaction. Example: TRE\u30db\u30fc\u30eb\u30c7\u30a3\u30f3\u30b0\u30b9\u3001\u6728\u6750\u52a0\u5de5\u30fb\u8ca9\u58f2\u306e\u6cc9\u5c71\u6797\u696d\u3092\u5b50\u4f1a\u793e\u5316",
"required": true
},
{
"name": "Buyer",
"description": "Description: The acquiring company or investor making the purchase. Example: TRE\u30db\u30fc\u30eb\u30c7\u30a3\u30f3\u30b0\u30b9",
"required": true
},
{
"name": "target_company_business",
"description": "Description: The company, subsidiary, or business being acquired. Example: \u6cc9\u5c71\u6797\u696d",
"required": true
},
{
"name": "seller",
"description": "Description: The entity selling the company or business. Example: \u500b\u4eba\u682a\u4e3b2\u4eba",
"required": true
},
{
"name": "date",
"description": "Description: The announcement or closing date of the M&A transaction. Example: 2024-01-25",
"required": true
},
{
"name": "transaction_amount",
"description": "Description: The monetary value of the transaction. Write (\u975e\u516c\u8868) is not specified. Example: 525\u4e07\u5186",
"required": true
},
{
"name": "scheme",
"description": "Description: The structure of the deal (e.g., share acquisition, asset transfer). Example: \u682a\u5f0f\u8b72\u6e21",
"required": true
},
{
"name": "industry_of_target_company_business",
"description": "Description: The industry category of the overall M&A deal, often the buyer's or the broader sector. Example: \u6797\u696d",
"required": true
},
{
"name": "details",
"description": "Description: Additional relevant information or strategic rationale. Example: TRE\u30db\u30fc\u30eb\u30c7\u30a3\u30f3\u30b0\u30b9\u306f\u5b50\u4f1a\u793e\u306e\u30bf\u30b1\u30a8\u30a4\u3092\u901a\u3058\u3066\u3001\u6cc9\u5c71\u6797\u696d\u306e\u5168\u682a\u5f0f\u3092\u53d6\u5f97\u3057\u5b50\u4f1a\u793e\u5316\u3002\u6797\u696d\u306b\u719f\u7df4\u3057\u305f\u4eba\u6750\u306e\u78ba\u4fdd\u3068\u6728\u8cea\u30d0\u30a4\u30aa\u30de\u30b9\u767a\u96fb\u4e8b\u696d\u306e\u5b89\u5b9a\u7684\u306a\u71c3\u6599\u6750\u8abf\u9054\u3092\u898b\u8fbc\u3080\u3002",
"required": true
}
]
},
"options": {}
},
"type": "@n8n/n8n-nodes-langchain.informationExtractor",
"typeVersion": 1,
"position": [
880,
250
],
"id": "faee4193-cb76-440c-b267-47eb401f1a26",
"name": "Information Extractor"
},
{
"parameters": {
"model": "llama3.3:latest",
"options": {}
},
"type": "@n8n/n8n-nodes-langchain.lmOllama",
"typeVersion": 1,
"position": [
968,
470
],
"id": "b3718c9b-d149-41c4-bd92-c4cb7a402d0c",
"name": "Ollama Model",
"credentials": {
"ollamaApi": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"options": {}
},
"type": "n8n-nodes-base.convertToFile",
"typeVersion": 1.1,
"position": [
1256,
250
],
"id": "1f826341-b3c0-4bc1-a698-ed946f3cf472",
"name": "Convert to File"
},
{
"parameters": {
"options": {}
},
"type": "n8n-nodes-base.extractFromFile",
"typeVersion": 1,
"position": [
1476,
250
],
"id": "4c208058-71be-4e78-ae9b-a1753d2eaac9",
"name": "Extract from File2"
},
{
"parameters": {},
"type": "n8n-nodes-base.merge",
"typeVersion": 3.1,
"position": [
1696,
125
],
"id": "05bbc35f-7b7b-4771-aa3c-0aaad45d5f30",
"name": "Merge"
},
{
"parameters": {
"operation": "update",
"fileId": {
"__rl": true,
"value": "1q7nw2soeA3VHYtOVl2oD6F3-TmaqYeJo",
"mode": "list",
"cachedResultName": "All.csv",
"cachedResultUrl": "https://drive.google.com/file/d/1q7nw2soeA3VHYtOVl2oD6F3-TmaqYeJo/view?usp=drivesdk"
},
"changeFileContent": true,
"options": {}
},
"type": "n8n-nodes-base.googleDrive",
"typeVersion": 3,
"position": [
2136,
250
],
"id": "8f5cef38-1688-41c7-80b4-0390986c899e",
"name": "Google Drive2",
"credentials": {
"googleDriveOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"options": {}
},
"type": "n8n-nodes-base.convertToFile",
"typeVersion": 1.1,
"position": [
1916,
125
],
"id": "5ee704bd-913a-40b0-8fc8-1c9999d8d900",
"name": "Convert to File1"
}
],
"connections": {
"When clicking \u2018Test workflow\u2019": {
"main": [
[
{
"node": "Google Drive",
"type": "main",
"index": 0
}
]
]
},
"Google Drive": {
"main": [
[
{
"node": "Extract from File",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[],
[
{
"node": "Information Extractor",
"type": "main",
"index": 0
},
{
"node": "Google Drive1",
"type": "main",
"index": 0
}
]
]
},
"Extract from File": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Google Drive1": {
"main": [
[
{
"node": "Extract from File1",
"type": "main",
"index": 0
}
]
]
},
"Information Extractor": {
"main": [
[
{
"node": "Convert to File",
"type": "main",
"index": 0
}
]
]
},
"Ollama Model": {
"ai_languageModel": [
[
{
"node": "Information Extractor",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Convert to File": {
"main": [
[
{
"node": "Extract from File2",
"type": "main",
"index": 0
}
]
]
},
"Extract from File2": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 0
}
]
]
},
"Extract from File1": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 1
}
]
]
},
"Merge": {
"main": [
[
{
"node": "Convert to File1",
"type": "main",
"index": 0
}
]
]
},
"Google Drive2": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Convert to File1": {
"main": [
[
{
"node": "Google Drive2",
"type": "main",
"index": 0
}
]
]
}
},
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "51ec2875-b8f2-47e3-a533-0f91419aa957",
"meta": {
"templateCredsSetupCompleted": true
},
"id": "uSATx8BjUXyyRh7j",
"tags": []
}
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
googleDriveOAuth2ApiollamaApi
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Ma Extractor. Uses googleDrive, informationExtractor, lmOllama. Event-driven trigger; 13 nodes.
Source: https://github.com/Shingo8843/n8nWorkFlows_AI_Agent/blob/e07504f1602b09670ad288061fb194401cc9bf10/workflows/MA_Extractor.json — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
🎯 Create viral TikToks, Shorts, Reels, podcasts, and ASMR videos in minutes — all on autopilot.
OpenAI, HTTP Request, Form Trigger +7
This end-to-end AI-powered recruitment automation workflow helps HR and talent acquisition teams automate the complete hiring pipeline—from resume intake and parsing to GPT-4-based evaluation, TA appr
Form Trigger, Output Parser Structured, Google Drive +10
CV → Match → Screen → Decide, all automated
HTTP Request, Information Extractor, Google Sheets +7
This n8n template automatically crawls technical documentation websites, scrapes their content, and converts it into clean, structured, developer-friendly documentation. Each page is organized into fo
Google Drive, N8N Nodes Olostep, Information Extractor +3
This workflow automates the process of transforming any website URL into a structured, intelligent company profile. It's triggered by a form, allowing a user to submit a website and choose between a "
Supabase, Lm Chat Mistral Cloud, N8N Nodes Mcp +7