Reimburses small expenses straight away, asks a manager to approve anything over $500, and updates the sheet and the employee.
Uses
Gmail
Google Sheets
Approve expenses from a Google Sheet
expense.When a row is added to the spreadsheet. Save it as expense.managerEmail to blank.approved to true.expense.fields.Amount is greater than 500If expense.fields.Amount is greater than 500Yes
expense.fields.Amount expense from expense.fields["Employee email"] Save it as decision.
Who to ask: managerEmail
Prepared by: expense.fields["Employee email"]expense.fields["Employee email"] is asking to be reimbursed expense.fields.Amount for expense.fields.Description.approved to decision.approved.Change approved to decision.approved.No
No steps
Reimbursed if approved is yes, otherwise Rejected and save it as status.status on row expense.row_number of expense.sheet_name in expense.spreadsheet_url. Save it as marked.Google Sheetsexpense.fields["Employee email"]. Save it as emailed.
Subject: Your expense: statusHi,
Your expense for expense.fields.Description (expense.fields.Amount) has been marked status.Gmail