Sales source data extraction into spreadsheet or dashboard

I’m wanting to extract sales data and record it onto a spreadsheet or dashboard

We already use Service M8 which also works with the Go High Level software as our CRM so want to extract the info from these softwares.

We cannot extract from our ecommerce store as we also have non-online sales too.

I’m wanting to hopefully automatically (if at all possible) record all sales/invoice total and also record the source where they arrived from…

Basically were looking to track what ROI we get from facebook Ads and Google Ads and also what percentage and amount we get organically.

Because we spend, what I consider a lot of money on those advertising channels I’m wanting to try and find out just how much ROI I get from them

Do you think this maybe something you could help with please or advise

My website is:

https://artificialsupergrass.co.uk/