Zapier Integration: Automating Glide Table Data Extraction

Ask for Help
1

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

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

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 :pray:

1 Like
2

I’m not overly familiar with how Zapier works, but your Step 3 can be something like this.

Have a list of rowIDs, a list of formatted dates (if you have a way to store MMDDYYYY or whatever format you want in a basic column, please do so), then format the “today” value in Zapier the same way and apply the JavaScript snippet.

That should get you the session ID. Then go through the same process in the Participants table. Maybe edit the JavaScript snippet a bit so you get a comma-delimited list of user emails this time, finally put that to your email module as who to send the newsletter to.

2 Likes