Zapier Integration: Automating Glide Table Data Extraction

[ThinhDinh]

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

Just successfully tested this. Add a “Code by Zapier” step and choose Run Javascript. [image] Setup the inputs as I have below. [image] 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.