# Extract imfomation from email

**URL:** <https://community.glideapps.com/t/extract-imfomation-from-email/80071>\
**Category:** Ask for Help\
**Created:** [February 15, 2025, 10:10am UTC](https://community.glideapps.com/t/extract-imfomation-from-email/80071 "2025-02-15T10:10:37Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Keith\_Chikumbirike](https://avatars.discourse-cdn.com/v4/letter/k/5daacb/32.png) [@Keith\_Chikumbirike](https://community.glideapps.com/u/Keith_Chikumbirike)\
**Post date:** [February 15, 2025, 10:10am UTC](https://community.glideapps.com/t/extract-imfomation-from-email/80071/1 "2025-02-15T10:10:37Z")

</div>

Im trying to create a workflow in which I extract imfomation from email into the following fields on a specific table

1. Email
2. Payment method
3. Amount paid
4. Time stamp

I’ll need the information to relate to users tables to determine payments by users. Any information on this?

Thanks in advance

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [February 15, 2025, 11:46am UTC](https://community.glideapps.com/t/extract-imfomation-from-email/80071/2 "2025-02-15T11:46:05Z")

</div>

How is the email getting to Glide? Are you using an email triggered workflow?

---

<div class="post-metadata">

**Author:** ![Keith\_Chikumbirike](https://avatars.discourse-cdn.com/v4/letter/k/5daacb/32.png) [@Keith\_Chikumbirike](https://community.glideapps.com/u/Keith_Chikumbirike)\
**Post date:** [February 15, 2025, 12:10pm UTC](https://community.glideapps.com/t/extract-imfomation-from-email/80071/3 "2025-02-15T12:10:20Z")

</div>

Yes…I have set email settings to auto forward to the glide email if the emails meet the criteria

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [February 15, 2025, 12:16pm UTC](https://community.glideapps.com/t/extract-imfomation-from-email/80071/4 "2025-02-15T12:16:38Z")

</div>

Okay.

So the email address you will be able to reference directly as part of the trigger payload.  
Assuming the rest of the information is in the email body, you should use a Text to JSON AI step with appropriate instructions to extract that information.

To match to a row in your Users table, use a Query step, targeting the Users table and matching the email from the trigger payload with the email in the users table.

If you need to update any columns in that row, use a Single Value step to take the first from the Query, then a Set Column Values operating through the Single Value.

---

<div class="post-metadata">

**Author:** ![Keith\_Chikumbirike](https://avatars.discourse-cdn.com/v4/letter/k/5daacb/32.png) [@Keith\_Chikumbirike](https://community.glideapps.com/u/Keith_Chikumbirike)\
**Post date:** [February 15, 2025, 12:50pm UTC](https://community.glideapps.com/t/extract-imfomation-from-email/80071/5 "2025-02-15T12:50:19Z")

</div>

Thank you