Problem with Google Sheets and ChatGPT automation

Hi fellow Make community member

I want to create a workflow that from Google Spreadsheets input the data and ChatGPT module will generate all of it and recorded it back in the same file (in different sheets)

But

All work nice when i click Run Once

But turning this workflow ON

When I insert prompt / Topic i want, it would not generate anything and i need to manually push the RUN ONCE Button

How to make it automatically generate when i add new row?

Here info for my workflow:

blueprint.json (103.1 KB)

Welcome to the Make community!

You have set the “schedule” for your scenario to “On demand”. This is the same definition as “Only run when asked to do so”, either manually by clicking “Run Once”, or via the Make API.

This is because the module is a POLLING trigger, and not an INSTANT (Webhook) trigger.

You need to set an interval for your scenario’s schedule, as it won’t run by itself. This is covered by the Make Academy, which I highly suggest you do.

Screenshot_2024-07-29_140730

There are two main types of triggers, Polling (scheduled), and Instant (webhooks). Polling triggers can only run on a schedule. Instant triggers can be run as soon as data is received by the webhook.

Polling means Make checks external service for changes (pull changes to Make).
Webhook (instant) triggers means external service calls Make when there are new changes (push changes to Make).

The module you are using does not push changes — it’s basically a API request that Make has to occasionally “call” to fetch the latest changes/items.

To find out more on the different types of Trigger modules, see refer to Types of Modules and Webhooks sections of the Make help center.

Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —

General

Help Center Basics

Articles & Videos

samliewrequest private consultation

Join the Make Fans Discord server to chat with other makers!

if I run on interval lets said 5 min per cycle

And start to watch row 2, next cycle it will watch row 3 and so on or how?

Because each time i run for testing it go down (increase in row value) and if i set interval but have no input at that time it will be waste on token and cannot keep track what row make currently watch

See if Google Sheets has an “Instant” or “Webhook” trigger in Make.

Perhaps the “Watch Changes” module? However this requires additional setup. See the documentation for more details.

samliewrequest private consultation

Join the Make Fans Discord server to chat with other makers!