In the Approval column, mark your sample responses as Approved or.From the Form Responses sheet, click Timesheets > Column setup.Step 3: Manage approvals and notify employees Fill out and submit the form with test data.Click Tools > Manage form > Go to live form.After you authorize the script, click Timesheets > Form setup again.When prompted, click Review permissions and authorize the script.Refresh the page for this custom menu to appear. At the top of the spreadsheet, click Timesheets > Form setup.Click the button below to make a copy of the Collect and review.A web browser with access to the internet.A Google Account (Google Workspace accounts might require administrator approval).To use this sample, you need the following prerequisites: Notify them when their timesheets have been approved or not. Mail Service: Sends emails to employees to.Forms Service: Creates a form for employees.Responses and writes columns to the sheet to manage approvals.
This solution uses the following services: Once a timesheet is reviewed, the script emails theĮmployee the approval status. Script adds columns to the form responses sheet that calculate employees' total The script creates a Google Form and links the responses to the spreadsheet. From Google Sheets,Ĭalculate employees' pay, approve or disapprove their timesheets, and sendĮmails notifying them of their approval status. Project type: Automation with a custom menu About this solutionĬollect employees' weekly timesheets in a Google Form.