Write to a Google Drive folder using Worksheet Writer

[marenas]

Dear community,

Does anyone know how to configure the Worksheet Writer snap to write to a specific folder in Google Drive?

Thank you!

[marenas]

Hi!

I have a follow-up question. The other source file that I wanted to write from sftp to Google drive is generated daily and the filename has a date on it. How would you handle this scenario?

[dmiller]

If you know what format the date is in, you can use an expression to replicate it.

"Filename" + Date.now().toLocaleDateTimeString('{"format":"MMYYYY"}')

This should work if run on the same day. If you are running it a day later, you would need to add .minusDays(1)

[darshthakkar]

Thank you @dmiller and @smudassir for sharing the insights.
I wasn’t aware of worksheet writer before today, now I’ve been exposed to it.

Thanks a bunch for sharing this…