# Zapier Integration: Automating Glide Table Data Extraction
**URL:** https://community.glideapps.com/t/zapier-integration-automating-glide-table-data-extraction/73160
**Category:** Ask for Help
**Created:** [May 7, 2024, 4:31pm UTC](https://community.glideapps.com/t/zapier-integration-automating-glide-table-data-extraction/73160 "2024-05-07T16:31:56Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@Misha\_Kourtalidis](https://community.glideapps.com/u/Misha_Kourtalidis)
#### Post date: [May 7, 2024, 4:31pm UTC](https://community.glideapps.com/t/zapier-integration-automating-glide-table-data-extraction/73160/1 "2024-05-07T16:31:56Z")
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](http://joxi.ru/Vm6EZNVHKwZMqr)
Step 5: Only continue if… – settings&output: [http://joxi.ru/BA0J5xVcqLWEym](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 🙏
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [May 7, 2024, 11:45pm UTC](https://community.glideapps.com/t/zapier-integration-automating-glide-table-data-extraction/73160/2 "2024-05-07T23:45:30Z")
I’m not overly familiar with how Zapier works, but your Step 3 can be something like this.
> [@Zapier integration : Get row ID based on another field](https://community.glideapps.com/t/zapier-integration-get-row-id-based-on-another-field/72995/2):
>
> Just successfully tested this. Add a “Code by Zapier” step and choose Run Javascript. [image] Setup the inputs as I have below. The “search” part will reference the email you want to find the rowID for. Now here’s the code: let emails = inputData.emails.split(","); let rowIDs = inputData.rowIDs.split(","); let index = emails.findIndex(email =\> email.includes(inputData.search)); output = {rowID: rowIDs[index]}; I split the emails and rowIDs into arrays, then find the index of t…
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.