Sync OVH Invoices to Google Sheets and Save PDFs to Google Drive — n8n 工作流
概览
🛠️Setup Guide 'Get OVH Invoices to Google Sheets' Author: Oliver Bardenheier
Who is this for? This Workflow is for all users who have services (Domains, BareMetal, VPS, Cloud, etc.) with Provider OVH.com (European API) It automatically retrieves invoice data, -files and puts the Data in a Google Spreadsheet for further processing.
What problem is this workflow solving? / use case Currently the invoices from OVH do not come as an attachment via mail, it is just a link. So, the receiver has to
使用的节点
Google SheetsHTTP RequestGoogle DriveCode
工作流预览
⚡
W
When clicking ‘Test work…
L
Loop Over Items
S
Split Out
Get Invoice Data
Safe File
Create Folder
Download PDF
Record in OVH Sheet
Query Latest OVH Invoices
Convert to Array
Check for FY Folder ID
D
Does Folder exist
Update Record Data with …
13 nodes14 edges
工作原理
- 1
触发器
工作流由 触发器 触发器启动。
- 2
处理
数据流经 13 个节点, connecting code, googledrive, googlesheets。
- 3
输出
工作流完成自动化并将结果发送到配置的目标。
节点详情 (13)
GO#1
Google Sheets
googleSheets
HT#2
HTTP Request
httpRequest
GO#3
Google Drive
googleDrive
CO#4
Code
code
如何导入此工作流
- 1点击右侧 下载 JSON 按钮保存工作流文件。
- 2打开你的 n8n 实例,依次点击 工作流 → 新建 → 从文件导入。
- 3选择下载的
sync-ovh-invoices-to-google-sheets-and-save-pdfs-to-google-drive文件并点击导入。 - 4为每个服务节点配置 凭证(API 密钥、OAuth 等)。
- 5点击 测试工作流 验证一切正常,然后激活它。
或直接在 n8n → 从 JSON 导入 中粘贴:
{ "name": "Sync OVH Invoices to Google Sheets and Save PDFs to Google Drive", "nodes": [...], ...}
集成
codegoogledrivegooglesheetshttprequestifmanualtriggersplitinbatchessplitout
创建者
Oliver Bardenheier
@ozdreamwalk
标签
codegoogledrivegooglesheetshttprequestifmanualtriggersplitinbatchessplitout