Gemini AIを使ってPDFから送付書データをGoogle Sheetsに抽出 📄
上級
これはContent Creation, Multimodal AI分野の自動化ワークフローで、28個のノードを含みます。主にCode, Gmail, Limit, GoogleDrive, HttpRequestなどのノードを使用。 PDFからのインボイスデータをGemini AIで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": "Intro Sticky",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1888,
-880
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "36f55639-f8b7-4733-b9e5-a17551fdb633",
"name": "設定up Sticky",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1520,
-880
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "f1b4ea4f-7566-41e2-af24-e4a19b5d93c5",
"name": "AI Extraction Sticky",
"type": "n8n-nodes-base.stickyNote",
"position": [
432,
-992
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "37dbc171-8e58-4eb6-a326-e3629dfc41b0",
"name": "Data Split Sticky",
"type": "n8n-nodes-base.stickyNote",
"position": [
992,
-1008
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "11ffaff7-b3cc-408a-9abe-43b794a5463f",
"name": "Google スプレッドシート Sticky",
"type": "n8n-nodes-base.stickyNote",
"position": [
1584,
-944
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "9c4e40cd-8129-428d-a88d-b5562350b75b",
"name": "Gmail Sticky",
"type": "n8n-nodes-base.stickyNote",
"position": [
1376,
-1312
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "ffcac485-5c9c-485c-bc6e-fb01a00aecb9",
"name": "Extend Sticky",
"type": "n8n-nodes-base.stickyNote",
"position": [
1664,
-1312
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "44ec1ad5-daa0-49fc-b502-4f176a112413",
"name": "データセット比較1",
"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": "Log the processing of the doc1",
"type": "n8n-nodes-base.googleSheets",
"position": [
1680,
-720
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "1b3f9c22-09a3-401f-9f1a-3226dd535a4d",
"name": "Cleans output1",
"type": "n8n-nodes-base.code",
"position": [
-656,
-800
],
"parameters": {},
"typeVersion": 2
},
{
"id": "96c85220-8cf0-4e6a-bbb5-870a7129c3ea",
"name": "Get list of pdf files1",
"type": "n8n-nodes-base.httpRequest",
"position": [
-848,
-800
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "8c29b1cf-983f-4a4c-a031-b42f351f7b46",
"name": "Read processed docs1",
"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 エージェント - get targeted elements from text1",
"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 ドライブ Trigger1",
"type": "n8n-nodes-base.googleDriveTrigger",
"position": [
-1120,
-704
],
"parameters": {},
"typeVersion": 1
},
{
"id": "548694d2-ced7-4047-8ce2-99077202c840",
"name": "Download file1",
"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": "Update invoice Fields1",
"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": "コード in JavaScript1",
"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": "548694d2-ced7-4047-8ce2-99077202c840",
"type": "main",
"index": 0
}
]
]
},
"1b3f9c22-09a3-401f-9f1a-3226dd535a4d": {
"main": [
[
{
"node": "Compare Datasets1",
"type": "main",
"index": 0
}
]
]
},
"548694d2-ced7-4047-8ce2-99077202c840": {
"main": [
[
{
"node": "Extract from File1",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items1": {
"main": [
[
{
"node": "11e663ae-b30d-4b22-9c85-92a09bf94818",
"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": "2c9e2591-51ca-4cf3-b1b8-f30a854a0a0f",
"type": "main",
"index": 0
}
]
]
},
"8c29b1cf-983f-4a4c-a031-b42f351f7b46": {
"main": [
[
{
"node": "Compare Datasets1",
"type": "main",
"index": 1
}
]
]
},
"Google Drive Trigger1": {
"main": [
[
{
"node": "96c85220-8cf0-4e6a-bbb5-870a7129c3ea",
"type": "main",
"index": 0
},
{
"node": "8c29b1cf-983f-4a4c-a031-b42f351f7b46",
"type": "main",
"index": 0
}
]
]
},
"96c85220-8cf0-4e6a-bbb5-870a7129c3ea": {
"main": [
[
{
"node": "1b3f9c22-09a3-401f-9f1a-3226dd535a4d",
"type": "main",
"index": 0
}
]
]
},
"2c9e2591-51ca-4cf3-b1b8-f30a854a0a0f": {
"main": [
[
{
"node": "3dbb9100-2549-4421-814c-a3260e31cf4d",
"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
}
]
]
},
"3dbb9100-2549-4421-814c-a3260e31cf4d": {
"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 スプレッドシート、Apps Script を使用して履歴書を匿名化し、書式を再構築する
Code
Google Drive
Http Request
+
Code
Google Drive
Http Request
18 ノードLouis
人事
AI驱动のメール分诊与自動回复系统，統合OpenAIエージェントとGmail
AI驱动のメール分诊与自動回复系统，統合OpenAIエージェントとGmail
If
Set
Gmail
+
If
Set
Gmail
68 ノードAbdullahi Ahmed
コンテンツ作成
Azure OpenAI とGoogle Workspace で DEI 資格フィルター Automation
Azure GPT-4o、Googleドライブ、テーブルを使ってDEI資格フィルタリングを自動化
If
Code
Gmail
+
If
Code
Gmail
19 ノードRahul Joshi
コンテンツ作成
OpenAI、RunwayML、ElevenLabsを使って無顔の短い動画を自動化
OpenAI、RunwayML、ElevenLabs を使ってアニメ顔の短い動画を自動化：スクリプトからソーシャルメディアへ
Set
Code
Wait
+
Set
Code
Wait
56 ノードLeeWei
コンテンツ作成
Mistral AI、LinkedIn、Google Sheets を使って求人検索と履歴書のカスタマイズを自動化
Mistral AI、LinkedIn、Google Sheets を使って 自動採用情報の検索とCVカスタマイズを行う
Set
Code
Html
+
Set
Code
Html
46 ノードJordan Hoyle
個人の生産性
Apollo データスクレイピングとタッチアウトフロー 1 ✅
Apollo、AI による解析と計画されたメール.follow-up によるリード生成の自動化
If
Code
Wait
+
If
Code
Wait
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で表示 →
このワークフローを共有