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?
Best answer by Troy Tessalone
View original
