Back to All

Searching for a value from google sheet and then displaying a value from another column in chatbot using Zapier

Hello,

I followed the tutorial of how to insert data into google sheet using Zapier and it works.

Right now, I made 2 columns called Name and Progress in google sheet.
I would like the user to type his name and then using Zapier to search for the name and then return the progress of that name.

In Zapier I have 2 steps, Catch Hook and Find or Create Row in Google Sheets. Also, I think I should add another step that sends back the progress that corresponds to that name. However, I don't know which one or how to do it.

In Snatchbot, I would like to know how to receive data from Zapier and display it to the user.

Please don't link working with user responses article because I couldn't find what I want there. Also, I don't want to use Snatchbot Automation right now, except if Zapier isn't able to do this.