I'd like to create an automation to send out a notice to individuals who did not meet their quota using data from a spreadsheet.
So every week we get an individual's timesheet that is placed in a Google Sheet. Using this data, I'd like to make an automation to send out a notification to an individual if they have not completed their quota. With each failure of the quota, I'd also like to increase the amount of "Strikes" listed, if they reach 3 strikes, another notification is sent to a supervisor listing the person(s) that did not complete the quota.
Relatively new to Airtable, any help is appreciated.