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!

[dmiller]

Not at this time. You would have to create a blank file in the location you want it, then select it from the dropdown in the Snap to write to that file.

[marenas]

Thank you for the reply.

Actually, the requirement is we have CSV files in a file share and we wanted to ‘send/write’ these to Google Drive. My initial thought is to use File Reader > Mapper > Worksheet Writer (to a specific folder where I can manage the security). Since this feature in the Worksheet Writer snap is not yet available - how would you like to configure the pipeline for this case? What other snap can I use for this purpose?

[smudassir · Accepted solution]

You can create a blank spreadsheet in the target google driver folder. And provide this new spreadsheet’s name in your pipeline’s Worksheet writer snap. Provide a valid worksheet name as well. Then you are all good. You can have a pipeline with File Reader + CSV Parser + Worksheet Writer.

[marenas]

smudassir:

d provide this ne

Thank you! This works for me.