Use API to gather data from Etsy and Shopify and auto populate Google Sheets spreadsheet

I run @[login to view URL] ([login to view URL]) and create custom digital Illustrations. I currently have 2 sales streams from Etsy and Shopify which I manually enter into my spreadsheet. Each row is an illustration (note some orders have multiple illustrations). I would like a script created for my google sheets that automatically inserts new rows for every new order and separates the illustrations into their own rows. Each new row would need to populate all important information such as date, item price, order source, illustration type etc. The average illustrations/orders I get is approx 100-200 a month. A screenshot of my current worksheet is attached, this is currently all manually entered