Best answer

How to look up a record in a database?

  • 28 January 2023
  • 1 reply
  • 161 views

I want to look up a record in a database and then send that data to a webhook.  

Here is the flow.

1.  A Zapier webhook will receive a post of just an email address.  
2.  The zap needs to look for that record in a database.  The database will contain the email record and additional data like name, address, etc...  I was going to use Googlesheets to keep it simple but there is probably a better solution. I am open to suggestions snce Googlesheets has a max on 5m cells.  The database may exceed that.  If that is the case, could the zap search Googlesheets 1, if email not found go to Googlesheets 2...?
3.  Once the zap finds the email and the corresponding data in the database row in the database it should send all the data, email, name, address, phone, etc.. to another webhook.  

How can I build a zap for this?

What is a better database to use than Googlesheets?

icon

Best answer by Troy Tessalone 28 January 2023, 23:40

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +14

Hi @Jordan555 

Good question.

Check out the database apps with Zap app integrations: https://zapier.com/apps/categories/databases

Make sure to do research about which will work with your record volume.

 

Zap Steps

  1. Trigger: Webhook - Catch Hook
  2. Action: [app] - [event]
  3. Trigger: Webhook - POST Request