Skip to main content

Is it possible to read the name of a file in google drive and extract characters and then perform an action with this?

In programming it would be something like: if extract(name,startcharacter, endcharacter)="value" then do this…

 

What I want to do is that when the name of a file starts with 3 characters, a new row is added in google sheets

Hi @heckennedy 

Good question.

OPTIONS

  1. Formatter > Text > Split: https://zapier.com/apps/formatter/help
  2. Code: https://zapier.com/apps/code/help

Then add a Filter step: https://zapier.com/apps/filter/help


Hey there, @heckennedy! I wanted to pop in and see if you were able to get this up and running with @Troy Tessalone’s recommendations?

Keep us posted! 🤗