Retrieving logs for Google Sheets

Hi,
I'm making a google spreadsheet that simply gives me statistics of my trades. I started by copying the related log files manually in and that works nicely. Naturally I'd want to automate this with API using addons.
I can't make it work however. All I can extract is a 100 lines from a log, even with to/from.

Can it really be that the best way to do this is manual copy/paste?

You can make an AppScript for your spreadsheet to get logs every 5 minutes, manipulate them and update the spreadsheet

EDIT:
Forgot to mention that with new logs you can scrape them using logtype and logcategories, so you get 100 entries of that specific type (trade in your case)

I’ve got a friend who pulled the entire log history so I assume it’s possible, but I don’t know specifics. You can only pull 100 at a time