Sync OVH Invoices to Google Sheets & Save PDFs to Drive

This n8n workflow streamlines invoice management for OVH.com users by automatically retrieving invoice data and PDF files through secure OAuth2 authentication. It queries invoices based on a configurable timeframe (e.g., latest day or custom period), extracts key details like amounts, dates, and descriptions, and appends them to a structured Google Sheets template. Simultaneously, it downloads the invoice PDFs and uploads them to Google Drive in yearly organized folders for easy archiving and access.

OVH invoices are typically sent via email links requiring login and 2FA, making manual downloads tedious and error-prone. This workflow eliminates these pain points by directly interfacing with the OVH API, ensuring no manual intervention is needed. Ideal for users managing domains, VPS, cloud services, or BareMetal with OVH, it supports triggers like email or schedules for daily/weekly automation.

Key benefits include centralized data in Sheets for reporting, analysis, or accounting integration; secure, automated PDF storage; and significant time savings for businesses handling high invoice volumes. Use cases span e-commerce payment tracking, SaaS expense monitoring, and compliance archiving, providing scalable automation without custom coding.

Setup is straightforward: copy the provided Google Sheets template, configure the query node, generate OVH OAuth2 credentials via their API console, and add Header Auth in n8n. Once running, it handles multiple invoices efficiently with looping logic, making it robust for production use.