Hello there. Im trying to setup a trigger in my discord that is like /points or !points or something like that. What it will do is get the persons name that sent the trigger, look them up in a google sheets spreadsheet and then return a value of a certain column. am i able to do this?
How do I look up a name in a Google Spreadsheet and then return the value of a certain column?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
Userlevel 7
+9
- Certified Zapier Expert
- 617 replies
-
26 October 2022
Hi
Yes, this is totally doable, you just have to have a sheet with all discord username and their points.
- Trigger: Discord - new Channel message
- Action: Sheet - Find row using username
- Discord: create channel message
awesome. though im having a little trouble with the sheet action.
im not sure what needs to be filled in these different data points
I did some more testing and figured it out! My next question is (though i cant seem to find the answer) is there a way to trigger only on a specific message in a channel?
Userlevel 7
+8
- Certified Zapier Expert
- 803 replies
-
26 October 2022
Hi
In order to trigger for a specific message, you can add a filter after the trigger so it won't move forward if the message doesn't contain what you are looking for.
This will not consume any tasks :)
Userlevel 5
+7
- Zapier Staff
- 386 replies
-
28 October 2022
Hey there
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.