Daily Report Google sheeets

we are authorised dealer for Royal Enfield sales & service here in Guwahati. Need to build a daily report google sheets , automated, input will be some statements from our software. output should be reports in pdf format of showroom and service and individual performance report.