How to sync data from Coda to Google Sheets and Google Sheets to Coda using Google Apps Script

I tentatively can share that creating a new workbook and importing range from my first workbook’s Dashboard sheet then connecting it to Coda is working! I now need to go back in here and do a full clean up on an actual working demo for my colleague but it looks like I may got this!

Thank you so much.