Google Sheets "Search Rows" returns 0 bundles despite correct keyword match (Instagram Automation)

Questions
, ,
1

:bullseye: What is your goal?

Hi everyone,

I’m building an Instagram Automation in Make.com. My goal is to have the bot watch for a comment (e.g., “kurti22”), search a Google Sheet for that keyword in Column A, and return the price from Column B.

:thinking: What is the problem & what have you tried?

The Problem:
My Google Sheets “Search Rows” module is returning Total number of bundles: 0, even though the keyword exists in the sheet. Because it returns 0, my AI module is hallucinating prices instead of using my data.

My Current Setup:

Module: Google Sheets (Search Rows)

Filter: keyword/post ID (Column A) Contains (case-insensitive) Text (from Instagram module).

Sheet Structure: The keyword “kurti22” is in Column A, Row 2 (directly under headers).

Headers: “Table contains headers” is set to Yes.

What I’ve Tried:

Confirmed there are no hidden spaces in the Google Sheet cell.

Tested with “Matches Pattern (case-insensitive)” - still 0 bundles.

Re-selected the Spreadsheet and Sheet Name to refresh the connection.

Confirmed Column A is the very first column.execution history is showing 0 bundles. Any idea why the handshake is failing?

:clipboard: Error messages or input/output bundles

execution history showing 0 bundles.

:camera_with_flash: Screenshots (scenario flow, module settings, errors)

Filter.png
Filter.png2262×1464 279 KB

3

Hey there,

what are the possible values that can come in in the 1.text variable? Also what does the sheet contain?

4

Hello @Kavs ,

When using the Text operator “Contains (case insensitive)“

What you want to do is in the textbox reference (the on on top) to have bigger amount of text. For example the title of this post “Google Sheets Search Rows return 0 bundles despite correct key“

And the box below should have a word that is part of the box above, for example:
-returns
-0 bundles
-search rows

In that cases the module will give you the rows that have that word.

What I think is happening in your case is that the instagram “text“ is much bigger or longer than what you have in that Google Sheets cell.

But in order to help you better, you can share with us screenshots of what is inside of instagram “text“, and what information has the google sheets that you think it whould match. if you prefer a loom video can also be very helpful.