Use case: get data point X from Make module, search Google Sheets column A for value X, return value of column B in same row into Make.
What is the best way to replicate the functionality of Xlookup in Make with Google Sheets?
Example use case: I want to send a Discord message (or a tagged post) to a handle that corresponds to a user ID in another app, say Trello, when something is assigned to that user. Make needs to know which Discord handle goes with which user ID in the task management app. Is there some way besides using a Google Sheets module that I can create that “lookup table” within Make, say a data store or set variable situation of some kind? Anyone have an elegant way to do it? Thanks in advance.