Automating Seller Board Data Extraction

I have a question for anyone who has experience working with Amazon ads and seller central data management/reporting.

For a business, I am trying to automate the process of extracting sales and ad spend data on a daily/weekly basis. My own research shows that we can get a developer account and get an API but the business owner does not want to get into anything that requires technical knowledge of any kind. He wants to get something that works as a no code solution.

I have tried to extract data with windsor.ai, powermyanalytics and a few other connectors but not everything is available on them.

Can anybody guide on what would be the best way to automatically extract sales and ads from Amazon?

let me know if you need more clarification about my requirement.