OTP extraction & mail content reading

Hi team,

I want to get the OTP from the mail server and pass the same to the application for login.
can you please help in how to proceed with the same.
Also we need to validate the content of the email via excel stored data or external application.
Please let me know if katalon has some inbuilt capabilities for the same or we need to write some external code for its extraction and validation.

There is a free plugin avaiable to read emails from a Gmail server.

https://store.katalon.com/product/39/Read-and-Write-Gmail-Messages-Custom-Keywords

Then there is another keyword to read and write data using excel.

https://store.katalon.com/product/34/Read-Write-Excel-Custom-Keywords