I have a sheet with two columan, looks something like that:
user_name | email
A | firstname.lastname@example.org
B | B@email.com
C | email@example.com
I need to use the sheet as a lookup table i.e if a is in the input then I need to fetch firstname.lastname@example.org.
The thing is that there might be more than one inputs A, B should fetch email@example.com, firstname.lastname@example.org.
Tried various option to accomplish that. The best guess was using “Find Many Spreadsheet Rows (With Line Item Support) in Google Sheet”, but that didn’t end up finding anything. The input for the “Find Many Spreadsheet Rows” step is a comma-delimited text - user_name,another_user_name.
Can you please help me as to how can I accomplish that?
*using the zapier lookup table is not relevant as I need that table to be dynamic.
Best answer by Troy TessaloneView original