Solving Google Sheets Webhook Search Issues on Make.com

Have you ever found yourself in a situation where you're trying to search for specific data in a Google Sheet using a webhook, but you're getting no output? You're not alone. This is a common issue that many Make.com users face, especially when they need to use filters in their search.

The Problem

Let's say you have a webhook as a trigger, and this webhook provides input data. Your first action is to search a Google Sheet for those exact data using the 'text equal to' filter. However, even though the exact data is present in the Google Sheet, you're still getting no output. This becomes a problem when your next step is to create a new row in a new Google Sheet, but since there's no output, no new row is being added.

The Solution

The solution to this problem is surprisingly simple. The issue arises because of a mismatch in the case of the text. For instance, in the Google Sheet, the word 'Residential' starts with a capital letter, while in the webhook, it's displayed as 'residential' in lowercase. This difference in case is enough to prevent the filter from finding the data.

To solve this, you can use the {{startcase()}} option in your filter. This will ensure that the case of the text in the webhook matches the case of the text in the Google Sheet, allowing the filter to find the data and return the correct output.

Troubleshooting Tips

If you're still facing issues, here are a few troubleshooting tips:

  • Check the case of the text in both the webhook and the Google Sheet. They need to match exactly for the filter to work.
  • Try removing the filters to see if that solves the issue. If it does, the problem lies with the filters.
  • Export the blueprint of your scenario and ask others for help. They might be able to spot something you missed.

Conclusion

In conclusion, when searching for data in a Google Sheet using a webhook, it's important to ensure that the case of the text matches in both the webhook and the Google Sheet. If it doesn't, the filter won't be able to find the data, and you'll get no output. By using the {{startcase()}} option in your filter, you can solve this problem and get the output you need.

You do have further questions?

Ask your question via E-Mail: Richard@make-app.de
Book a paid Support & Consulting Session
New Make.com user? Sign up through this Affiliate Link to receive 10.000 operations for FREE.