Hello.
I’m a beginner, so appologize if I ask this question.
I try to make a very simple automation : exctact email adresse from google sheet in my drive, and put in the “to:” box in email toolkit. BUT impossible to do that. I tryed ith agregattor, with AI agent to reformat email, with Multiples Variables… There is no way to do that. Email oks perfectly when I write the adress, but not with a link. It drives me fkg crazy… I read many topic but I can get the answer.
In my exemple I only read One Cell to simplify, but email are in variable range.
Could you help me ho to do that ? Many thanks
Hello,
Welcome to the community!
Your Google Sheet has multiple addresses packed into one cell – that’s the issue. The Gmail module expects either a single email or an array.
The simplest fix is the split function:
There’s a catch though.
Since you’re using ; as the separator, Make will automatically convert it into a token in the mapping panel, so your formula will look like this:
And it won’t work.
What you can do: copy that mapping and paste it anywhere outside Make – even into a browser tab:
Wrap the semicolon in quotes – ";" – to escape it:
Then paste it back into your scenario.
There is also 2nd solution using iterator+aggregator or creating array in Google Sheets but that’s the quickest one.
Let us know if that solves it.
Have a nice day,
Michal
Hi mszymkowiak !
Thanks for the solution. It seems that it doesn’t work :
More information: I use a Google Sheet Tool “get range value” in order to pick all the emails adresses on the C column (two adresses in C2 and one in C3). That is the final target. But for my exemple, I picked only range “C2”, one cell with two emails adresses. So, in your code, I don’t realy understand what is the “1.sheetsCell”, so I use the output “C”.
But my final setup is range :
I’ve tried with two methods : text agregator and array agregator. The method with Text Agreg returns me the good field (in my opinion) with two adresses mails seperate by “;”. Impossible with Array Agreg. But both doens’t work with gmail if I put the right output. It’s very difficul to understand this.
Any solution ?
Still nobodies to help me ?
Hey Pierrot,
Michal explained it pretty well, you are using the wrong split formula. And in the very next screenshot where you are explaining that it doesn’t work again, you are again using the wrong split formula. This is what it should look like:
{{split(36.C; ";")}}
Hello.
Thanks @Stoyan_Vatov many thanks for your response… but really… it doesn’t works.
Michal told me to copy paste this :
And when I do so, I get this :
But it doesn’t works. So I wrote exatly what he wrote in his picture :
With the second ; with comma, so “;”. And it doesn’t works…
You tell me to rewrite {{split(36.C; “;”)}}, so I have this with simple copy-paste :
And it still doesn’t work 
: only 1 adress mail is used by gmail tool (since the almost the begining…) :
So, I’m very sorry to insist, and maybe something are wrong in my worlfow, but the code that you both told me send an email only in one adress, so, it doesn’t works.
In fact, with Range Value toolkit, when I set range “C:C” with header, I have an error message ; but if I put “C2:C50”, email is sent to only 1 adress.
++
Can you copy/paste the list here?
Ok I have made some test and I provide a line with two mails in one raw (which is perfectly the wrong sheet). In fact, if I only use this cell, {{split(36.C; “;”)}} works, it is ok. So, ok my bad.
But as I wrote “In my exemple I only read One Cell to simplify, but email are in variable range.” In fact this was not the final sheet that I built, so for simplify all, what can I do with this : a list of email, with “;” already in cell, in a same column with header ? I thinks this time I need an agregator.
Many thanks.
Hello,
I opened a new topic for that. Thanks to all.
What is your goal?
Hello.
My goal is to extract somme email frome a google sheet column and send an email to all.
What is the problem & what have you tried?
I’have tried to use agregator to extract all the email (think that works), but when I use the output in the To: box (with array or key) I have an error. I try to use map() in another test but with the wrong way it seems
Screenshots (scenario flow, module settings, errors)
You are mapping the first item from the array in the To field, not an array of emails. Also the items themselves are not just email addresses, they are all followed by space and ; at the end, so they wont work. You need to cleanup your data.
Thanks for the response.
I couldn’t use Array aggregator as well, but with the aggregator I can put all the mails on one output :
But still not find the good formula for the To : box il email. I thinks it’s a get or map but I dont find
++
Can you share the input here so we can check and see what the correct formula should be or how to best rework it so it can be mapped in the To field?
I deliver to you the complete workflow for you to point the error.
1- I use a google sheet with mail in column C :
2- Then, I use a Search Row for extract only cell with mail adresses :
3- After that, a Text Agregator for isolate all the mail adress in one bundle :
4- Pick the output in the mail box To: … but it is this point that doens’t work. I use map function in another test but badly for sure.
Hope you’ will find a solution.
And we already answered this issue in the original thread you created, your split function is wrong.
