Skip to content

[BUG] Columns above "Z" are not returned in change set on Instant Update #8511

@bsommardahl

Description

@bsommardahl

Describe the bug
When I receive sheet updates with a wide sheet (larger than A to Z), then the "AA" column is included with an invalid cell designator and the remaining columns are not returned at all.

To Reproduce
Steps to reproduce the behavior:

  1. Add a "Google Sheets > New Updates (Instant)" source.
  2. Trigger a change in a sheet that has more than 26 columns.
  3. Inspect {{steps.trigger.event.changes}} and observe the cell property. The change for column "Z:2" is correctly formatted, but the next column appears as "[:2" (where "2" is the row number). Also, the other columns AB through A? are not returned at all.

Expected behavior
Changes in columns to the right of Z should report as "AA:2", "AB:2" and so on (where "2" is the row number).

Screenshots
https://share.zight.com/4guRnrl5

Metadata

Metadata

Assignees

Labels

bugSomething isn't workingtriagedFor maintainers: This issue has been triaged by a Pipedream employee

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions