I have a game ( tab 1), in this game I have couple of people(tab 2) who can be interrested in.
I made a lookup column to find their phone number ( they are comma separated but in the same cell joine list column)
I would like to create in tab 3 (google sheet) a row per personne who match with the game to send a message per personne
I tried with glide X zapier X google sheet but it made just one row with all the phone num in one cell while i wanted A row per phone number.
Thanks a lot !
In my case I dont know if it will be ok .
As it’s a multiple user app, it will have more than 1 row called (each row have 1 cell with X items)
As you can seeI have a REF issue. “Mistake
The result has not been expanded, so as not to overwrite the data of C251.”
Many people use Make instead of Zapier, and I think you can set up Make to iterate through a comma delimited list or an array. I haven’t done it myself, but a few other people have. Or, you could create a google script that will read each row in your table and write a new row in a different table for each separate number in each row.