Auto population google sheet with gatling report


I am working to fully automate gatling reports generation as a high level report e.g. report for a director of engineering who is only interested with how a certain service is response to high load. To do this, i want to autofill a google sheet with data from the gatling html report that will create a more readable chart.

My question is, is there any library that i can integrate in my codebase or a Jenkins plugin i can use to achieve this.