My scenario does the following:
- Brevo Events: Webhook that sends event information happened in Brevo (clicks, opened email, unsubscribed etc.)
- Add row: A new row is added in the Sheet “Brevo Events” in My Google Sheets file
- Search row: I pick the email address in Brevo Events and search the matching row in the sheet “Statistiken” (same file).
- Update row: Based on the event happened (i.e. a click), this will update the column “last action” from whatever it was to “click” and also the time and date of that update.
The error, as you can see, is that, for some reason and out of nowhere, it started to parse a range that makes no sense (‘Statistiken’!C2:C1000000).
You may say, “ok, add enough rows in sheets, and the problem won’t happen”. I tried, but Sheets has a limited number of cells of 1.000.000, meaning that multiplying 1.000.000 rows by X will always equal more than 1.000.000.
My questions are:
- Why does it unexpectedly parse such an odd number of rows, despite working fine in the past?
- Where does the range ‘Statistiken’!C2:C1000000 come from in the first place?
- How can I solve this problem?
Here some screenshots:
Scenario → history → Error
Scenario → history → Error (Module details)
Scenario → history → Success example (Module details)
blueprint_Brevo_to_sheets.json (69.6 KB)
To find this error better:
400: INVALID_ARGUMENT - Unable to parse range: ‘Statistiken’!C2:C1000000
Origin
Google Sheets
Incomplete execution
The data was saved in the queue of Incomplete Executions.