RetroSender - Google spreadsheet improvement

RetroSender is a JavaScript script used with Google Sheets by employees to send out weekly e-mail reports to the clients. Right now the employees manually fill out the weekly report as a separate file, and the current script just sends out emails with the button click. The employees want this report to be filled automatically and count hours on activity types