Why is the "Worksheet Id" custom expression not working in Google Sheets "Update Multiple Rows" action?

Bugs
1

This topic was automatically generated from Slack. You can find the original thread here.

[ Google Sheets - Custom Expression “Worksheet Id” ]
Hey! Today I’ve clicked the “Update” button in my “Update Multiple Rows” action in an older workflow and it starting having problems with a previously handled problem…

The context is in this GitHub Issue: [BUG] Resource not found with dynamically created google spreadsheet · Issue #12301 · PipedreamHQ/pipedream · GitHub

Now, the workaround of label is not working anymore, but no other custom expression is working for this property.

EDIT: Solution found, it’s in the thread :white_check_mark:

I’ll add some images in the thread :arrow_heading_down:

2

In (1), it shows that I tried adding a hard-coded Worksheet Id

In (2), the error. It shows that my worksheet is undefined:

  • please don’t mind the A1 notation error after the !, that’s just my logic

In (3), it’s the details, showing that Worksheet Id does have a value

In (4) I’m showing the current version, at 0.1.7

e-1.png

e-2.png

e-4.png

e-3.png

3

Here it is with a correct A1 notation

Captura de Tela 2024-10-28 às 14.15.25.png

4

I’ve tried using different keys, but none of them work

{
"label": "worksheetAbc",
"title": "worksheetAbc",
"sheetId": "worksheetAbc"
}
5

It seems to also break this function for the headers, because of the other red alert box about undefined!1:1

6

Well… I just figured it out… :sweat:

It’s because it’s not the worksheet TITLE (it’s title in the bottom tabs), but it’s ID (the one in the url, like, gid=12345)

I suppose that using worksheet name is not supported anymore?

7

Hi Icaro, taking a look at this now - will get back to you shortly

8

Icaro, can you try updating the action and trying again? We just pushed a fix for the header issue.

9

Hey Michael!

Before your latest fixes, I already was able to understand my confusion and fix the action

My custom expression needed to reference the worksheet ID and not it’s title

I didn’t find any header problems :thinking_face:

10

Okay, glad to hear that you are all set!

I thought you were running into header issues based on

It seems to also break this function for the headers, because of the other red alert box about undefined!1:1

11

I think this was a collateral of my other issue :sweat_smile: and not the main problem on its own :slightly_smiling_face: