Skip to main content
Question

How do I look up a name in a Google Spreadsheet and then return the value of a certain column?


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?

Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

5 replies

robschmidt
Forum|alt.badge.img+9
  • Zapier Expert
  • 617 replies
  • October 26, 2022

Hi @Faulkal 

Yes, this is totally doable, you just have to have a sheet with all discord username and their points.

  1. Trigger: Discord - new Channel message
  2. Action: Sheet - Find row using username
  3. Discord: create channel message

  • Author
  • New
  • 2 replies
  • October 26, 2022

awesome. though im having a little trouble with the sheet action. 

im not sure what needs to be filled in these different data points


  • Author
  • New
  • 2 replies
  • October 26, 2022

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? 


MohSwellam
Forum|alt.badge.img+8
  • Zapier Expert
  • 840 replies
  • October 26, 2022

Hi @Faulkal 

 

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 :) 


rachael.silvano
Forum|alt.badge.img+7

Hey there @Faulkal just checkin in that you were able to find a solution to finding a specific message for your trigger? Hope you were able to get to the finish line with your Zap, and looking forward to hearing from you!