Google sheets Connection --> Can I choose a Folder?

[MartinaMuellner]

Hi,

I am trying to run an output into google sheets for a stakeholder. That stakeholder has a specific folder I need to run the google sheet into. Excel doesn’t work, I got too many rows so excel won’t open correctly.

Any idea ? Please help !!

[ScottF]

Hi @MartinaMuellner and welcome to the forum -

Can you upload your workflow showing what you’ve tried so far?

Have you taken a look at KNIME Hub for Google Sheets examples? Here’s one you might try:

Deploy Data by Exporting Data files from KNIME – knime

[MartinaMuellner]

I touched base with somebody in my company. I am not able to upload a workflow - sorry !

but the workaround that we found is to create an empty test google sheets and use the appender node instead to be able to pinpoint it to a folder on my google drive. HOWEVER, there is a constraint that it has to be my own google drive instead of a shared drive for the google sheets connection = not the google drive connector. I did manipulate the sql for the datapull and reduced the data amount significantly so i was able to write an excel into google drive using the connector and therefore, was able to use the shared folder directory.