Generating report


I have a sheet with some checkboxes and text to fill in. I would like to make an automation that generates a report based on whole sheet everyday at midnight and send it as a attachment to person who filled it in.

We will be using mobiles to fill out the sheet. The idea is to generate PDF based on the sheet and send it over email to person who was assigned.

Is there an option to do that?