Xero API feeds into a live spreadsheet or program

Job ID: 37873691

Budget: £20 – £250 GBP

Xero has an add-on called Xero Projects, which is where I record my time on certain Projects and Tasks. Xero knows my hourly rate and calculates my 'unbilled time'.

First, I want to get my Clients, their invoice history, and unbilled time into a spreadsheet.

Then, I want the ability to drag my unbilled time into different months (say as a columns). The idea being that I look at the current month, and decide what to invoice, or to drag the unbilled time to another column.

I want to get this data into a spreadsheet, or similar looking program. I use windows.

I attach a spreadsheet as an example. Note that data in Yellow is the information to extract from the API feed.

Xero API info can be found here: https://developer.xero.com/documentation/api/projects/projects

I'm bored of bots replying to my freelancer jobs in seconds, claiming they've read everything. Perhaps start your message with 'Yo Andy' so I know you're human ;) Thanks.
Related categories: Xero API Airtable