Google Sheets - "Choose where to start" using API?

Questions
, ,
1

Hello everyone,

I want to pull data from Google Sheets, I’ve always used Watch New Rows because it increments the row number after each Run. I have a lot of different scenarios that rely on the same process. I sometimes need to change the row number of one or more scenarios but I have to do that manually and it takes time. I am looking for a way to do it over API.

I am using Make APIs to create a dashboard (HTML + JS) to control my scenarios as I have a lot, and so far I managed to integrate everything I need except the option to choose what Row to start with.

I am using Google Sheets Watch New Rows as trigger. I only need to pull data for a row and move to the next one after each execution.
I tried to replace it with a custom API call, I am able to pull data from a specific row but I can’t move to the next row for the next execution. I tried to use a data store with it but still unable to increment row number.

Thanks in advance to anyone who can help.

Here is an example of my scenario:

Screenshot 2025-09-29 120129
Screenshot 2025-09-29 1201291680×800 104 KB

I tried these without success:

{
  "eventName": "module_start_selected",
  "payload": {
    "organization_id": XXXXXXX,
    "team_id": XXXXXXX,
    "user_id": XXXXXXX,
    "scenario_id": XXXXXXX,
    "app_name": "google-sheets",
    "module_name": "watchRows",
    "value": {
      "epoch": {
        "id": 45 (the row number I entered)
      }
    },
    "default_value": false,
    "test": "A"
  }
}

I tried to replicate it but never worked.

  • I tried to update a scenario with a PATCH Request (documentation) by loading the current blueprint, changing “tableFirstRow”: “AXX:ZXX” (XX= the row number I want), sending the new blueprint to the scenario.

API communication is successful, scenario gets updated but when running the scenario, it continues to the previous set row and doesn’t use the one I want.

1 Like