Why am I Getting an Error when Inserting a Filename from Dropbox into Google Sheets' First Column?

Bugs
1

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

I’m getting an error in the first column (filename) on google sheet insert of a file name read from dropbox. The filename is “+447511370000 on 2024-01-15 at 13.02.m4a”. I’m guessing the automation is not escaping special characters “+ and space”, but it’s just a guess. Any ideas?

Screen Shot 2024-01-16 at 14.37.10.png
Screen Shot 2024-01-16 at 14.37.10.png1217×514 45.8 KB

2

Hi , yes, thats’s possible. Since everything inside the double braces is essentially JavaScript, you can apply string methods to steps.trigger.event.name to remove the + and spaces, would that work for you?

3

Hello Pardon but it’s user error. PipeDream is inserting the text correctly, but google sheets is interpreting the + as a formula and resulting in an error. I will be quoting the text in PipeDream to avoid this in the future.