Sync OVH invoices to Google Sheets and save PDFs to Google Drive
Ready for 3.0What this workflow does
This workflow has 13 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Drive and Google Sheets. It also calls eu.api.ovh.com over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Query Latest OVH Invoices (HTTP Request): calls eu.api.ovh.com
- Convert to Array (Code): runs custom JavaScript code
- Split Out: splits a list into separate items
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Get Invoice Data (HTTP Request): calls an HTTP API
- Record in OVH Sheet (Google Sheets): append or update
- Check for FY Folder ID (Google Drive): work with file folder
- Does Folder exist (If): checks a condition and branches into true / false
- Create Folder (Google Drive): work with folder
- Download PDF (HTTP Request): calls an HTTP API
…plus 2 more steps. See the full node list below.
Services it uses
HTTP calls to: eu.api.ovh.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 (8)
- Manual Trigger
n8n-nodes-base.manualTrigger - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Split Out
n8n-nodes-base.splitOut - HTTP Request
n8n-nodes-base.httpRequest - Google Drive
n8n-nodes-base.googleDrive - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - If
n8n-nodes-base.if
From the author
🛠️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…