I have a scenario that is watching a google sheet, I only want it to read a row if a certain field is populated, how can I set this up? If the field is not populated then I want it to wait. The issue is that when I just watch row its picking up formulas and empty rows and then I can never go back and read that data. Hope that makes sense. Thank you!
1 Like
You need to setup a webhook that listens for any of the changes in the google sheet.
Hi @Katie_Delgado Welcome to the community!
If you want to use rows with certain data being filled in specific columns, instead use Search a row module with filter and later at the end of the workflow use update a row module to confirm that row has been processed. and use certain filters for the same column in search a row module to not list the processed row.
Other way is to use an Apps script to send data to make.com webhook.
I hope it helps!
Best,
@Prem_Patel