I have a scenario whose goal is to retrieve information from a form (to which I do not have access) to insert them in a Google Sheet. I have access to the content of the information entered in the form thanks to the mail generated by it. With a Text Parser module, I can extract the necessary information from the mail thanks to the regular expression below. My problem is the following: the Google Sheet module “Add a row” generates a new row for each data instead of filling a single row with all the data.
Thanks for your help.
Nom :\s*(?<Nom>.*)|Prénom :\s*(?<Prenom>.*)|Activité professionnelle :\s*(?<Activiteprofessionnelle>.*)|N° ADELI :\s*(?<ADELI>.*)|Email :\s*(?<Email>.*)|Téléphone :\s*(?<Telephone>.*)|Adresse :\s*(?<Adresse>.*)|Code Postal :\s*(?<CodePostal>.*)|Ville :\s*(?<Ville>.*)|Mode de paiement :\s*(?<ModeDePaiement>.*)
After several tests, I have understood that the problem was in fact due to the regular expression. I have modified it so that the text parser only outputs one bundle and so the mapping with the Google sheet fields works without the need of an aggregator module.