Creating a scenario that will delete the addresses stored in column B from all Google Chat spaces

Questions
1

:bullseye: What is your goal?

Nice to meet you.

I’d like to create a scenario that will delete the addresses stored in column B from all Google Chat spaces if the string “example” is contained in column A of Google Sheets.

No matter how many times I try, it never works, so I’d appreciate some advice.

:thinking: What is the problem & what have you tried?

I’ve tried the Google Chat module, HTTP Make a API call, etc.

3

Hey there,

Sorry could you clarify - you are looking to delete whatever is in column B, if column A contains the string example? And these are in the same Google sheet?