How to fill out a spreadsheet if you don't have a record in the google spreadsheet

Questions
1

Hello, I’m trying to fill in a line of the google spreadsheet through the data captured by the webhooks, that is, if the webhooks sends “name, email and phone”, I need to search the spreadsheet if it already has this registration and if it has the registration, it does not need to execute nothing, but if you don’t have this data in the worksheet, I need to fill in a new line in the worksheet with this data.

my problem is that when I try to search the data in the worksheet and it does not have it, I cannot continue to fill in the worksheet.

Screenshot_2
Screenshot_21217×487 34 KB

3

Hi @Caio_Santos, welcome to the community!

I am sorry to hear you’re having trouble, though I am not quite sure I fully understand. Are you expecting your execution to continue with the “false” branch instead of the “true” branch like in your screenshot?

If so, can you share the JSON data you are sending to your IF node and also share the IF node itself so I can get an idea of what’s happening?

4

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.