Filter question: Only add a GDocs sheet if needed

[smake]

Hello,

my quesiton is similar to this one, but the answer here is missing.

I have a web hook which receives the name of a sheet name which should be created in a Google spreadsheet.

Before that, I need to check whether the sheet already exists.
What I did:

List the sheets

This returns multiple bundles.

Aggregate the bundles

Filter before adding the sheet

---

Executing the webhook:

branch = name of the sheet to create:

(The array aggregation shows that there is already a sheet with that name)

I expect the filter to block the creation of the sheet.
But instead, the filter passes and I get an error that there is already a sheet with that name (which is true…)

---

Question: what is wrong with the filter?

Thanks a lot - regards,
Simon

[samliew]

You might not even need a List Sheets module.

Just directly add to your sheet name, and if an error occurs, create a new sheet and add the row to your new sheet.

I have this in a live scenario:

samliew – request private consultation

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

[smake]

Thanks Sam,

this looks interesting - I like the way you are handling the error and react on it!

In my case, it’s indeed only the creation of the sheet which I need when I push a certain branch to github. This calls the webhook with the branch name as argument in the JSON payload.

I am just wondering, where do I have the error in the filter? (see the screenshot)

Thanks a lot!
Regards,
Simon

[smake]

Problem solved.
I overlooked that the key in the output is not Title, but title.
Thanks anyway for your help!
/Simon

[vendy]

Hey @smake

Thanks a lot for sharing additional info about your problem and the solution!

Keep up the good work