Create Google Sheets Script to Create New Row From New Email

Job ID: 31307384

Budget: $30 – $250 AUD

I have a Google Sheets spreadsheet of a cleaning jobs. Each row is a job.

New jobs are sent to an IMAP email inbox with all the data in the body of the email seperated by "|".

I need to create a script in the spreadsheet that automatically creates a new row in the spreadsheet once a new booking/email arrives in the inbox
Related categories: JavaScript Google Sheets Google APIs