Script for Google Sheets to re-format XLS for Zoho Inventory invoice upload

We are currently using Google Forms to create an order form in Google Sheets that we can build Invoices in Zoho Inventory with MANUALLY. I believe we want to continue using google forms since our staff knows how to build these forms. HOWEVER, the google sheet data cannot create one invoice per customer with the multiple skus and allow us to easily import to Zoho invoices.

GOAL: To Create a script that takes the 1 line order in Google Sheets (see attached), that will contain multiple skus on that one line before formatting, and reformats to an XLS/CSV so that Zoho Inventory can import properly based on their format.

SEE zoho's SAMPLE INVOICES attached. I believe this is what Zoho requires for the formatting, with each LINE containing a single SKU to order. The script will need to take the CUSTOMER email (what we will use for the required customer ID) and repeat it on each line with the SKUS that are in the single line spreadsheet in Google Sheets (See example xls attached).

The goal of course will be the create ONE INVOICE (invoice number can auto-generate) per customer/email id.. but have EACH SKU (you can see the sku number listed) listed on that invoice.