# Getting data out of Glide, using Zapier or Airtable? **URL:** \ **Category:** Ask for Help\ **Created:** [April 8, 2024, 8:30pm UTC](https://community.glideapps.com/t/getting-data-out-of-glide-using-zapier-or-airtable/72395 "2024-04-08T20:30:40Z")\ **Posts on this page:** 14\ **Page:** 2
**Author:** ![hirereach](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hirereach/32/58130_2.png) [@hirereach](https://community.glideapps.com/u/hirereach)\ **Post date:** [April 24, 2024, 12:17am UTC](https://community.glideapps.com/t/getting-data-out-of-glide-using-zapier-or-airtable/72395/21 "2024-04-24T00:17:08Z")
I do have unique IDs for each of those records. What triggers the action you described below? Is it manual? Unfortunately, with my users workflow, I can’t get them to click a Button to get sent a reminder email. “use a set column action to set that rowID to the “basic rowID” column in that same table.“ ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 24, 2024, 10:00am UTC](https://community.glideapps.com/t/getting-data-out-of-glide-using-zapier-or-airtable/72395/22 "2024-04-24T10:00:35Z")
Sorry, that should have said reference IDs, not unique IDs. > [@hirereach](#): > > What triggers the action you described below? Is it manual? Unfortunately, with my users workflow, I can’t get them to click a Button to get sent a reminder email. No, it’s not manual. It should be integrated directly into your flow here. ![Screenshot 2024-04-21 at 9.24.29 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/f/cf775d6e1853a7874e38638464ca4df2f349ada4.png) As long as you log the ID of the user who created the row, you can follow my steps above. ---
**Author:** ![hirereach](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hirereach/32/58130_2.png) [@hirereach](https://community.glideapps.com/u/hirereach)\ **Post date:** [April 24, 2024, 9:13pm UTC](https://community.glideapps.com/t/getting-data-out-of-glide-using-zapier-or-airtable/72395/23 "2024-04-24T21:13:36Z")
Late in the day here…I’m just not understanding this. In Airtable, I have a unique “Add-People-Sessions LookupCode” that is (i) the SessionNumber and (ii) the user’s email address. This unique value is known for every Add-People-Sessions row before it’s created, unlike the Glide RowID. Or am I wrong and the Glide RowID is predictable so I know what it will be? This Action is triggered in my Sessions-Table, so I can only Create a new row in my Add-People-Sessions-Table (not edit an existing one), so i have to “Set column values” in that same step. What new step am I creating in my Action to achieve what you describe? Do you have an image/video of what you’re describing? I can’t picture it at the moment… ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 25, 2024, 1:24am UTC](https://community.glideapps.com/t/getting-data-out-of-glide-using-zapier-or-airtable/72395/24 "2024-04-25T01:24:04Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/a/9a6c368d63c3f551717e67b4d007abcea451a650.png) I hope this is clearer. Taking all other irrelevant actions in your flow out of the way, I’m just talking about how to set the rowID to a basic column. ---
**Author:** ![hirereach](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hirereach/32/58130_2.png) [@hirereach](https://community.glideapps.com/u/hirereach)\ **Post date:** [April 27, 2024, 6:38pm UTC](https://community.glideapps.com/t/getting-data-out-of-glide-using-zapier-or-airtable/72395/25 "2024-04-27T18:38:51Z")
Thanks, @ThinhDinh! Very clear and helpful. I’ve followed all these steps, but when I create that basic column in Add-People-Sessions, it does not write to/sync with the basic column in the last step ☹ ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 27, 2024, 11:16pm UTC](https://community.glideapps.com/t/getting-data-out-of-glide-using-zapier-or-airtable/72395/26 "2024-04-27T23:16:25Z")
Can you show me in some screenshots what columns you have now? ---
**Author:** ![hirereach](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hirereach/32/58130_2.png) [@hirereach](https://community.glideapps.com/u/hirereach)\ **Post date:** [April 28, 2024, 8:18pm UTC](https://community.glideapps.com/t/getting-data-out-of-glide-using-zapier-or-airtable/72395/27 "2024-04-28T20:18:09Z")
1. Query in the Sessions table: ![Screenshot 2024-04-28 at 4.01.43 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/a/2a922f06ba24ab451064b631414dc6b34f552af9.png) 2. Last row via Single Value (whole row) ![Screenshot 2024-04-28 at 4.03.36 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/b/ab3f4520b574c782b5116e8b3ab96c09c18fcd57.png) 3. Last Row ID via Single Value ![Screenshot 2024-04-28 at 4.05.40 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/d/9dc541ce5974a89abbe3c0cc815bba645f223aec.png) - All the above steps seem to work for me. 1. My issue is trying to Set Column Value in the Action using the info from that Single Value column. I don’t know how it’s possible to wait for 5-6 seconds in the middle of an Action. ![Screenshot 2024-04-28 at 4.12.30 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/1/e1cc210c24954f5d6b92fbf31e8807c45fe12605.jpeg) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 28, 2024, 11:12pm UTC](https://community.glideapps.com/t/getting-data-out-of-glide-using-zapier-or-airtable/72395/28 "2024-04-28T23:12:15Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/4/74e768143cceb7c2f0336241fdaf0677d45bdadd.png) > [@hirereach](#): > > I don’t know how it’s possible to wait for 5-6 seconds in the middle of an Action. You already have that step in the middle of your chain. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/3/432793762a971ae4022970672ac5a47f541e0cc4.jpeg) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/8/88c23c92daffb3cd4c2bdabf636ef910eb4f30dc.png) I’m basically advising you to add the row first, then wait 5-6 seconds so that you can retrieve it’s automatically generated ID, and use a set column action to set that ID back to your basic text column so that it can be synced to Airtable. ---
**Author:** ![hirereach](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hirereach/32/58130_2.png) [@hirereach](https://community.glideapps.com/u/hirereach)\ **Post date:** [May 2, 2024, 10:26pm UTC](https://community.glideapps.com/t/getting-data-out-of-glide-using-zapier-or-airtable/72395/29 "2024-05-02T22:26:37Z")
OK, here’s what I’ve done (screencaps below). It’s still not populating the Row ID in my basic [Add-People-Session] column, even though I can successfully Query the Row ID in my Sessions-Table (per your instructions). There must be something wrong with the way I’m trying to execute the Set Column Values step after the delay…? 1. Query ![Screenshot 2024-05-02 at 6.19.07 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/0/50c477742b67417534e5f33188a35c9e144e7e15.jpeg) 2. Set Column Values ![Screenshot 2024-05-02 at 6.20.56 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/9/a987cf6622ba10372bcd67f552e50e5651cae5b1.jpeg) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [May 2, 2024, 11:43pm UTC](https://community.glideapps.com/t/getting-data-out-of-glide-using-zapier-or-airtable/72395/30 "2024-05-02T23:43:16Z")
Why do you have it as an If-Then-Else column? ---
**Author:** ![hirereach](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hirereach/32/58130_2.png) [@hirereach](https://community.glideapps.com/u/hirereach)\ **Post date:** [May 3, 2024, 12:09am UTC](https://community.glideapps.com/t/getting-data-out-of-glide-using-zapier-or-airtable/72395/31 "2024-05-03T00:09:58Z")
Just for convenience/simplicity; it’s aggregating six different Single Value column types. It doesn’t have to be an if/then column. Here it is with the Single Value, below. ![Screenshot 2024-05-02 at 8.07.49 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/d/0d25623d34c0c598ef9a16383ab6a06c42f7cf5a.jpeg) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [May 3, 2024, 1:01am UTC](https://community.glideapps.com/t/getting-data-out-of-glide-using-zapier-or-airtable/72395/32 "2024-05-03T01:01:54Z")
So even if it’s a single value column that gets the last rowID submitted from the destination table, it doesn’t work? Can you send some screenshots on how you setup those columns as well? ---
**Author:** ![hirereach](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hirereach/32/58130_2.png) [@hirereach](https://community.glideapps.com/u/hirereach)\ **Post date:** [May 5, 2024, 1:31pm UTC](https://community.glideapps.com/t/getting-data-out-of-glide-using-zapier-or-airtable/72395/33 "2024-05-05T13:31:10Z")
Unfortunately, I don’t think I can solve this by creating links for the Add-People-Sessions table. I think I’ll have to create one link for the Sessions table instead. Not my first choice because it adds an extra click for the user to then select the Add-People-Sessions table that they want, but it’s better than nothing. Thanks so much for your help! ---
**Author:** ![Kemal1973](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kemal1973/32/72721_2.png) [@Kemal1973](https://community.glideapps.com/u/Kemal1973)\ **Post date:** [May 6, 2024, 8:58pm UTC](https://community.glideapps.com/t/getting-data-out-of-glide-using-zapier-or-airtable/72395/34 "2024-05-06T20:58:42Z")
> [@hirereach](#): > > A) Maybe it would help to take a step back and describe what I’m trying to achieve. > > 1. I need to send an email (that’s triggered by my user table in Airtable). > 2. This email to my user needs to contain a link to a specific page/screen in that user’s corresponding Glide account (I think that’s called a “deeplink”). > 3. I believe I need the Glide RowID to properly reference that page/screen (or at least that’s what I’ve tried, and it seems to work). > 4. I do not want to send this email directly from Glide. > > What do I need to do to build that capability? > > B) Jeff, per your question, I’m not technical, so I’ll try to respond by describing what I see happening. > > - (i) When I create a column in Airtable, it DOES appear in Glide. > - (ii) When I create a column in Glide (RowID or otherwise), it does NOT appear in Airtable. > - (iii) When I create a basic column (text) in Airtable, I can’t seem to edit it or fill it with Glide info (like RowID). > - (iv) When I create a RowID column in Glide (RowID or otherwise), it does NOT appear in Airtable. > > I need a solution that’s not manual (not copy/paste) from Glide to Airtable. > > Does that help clarify what I’m running into? Airtable has Record ID like RowID in Glide you can set an automation in Airtable what you want like send email [Previous page](https://community.glideapps.com/t/getting-data-out-of-glide-using-zapier-or-airtable/72395.md?page=1)