Sending part of an email to a Google Sheets

Bonjour,

Je vois beaucoup de personnes qui réussissent à lier gmail avec google sheets pour envoyer des mails à partir d’un gsheets, j’aimerai faire l’inverse.

Je recois des mails de commandes qui ont toujours la même structure :

  • Age: 21
  • Prénom: xxxx
  • Genre: Homme
  • Mail: mail@mail.fr
  • Temps : 60
  • **Nbr : ** 2
  • ** temps d’exercice :** 15
  • Equipements : Materiel
  • Obj: oui
  • Groupe : Tous |

et j’aimerais envoyer les réponses dans différentes cases sur un gsheet, quelqu’un aurait-il la réponse svp ? :blush:

Hello there @zac_advert :wave:

I just wanted to let you know that I translated your question into English since that’s the official language of the community. By keeping the content in one language, we give everybody the chance to step in and help you. Note: Please read our Code of conduct and get familiar with the rules and guidelines that apply here in our community. This way we keep the community organized and neat for everybody.

Thank you very much

Hello,
I see many people succeeding in linking Gmail with Google Sheets to send emails from a Google Sheet, but I would like to do the opposite.
I receive order emails that always have the same structure:

  • Age: 21
  • First Name: xxxx
  • Gender: Male
  • Email: mail@mail.fr
  • Time: 60
  • Quantity: 2
  • Exercise time : 15
  • Equipment : Equipment
  • Obj: yes
  • Group: All |

And I would like to send the responses to different cells on a Google Sheet. Could someone please help me with this? :smiling_face:

2 Likes

Welcome to the Make community!

When reaching out for assistance with your regex pattern for a Text Parser module, it would be super helpful if you could share the actual text you’re trying to match. Screenshots of text can be a bit tricky, so if you could copy and paste the text directly here, that would be awesome! It ensures we can run it against test patterns effectively. If there’s any sensitive info, feel free to change it to something fictional yet still valid by keeping the format intact.

Providing clear text examples saves time on both ends and helps us give you the best possible solution. Without proper examples, we might end up playing a guessing game, and nobody wants that as it is a waste of time! You are more likely to get a correct answer faster.

When pasting text into this forum, you must also format the example text using the rich-text editor, otherwise the forum software might modify the displayed text, and you might get incorrect answers from others because of it.

A. Type code fence manually
Either add three backticks ``` before and after the text, like this:

```
content goes here
```

B. Highlight and click the format button
Or use the format code button in the editor:
Screenshot_2023-10-02_191027

samliewrequest private consultation

Join the Make unofficial Discord server!

2 Likes

Hello,

Je suis dans la même situation, si tu as une réponse, je suis preneur. Bien évidement, si je trouve de mon côté, je t’en ferai part.

Bonne soirée à tous.

Welcome to the Make community!

While it’s tempting to continue an existing thread, a more effective approach would be to start a new topic. It helps other community users to respond to your query, and keeps our space organised for everyone. If you start a new conversation you are also more likely to get help from other users. You can refer others back to a related topic by including that link in your question. Thank you for understanding and keeping our community neat and tidy.

The “New Topic” link can be found in the top-right of the header:
Screenshot_2023-12-19_091207

samliewrequest private consultation

Join the unofficial Make Discord server to chat with other makers!

2 Likes