Extracting Gmail Header and Body Data into Spreadsheet or Database

Hi guys,

It's been a while since i've needed your help but I'm really stuck on this one.

I receive customer leads via a website form into Gmail that i need to organise somehow.

When they arrive in Gmail they are automatically labelled and sent to a folder called Biowash - Enquiries as shown in attached Gmail Folder.jpg image

I would then want any new unread emails to be extracted (as highlighted in Gmail Folder Body Text + Header Info.jpg image attached), sorted and added to a spreadsheet in the format as shown in the attached Customer orders.xlsm file in sheet 2

I've copy and pasted 1 email files data into sheet 1 of the same file.

I've tried to explain this as best i can but let me know if more clarity is required.

Many thanks in advance to anyone making any attempt to provide a solution for me.

Regards
John