how to write groovy script for success response code which gets saved in xls sheet

hi everyone

how to write a groovy script for the below mentioned scenarios

1)success response taking from the response if the service and gets stored in an excel document specified in particular location

2)based on the time specified the test suite run and generate the report(For ex-i have given some time like every 1hr the test suite should run and generate the report of the success and failure services)

my service response is in this format

"ResponseHeader": {
"UID": 123,
"Messages": [ {
"MsgCode": "ABC_000000",
"MsgSeverity": "xyx",
"MsgDescription": "Success"
}]
}

Please help me on this

Thanks in advance