Howdy friends,

I’ve encountered a roadblock I’m getting pretty stuck on, and would love your help. My goal is to create a chat where job seekers and employers can create profiles, and then see profiles of the other. (e.g a worker sets up a profile, and then can view profiles that have been set up by employers).

So far I am able to populate a spreadsheet with user data, and can call some of that data when requested. However I haven’t been able to create a message with multiple users.

To better explain it with an example, below I have some screenshots. What I want to do in this example is send an employer a message that shows all the workers which have submitted a profile. (In my first screenshot) you can see my message setup, (in the second screenshot) you can see the example data I’m trying to extract in from the spreadsheet, and (in the third screenshot) you can see what the message result looks like. Note that in the message that gets sent, the name, experience, location, availability, pay rate, and contact, all have the same answer.

I know I need to be segmenting between rows on the spreadsheet, to segment between users, but I do not know how to do that. Please help. Thanks in advance!

Isaac

P.s. As well, I should note that perhaps there is a function other than sending a message that would be more effective? (i.e. perhaps an action or automation?) I am still really learning this tool, so forgive me for not knowing much, I will need to have a very clear answer to my questions with steps I can follow. Thank you so much!