# Gmail + airtable **URL:** \ **Category:** Questions\ **Tags:** airtable\ **Created:** [October 15, 2023, 3:30pm UTC](https://community.make.com/t/gmail-airtable/17636 "2023-10-15T15:30:03Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![Constance\_Gatbois](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/constance_gatbois/32/15838_2.png) [@Constance\_Gatbois](https://community.make.com/u/Constance_Gatbois)\ **Post date:** [October 15, 2023, 3:30pm UTC](https://community.make.com/t/gmail-airtable/17636/1 "2023-10-15T15:30:03Z")
Hi, I’ve connected Gmail + airtable with Make. Everything is working fine. I want to get a specific line from the email and put it in a specific column. It’s email from my bank account, so the content of the emails are the same. only the amount and the type are different. Any idea ? I have a class in the html =\>class=‘transaction-link’ but unfortunately both amount and type are in the same class. Many thanks, Constance ---
**Author:** ![Rafael\_Sanchez](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/rafael_sanchez/32/5425_2.png) [@Rafael\_Sanchez](https://community.make.com/u/Rafael_Sanchez)\ **Post date:** [October 15, 2023, 8:53pm UTC](https://community.make.com/t/gmail-airtable/17636/3 "2023-10-15T20:53:05Z")
Hello @Constance_Gatbois you could a Text Parse Module and a Regex to extract the amount from your email text body. It would be great if you could share a sample of your email and I could build the regex for you. In short, the regex would look like this : > Amount\s([A-Z]{2}$\s\d{1,3}(,\d{3})\*.\d{2}) ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/2/3/23114ada7b75101ff17596f09064fcd46dec3df1.png) ---
**Author:** ![CodexSolutions](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/codexsolutions/32/16574_2.png) [@CodexSolutions](https://community.make.com/u/CodexSolutions)\ **Post date:** [October 15, 2023, 11:28pm UTC](https://community.make.com/t/gmail-airtable/17636/4 "2023-10-15T23:28:43Z")
Hi @Constance_Gatbois f the string is always the same we can use split function to get the results as the format is always same you shared only amount and type are different but if you can share the insight of data it will be more clear to guide more accurately thank you ---
**Author:** ![Constance\_Gatbois](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/constance_gatbois/32/15838_2.png) [@Constance\_Gatbois](https://community.make.com/u/Constance_Gatbois)\ **Post date:** [October 16, 2023, 8:15am UTC](https://community.make.com/t/gmail-airtable/17636/5 "2023-10-16T08:15:26Z")
Hi Rafael, Thnak you for your help. Here is the email text body : `Vous venez d’effectuer un paiement de 24,00 USD ( **22,87** EUR) à destination de **Airtable** avec votre carte One (se terminant par xxxx). Vous pouvez retrouver dès maintenant cette transaction avec la mention en cours dans Qonto. Un paiement en cours, qu’est-ce que ça veut dire ? Une transaction est marquée comme en cours tant qu’elle n’a pas été autorisée ou annulée par le commerçant. Ce dernier dispose d’un délai de 11 jours pour effectuer une des deux actions. Il peut arriver qu’une transaction refusée apparaisse comme en cours dans votre interface. Soyez rassuré, les fonds vous seront automatiquement reversés après 11 jours.` What i want to get is the amount in euro (in bold) and the whom (in bold) in my example it’s airtable. And send the first one in column amount and the second in column Type. In my scenarion, i have several things from gmail. And what should i put in my 3rd module from parser ? Many thanks, Constance ![1](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/6/a/6a4bc8cc57c88ee0d67ff7b5e37741dea065ff01.jpeg) ![2](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/4/3/430a5ff497267133f1b2fde5a7da6ce89fc94c42.png) ---
**Author:** ![Rafael\_Sanchez](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/rafael_sanchez/32/5425_2.png) [@Rafael\_Sanchez](https://community.make.com/u/Rafael_Sanchez)\ **Post date:** [October 16, 2023, 12:09pm UTC](https://community.make.com/t/gmail-airtable/17636/7 "2023-10-16T12:09:04Z")
Hello @Constance_Gatbois use this Regex and you will get your result: ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/c/5/c5dc6998b76da93867fd31d659cc6e7e8a170465.png) ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/9/7/973fbd0b05541ae794326081abf9b9828a8b7556.png) ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/3/5/350dff7bc2c2a9144ca6e5c841839037f8fe3b2e.png) if this solves your request, please mark the question as solved for other users to find a solution if they have similar problem ---
**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\ **Post date:** [October 16, 2023, 1:37pm UTC](https://community.make.com/t/gmail-airtable/17636/8 "2023-10-16T13:37:19Z")
@Constance_Gatbois Use this pattern, although it is longer, it is less error-prone, won’t accidentally match incorrect values, and you will be able to map the variables in later modules: > ### `(?\d+(?:,\d+)?)\W*? EUR\)? à destination de \W*(?[\w\W]+?)\W* avec votre` The pattern above is exactly what you need. I have provided it in text form so that you can easily copy it into your scenario. You do NOT need to use “ **Global Match** ” for this. Global match is an incorrect solution in your case, since you will need to use an aggregator module after that. ![Screenshot_2023-10-16_211041](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/b/c/bcb6ca05cafb00f660bf39245e27c385ccacfa40.png) ---
**Author:** ![Rafael\_Sanchez](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/rafael_sanchez/32/5425_2.png) [@Rafael\_Sanchez](https://community.make.com/u/Rafael_Sanchez)\ **Post date:** [October 16, 2023, 2:27pm UTC](https://community.make.com/t/gmail-airtable/17636/9 "2023-10-16T14:27:37Z")
Thanks for this contribution @samliew Could you please provide some examples of the result? ---
**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\ **Post date:** [October 16, 2023, 2:32pm UTC](https://community.make.com/t/gmail-airtable/17636/10 "2023-10-16T14:32:23Z")
@Rafael_Sanchez sure, here is an example of the output ![Screenshot_2023-10-16_221040](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/3/b/3b60fdfc1b34eb4d8643a2ee0a5d4cd4bf1e931a.png) Hope this helps! Let me know if you have any questions. ---
**Author:** ![Constance\_Gatbois](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/constance_gatbois/32/15838_2.png) [@Constance\_Gatbois](https://community.make.com/u/Constance_Gatbois)\ **Post date:** [October 16, 2023, 2:38pm UTC](https://community.make.com/t/gmail-airtable/17636/11 "2023-10-16T14:38:01Z")
HI Samliew, Many thanks for this it’s not working for me. What module do you have before text parser ? In my case it’s Gmail module ![Capture d’écran 2023-10-16 à 16.36.35](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/6/1/613f8a641871e681ca165e60f1b9dc823453111d.jpeg) ---
**Author:** ![Constance\_Gatbois](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/constance_gatbois/32/15838_2.png) [@Constance\_Gatbois](https://community.make.com/u/Constance_Gatbois)\ **Post date:** [October 16, 2023, 2:39pm UTC](https://community.make.com/t/gmail-airtable/17636/12 "2023-10-16T14:39:30Z")
I’ve tried but i see that you have a text body in purple in the text field. What is the module you have put before ? I think the issue comes from there. I have gmail module before this text parser ![Capture d’écran 2023-10-16 à 16.36.35](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/6/1/613f8a641871e681ca165e60f1b9dc823453111d.jpeg) ---
**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\ **Post date:** [October 16, 2023, 3:05pm UTC](https://community.make.com/t/gmail-airtable/17636/13 "2023-10-16T15:05:59Z")
Hi @Constance_Gatbois the purple module is just a “Set Variable” module, to simulate your Gmail module, with the email text body you provided above. You just need to map the Text Content field like you have done in [your first screenshot](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/6/a/6a4bc8cc57c88ee0d67ff7b5e37741dea065ff01.jpeg). ---
**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\ **Post date:** [October 17, 2023, 2:09am UTC](https://community.make.com/t/gmail-airtable/17636/14 "2023-10-17T02:09:54Z")
Hello @Constance_Gatbois, were you able to successfully use the provided pattern? Let me know if it works or if you need further assistance. ---
**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\ **Post date:** [January 15, 2024, 3:12am UTC](https://community.make.com/t/gmail-airtable/17636/16 "2024-01-15T03:12:18Z")
This topic was automatically closed because it's resolved or inactive. Please, start a new topic.