使用Gemini AI从PDF提取发票数据到Google Sheets 📄
高级
这是一个Content Creation, Multimodal AI领域的自动化工作流，包含 28 个节点。主要使用 Code, Gmail, Limit, GoogleDrive, HttpRequest 等节点。 使用Gemini AI从PDF提取发票数据到Google Sheets 📄
前置要求
- •Google 账号和 Gmail API 凭证
- •Google Drive API 凭证
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
- •Google Gemini API Key
使用的节点 (28)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "dca66bfe20538326afcf0ea9818c4e437640a050446b589da002699d11b2eea7",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "714b6c99-8f0a-439b-94d7-29bea1589dba",
"name": "介绍便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1888,
-880
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "36f55639-f8b7-4733-b9e5-a17551fdb633",
"name": "设置便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1520,
-880
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "f1b4ea4f-7566-41e2-af24-e4a19b5d93c5",
"name": "AI提取便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
432,
-992
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "37dbc171-8e58-4eb6-a326-e3629dfc41b0",
"name": "数据分割便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
992,
-1008
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "11ffaff7-b3cc-408a-9abe-43b794a5463f",
"name": "Google表格便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
1584,
-944
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "9c4e40cd-8129-428d-a88d-b5562350b75b",
"name": "Gmail便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
1376,
-1312
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "ffcac485-5c9c-485c-bc6e-fb01a00aecb9",
"name": "扩展便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
1664,
-1312
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "44ec1ad5-daa0-49fc-b502-4f176a112413",
"name": "Compare Datasets1",
"type": "n8n-nodes-base.compareDatasets",
"position": [
-432,
-720
],
"parameters": {},
"typeVersion": 2.3
},
{
"id": "2c3bbfee-8ca9-4e88-bf9c-e4cdbb99d9db",
"name": "从文件1提取",
"type": "n8n-nodes-base.extractFromFile",
"position": [
256,
-704
],
"parameters": {},
"typeVersion": 1
},
{
"id": "559ca06b-7caf-4852-b27c-44fa8f24f416",
"name": "Google Gemini 聊天模型2",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
512,
-560
],
"parameters": {},
"typeVersion": 1
},
{
"id": "3dbb9100-2549-4421-814c-a3260e31cf4d",
"name": "记录文档处理过程1",
"type": "n8n-nodes-base.googleSheets",
"position": [
1680,
-720
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "1b3f9c22-09a3-401f-9f1a-3226dd535a4d",
"name": "清理输出1",
"type": "n8n-nodes-base.code",
"position": [
-656,
-800
],
"parameters": {},
"typeVersion": 2
},
{
"id": "96c85220-8cf0-4e6a-bbb5-870a7129c3ea",
"name": "获取PDF文件列表1",
"type": "n8n-nodes-base.httpRequest",
"position": [
-848,
-800
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "8c29b1cf-983f-4a4c-a031-b42f351f7b46",
"name": "读取已处理文档1",
"type": "n8n-nodes-base.googleSheets",
"position": [
-736,
-608
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "74c6773d-4794-4b9a-8600-0c3d76dd8ca4",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-928,
-880
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "70d08a7f-2e3f-4c87-b211-42f9431fdd79",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-144,
-880
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "df813074-a781-45ea-98a0-5941f22fa7f8",
"name": "AI代理 - 从文本中获取目标元素1",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
544,
-784
],
"parameters": {},
"typeVersion": 1.9
},
{
"id": "479aa135-bed9-464d-9d0f-fd1e21f0958f",
"name": "便签7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1184,
-880
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "fcdb2e08-cb36-479b-85fc-3e30219e5d24",
"name": "Google Drive Trigger1",
"type": "n8n-nodes-base.googleDriveTrigger",
"position": [
-1120,
-704
],
"parameters": {},
"typeVersion": 1
},
{
"id": "548694d2-ced7-4047-8ce2-99077202c840",
"name": "下载文件1",
"type": "n8n-nodes-base.googleDrive",
"position": [
64,
-704
],
"parameters": {},
"typeVersion": 3
},
{
"id": "0fcd4caf-6f6b-41ad-b882-c7c58fd3e0e4",
"name": "结构化输出解析器1",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
688,
-608
],
"parameters": {},
"typeVersion": 1.3
},
{
"id": "1f2a7b86-5134-4541-8c84-f5544f62f4c8",
"name": "Google Gemini 聊天模型3",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
768,
-480
],
"parameters": {},
"typeVersion": 1
},
{
"id": "7f825e30-be8e-4ada-a74e-0831ea3580bd",
"name": "限制1",
"type": "n8n-nodes-base.limit",
"disabled": true,
"position": [
-128,
-704
],
"parameters": {},
"typeVersion": 1
},
{
"id": "11e663ae-b30d-4b22-9c85-92a09bf94818",
"name": "Send a message1",
"type": "n8n-nodes-base.gmail",
"position": [
1456,
-1120
],
"webhookId": "8783a094-d477-4a8a-af9c-ce6fa4c5bb29",
"parameters": {},
"executeOnce": true,
"typeVersion": 2.1
},
{
"id": "2c9e2591-51ca-4cf3-b1b8-f30a854a0a0f",
"name": "更新发票字段1",
"type": "n8n-nodes-base.googleSheets",
"position": [
1456,
-784
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "02719e23-6981-4dab-81ba-b49ff1462cb2",
"name": "循环遍历项目1",
"type": "n8n-nodes-base.splitInBatches",
"position": [
1008,
-784
],
"parameters": {},
"typeVersion": 3
},
{
"id": "767efe5c-6da5-4048-a56a-dec53da68438",
"name": "JavaScript代码1",
"type": "n8n-nodes-base.code",
"position": [
1232,
-784
],
"parameters": {},
"typeVersion": 2
},
{
"id": "571d934d-c285-402a-aab3-7020dc9e2614",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
208,
-880
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"Limit1": {
"main": [
[
{
"node": "Download file1",
"type": "main",
"index": 0
}
]
]
},
"Cleans output1": {
"main": [
[
{
"node": "Compare Datasets1",
"type": "main",
"index": 0
}
]
]
},
"Download file1": {
"main": [
[
{
"node": "Extract from File1",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items1": {
"main": [
[
{
"node": "Send a message1",
"type": "main",
"index": 0
}
],
[
{
"node": "Code in JavaScript1",
"type": "main",
"index": 0
}
]
]
},
"Compare Datasets1": {
"main": [
[
{
"node": "Limit1",
"type": "main",
"index": 0
}
]
]
},
"Extract from File1": {
"main": [
[
{
"node": "AI Agent - get targeted elements from text1",
"type": "main",
"index": 0
}
]
]
},
"Code in JavaScript1": {
"main": [
[
{
"node": "Update invoice Fields1",
"type": "main",
"index": 0
}
]
]
},
"Read processed docs1": {
"main": [
[
{
"node": "Compare Datasets1",
"type": "main",
"index": 1
}
]
]
},
"Google Drive Trigger1": {
"main": [
[
{
"node": "Get list of pdf files1",
"type": "main",
"index": 0
},
{
"node": "Read processed docs1",
"type": "main",
"index": 0
}
]
]
},
"Get list of pdf files1": {
"main": [
[
{
"node": "Cleans output1",
"type": "main",
"index": 0
}
]
]
},
"Update invoice Fields1": {
"main": [
[
{
"node": "Log the processing of the doc1",
"type": "main",
"index": 0
}
]
]
},
"Google Gemini Chat Model2": {
"ai_languageModel": [
[
{
"node": "AI Agent - get targeted elements from text1",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Google Gemini Chat Model3": {
"ai_languageModel": [
[
{
"node": "Structured Output Parser1",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Structured Output Parser1": {
"ai_outputParser": [
[
{
"node": "AI Agent - get targeted elements from text1",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Log the processing of the doc1": {
"main": [
[
{
"node": "Loop Over Items1",
"type": "main",
"index": 0
}
]
]
},
"AI Agent - get targeted elements from text1": {
"main": [
[
{
"node": "Loop Over Items1",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 内容创作, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
使用 Gemini AI、Google Sheets 和 Apps Script 匿名化和重新格式化简历
使用 Gemini AI、Google Sheets 和 Apps Script 匿名化和重新格式化简历
Code
Google Drive
Http Request
+8
18 节点Louis
人力资源
AI驱动的邮件分诊与自动回复系统，集成OpenAI代理和Gmail
AI驱动的邮件分诊与自动回复系统，集成OpenAI代理和Gmail
If
Set
Gmail
+20
68 节点Abdullahi Ahmed
内容创作
使用 Azure OpenAI 和 Google Workspace 自动化 DEI 资格筛选
使用Azure GPT-4o、Google云端硬盘和表格自动进行DEI资格筛选
If
Code
Gmail
+9
19 节点Rahul Joshi
内容创作
使用OpenAI、RunwayML和ElevenLabs自动化无脸短视频
使用OpenAI、RunwayML和ElevenLabs自动化无脸短视频：从脚本到社交媒体
Set
Code
Wait
+18
56 节点LeeWei
内容创作
使用 Mistral AI、LinkedIn 和 Google Sheets 自动化职位搜索与简历定制
使用 Mistral AI、LinkedIn 和 Google Sheets 自动化职位搜索与简历定制
Set
Code
Html
+18
46 节点Jordan Hoyle
个人效率
Apollo 数据抓取与触达流程 1 ✅
使用 Apollo、AI 解析和定时邮件跟进自动生成潜在客户
If
Code
Wait
+13
39 节点Deniz
内容创作
工作流信息
难度等级
高级
节点数量28
分类2
节点类型14
作者
Louis
@louisdl🚀 Business & tech consultant specialized in No Code automation and AI. I help SMEs, startups, and independents save time and cut costs with scalable workflows in n8n and other tools. Passionate about making automation simple, useful, and human-centered. 👉 Also sharing automation insights on YouTube Find all my links here : https://linktr.ee/cashflows.routine And my AI Agency here : https://agence-alain.fr
外部链接
在 n8n.io 查看 →
分享此工作流