Perform bulk delele on google sheet

Hi , is there a way to perform bulk delete on google sheet ?

Currently you cannot. Feature request was made in this post.

Thanks, @jg80 adding the easter-egg-hunt tag for you :slightly_smiling_face:

@Niv Currently, we don't expose this option for security reasons. You may be able to do this by connecting to the Sheets rest api instead of using our integration, or you could loop through a list and trigger a single delete for each one

1 Like

Hey thanks for answering ,
How can I pass additionalScope param to google sheet query ?
I don't see the additionalScope option inside a google sheet resouce .As far as I understood I need to declare those params inside the resource and I cannot locate that option.

Hi @Niv,

Declaring them in the sheets query is not necessary. You'll just need to wrap the variable in double curlies {{}}. It will show as red/undefined, but this is because it will get defined when you run the Javascript query and pass in the variable

1 Like