Hello. This is my first time using zapier + glide. I need a scenario that will do the following:

1. In one of the glide tables I have a table called «sessions» and there is a column with date & time. I need zapier to take data from there once a day and check whether today’s date is there.
2. If there is, then it should take the row id of this «session», go to another table called «participants» and look for the IDs of all participants who were recorded in this session and filter them by the status «confirmed».
3. Then I need to then I need to send a newsletter to all filtered participants

My steps:

Step 1: Every Day in Schedule by Zapier

Step 2: Get all rows from glide

Step 3: Looping by Zapier – Here I choose «date&time» and «row id» as values to loop

Step 4: Date / Time in Formatter by Zapier – settings: http://joxi.ru/Vm6EZNVHKwZMqr 1

Step 5: Only continue if… – settings&output: http://joxi.ru/BA0J5xVcqLWEym 1

Here zapier didn’t find today’s session and also I realized that next step I must create «get all rows» to proceed with the second table «participants» and filter data, but I can’t use looper twice.

Please help