Want to build connect between chat-ai and google sheets, but it fail with over-time

:bullseye: What is your goal?

want to build connect between chat-ai and google sheets, but it fail with over-time

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

want to build connect between chat-ai and google sheets, but it fail with over-time

:clipboard: Error messages or input/output bundles

over-time for connect

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

Hello, welcome to the community!

You used the Custom webhook module as a trigger module. It means that the scenario will run only when the webhook is triggered by a 3rd party= for example a web browser, another system, or an API call.

In simple terms, a webhook is just a unique URL generated by Make. When something sends a request to this URL (usually a POST request with data), it “wakes up” the scenario and passes that data into it.

If nothing is sending a request to that webhook URL, the scenario will not run on its own.

Lear more about triggers here: Types of modules - Help Center

Please take some time and check out Make Academy: https://academy.make.com/
It consists of a variety of courses that cover this issue, and completing the courses will give you the right base in order to start building complete scenarios.

This looks like a timeout in the Google Sheets Search Rows step, not a Chat AI issue.

Most likely the sheet is too large, or the module is searching too much data and takes too long to return a result.

I’d check these first:

  • use a smaller sheet or test tab

  • make sure you are searching by a specific column/value

  • reduce empty rows and unused data in the sheet

So the main issue is probably Google Sheets search taking too long, which is why the scenario stops.

It seems your connection with Google Sheets is failing because it’s taking too long, so it stops halfway. This usually happens when there’s too much data or the process is a bit slow. Try working with smaller data, keep things simple, and add a retry option, it should help fix the issue.