How can i create a list of names of any number of people and check for each name if it is present in the email notification?

Actually, I altered the above question to know the right thing to do.

Let me explain:

I wish to perform some operation based on the user input. If user input is x1, then say monkey, if the user input is x2 then say Elephant, if user input is x3 then say coffe etc.

Something like this ...

If I add each name of people (x1, x2, etc...) in blocks, it is impossible because the block size will grow huge. So, how can i store list of names in google sheet (if possible) and then check each name if that is the user input as well (For each userinput , that app may need to check all the names in google sheet to find if any name matches). And, if the name in the list and user input matches then perform certain specific operation based on that.

Can I do like this?

Parse all the names from google sheet and turn the names into paragraph. Then, when new user input is received, check if the user input word is present in the paragraph. If it is there, then perform some operation like play music or say elephant etc.

Search this board for Marathon for a sample app that keeps a sheet of users and their statistics.

Use the statistics to determine what to do with the users.

1 Like