Hi @Jason_Lin1,
This issue usually points to a misconfigured or incomplete setup in the initial module.
Please try the following steps to troubleshoot and resolve it:
Steps:
- Create NEW Scenario
- Add the “Google Sheets” → “Search Rows” module as the first step.
- Try reconnecting your Google Sheets account to ensure authorization is fully refreshed.
- In the module configuration:
- Enter the Spreadsheet ID (you can copy this from the URL of the Google Sheet).
- Select the correct Sheet Name.
- Enter Limit to 10 for checking purpose.
- Then SAVE the module configuration.
(See attached screenshot for reference)
- Right-click on the Google Sheets module and select “Run this module only” to test it in isolation.
(This helps confirm whether the module is able to fetch data and return a response properly.)
Let me know if you’d like further assistance.
If this resolves your issue, feel free to mark it as the solution to help others too!