Hi there ​@Hay Joosten, welcome to the Community!

Hmm, filtering/sorting the actual spreadsheet itself can cause issues with the Zap. See: Spreadsheet updates and maintenance for details.

But perhaps you could use a Google Sheets Lookup Spreadsheet Rows (Advanced) search action to find all the rows where there’s a 2nd Level manager and it’s marked as overdue? 

That said, how do you know when a compliance training is overdue? Is there a due date in the row that could be referenced? I’m wondering if you could potentially create a “due date” event in an app like Google Calendar when the row is first added. Then have a Zap that triggers when the due date event starts, then searches for the corresponding row in the spreadsheet to see if it’s been completed and if it hasn’t then you could create the spreadsheet and send an email to the person with it attached. 

Could that sort of approach work for your needs here?

Thanks for the thoughtful response.

The table contains only overdue compliance courses - so no need to distinguish there. 

I think the problem that I am finding is how to create several spreadsheets from the master spreadsheet, each with only the direct reports of that manager. 

Ah I see, ​@Hay Joosten! Presumably the direct reports are each listed in the individual spreadsheet rows, but is their manager listed as well? 

If their manager is listed, then I think you could achieve what you’re after with the following set of triggers and actions: 

• Trigger: Every Week (Schedule by Zapier) - set up to run every week on a certain day and time. That said, it could also be set to run be every day or every month depending on how frequently you need the Zap to run. See Schedule Zaps to run at specific intervals for more details.
• Action: Create a loop from text (Looping by Zapier) - creates loops from a list of the different manager names. Each of the following actions would be run for each manager. See Create a loop from text for more details.
  • Action: Lookup Spreadsheet Rows (Advanced) (Google Sheets) - searches for the individual manager name and returns multiple rows for each direct report with that manager.
  • Action: Create Spreadsheet (Google Sheets) - this would create a new spreadsheet using the name of the relevant manager.
  • Action: Create Multiple Spreadsheet Rows (Google Sheets) - this adds the data from the spreadsheet rows that were found by the Lookup Spreadsheet Rows action to the new spreadsheet that was created. To select the spreadsheet that was created, in the Spreadsheet field you’d need to use the Custom value option and select the ID field from the previous action step.
  • Action: Utilities (Formatter by Zapier) - Use the Lookup Table transform to create a list of the manager’s names and their corresponding email addresses. See Use a Formatter lookup table step to learn more.
  • Action: Send Email (Gmail) - sends an email to the relevant manager’s email address (taken from the lookup table) with a copy of the spreadsheet attached. See: Send files in Zaps to learn more about how to send files between apps.

Hope that helps to get you pointed in the right direction. If you run into any issues in setting that up or have any questions just let me know! 

This is great! Still having some trouble configuring the individual steps, but this feels like a complete solution - thank you so much!

Yay! That’s great news, ​@Hay Joosten!

Happy to help with any issues in getting the individual steps set up—just send over some screenshots of the Zap setup, showing where you’re getting stuck and we’ll go from there! Just make sure to blur or remove all personal information (names, emails, addresses etc.) from screenshots before sharing - you can use a tool like Zappy for that. 

Looking forward to hearing from you!