Author: Oliver Bardenheier
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.
Currently the invoices from OVH do not come as an attachment via mail, it is just a link. So, the receiver has to be logged in to the ovh account to download the file. Even more effort if one is using 2FA. This workflow retrieves all information through the oauth2 token.
This Workflow automatically retrieves invoice data, -files from Your OVH.com account and puts the Data in a Google Spreadsheet for further processing.
It also saves the invoice PDF to a certain (yearly) folder in Your Google Drive.
Make a copy of this Google Sheet Template
Set the timeframe for the query to Your likings in "Query Latest OVH Invoices"
You could set an email trigger before and make the frame only one day.
Log into Your OVH Account and get Your Credentials here
Authentication using oAuth2 Authorization Code
"Login with OVHcloud SSO"
You need to Authorize OVHcloud API console
If this worked fine You'll see a green text:
"Access Token Received"
Head over to the OVH API Console to get Your Token.
Set Up Header Auth in the HTTP nodes:
Authentication = Generic Credential Type
Generic Auth Type = Header Auth
Header Auth = Your OVH Header Credentials:
-- a.) In every API Call in the console You'll find a curl example, just take the data from the line including:
-H "authorization: Bearer eyJhxxxxxxxxxxxxxxxxxxxxxxxxxxxxx......"
-- b.) Create a new Credential in n8n for the header auth.
Put in the 'name' Field: authorization
Copy Your Token including Bearer in the value field: 'Bearer eyJhxxxxxxxxxxxxxxxxxxxxxxxxxxxxx......'