What are you trying to achieve?
Subject: Google Sheets > Search Rows Returns 0 Bundles Despite Correct Data - Help Needed
Body:
Hello Make.com Community,
I am building an automated content publisher and have run into a stubborn issue that I can’t seem to solve. My scenario is supposed to search a Google Sheet for image URLs based on a category, but the Search Rows module is always returning 0 results, even when I can see the data is correct in the sheet.
Here is my exact workflow:
Trigger (Google Sheets > Search Rows): Finds a “Queued” row in my Pipeline sheet. (This works).
AI (Google AI > Generate Content): Generates copy and a category (e.g., “KITCHEN”). (This works).
Parse JSON: Processes the AI output correctly. The output for category is confirmed to be “KITCHEN”.
The Problem Module (Google Sheets > Search Rows):
It is configured to search a separate tab in my sheet called Image Library.
It is supposed to find all rows where the Category column is equal to the “KITCHEN” value from the Parse JSON module.
The Output of this module consistently shows “Total number of bundles: 0.”
What I have already confirmed:
My Image Library sheet has 142 rows.
The Category column is plain text (not data validation chips).
The Image_URL column is plain text (not hyperlinks).
The data in the Category column is in all uppercase (e.g., “KITCHEN”), which perfectly matches the output from the AI module.
I have tried using a case-insensitive filter (lower(Category) equals lower(data.category)) and it still returns 0 results.
I have reauthorized my Google Sheets connection multiple times.
Because this search is failing, the next module (HTTP > Get a file) fails with a “Missing URL” error.
It seems like there is an invisible issue preventing the Search Rows module from correctly reading my Image Library sheet. Can anyone see what I might be missing?
Here is the blueprint of my scenario for you to inspect.
Steps taken so far
Check the blue print. PLEASE SOMEONE HELP.
