Google sheets write node

KNIME Analytics Platform
#1

Hi All,

Is it possible write in a specifically folder on google drive using the google sheets write node?

Thank you!
William Paiva

#2

Hi @wpaiva

Using the Google Sheet Writer node, at the moment, this is not possible. It is creating a new Sheet as if you would do it in the browser by pressing on the “New Sheet” button.

#3

Hi There was an update on this topic? Now is it possible to write workflow results into a file on google sheets?

#4

Hi All,

Now it is possible.

1 Like
#5

hi, please How?
thank you in advance

#6

Hi MIke!

  • To write data data table from KNIME to a new Google Sheets spreadsheet use Google Sheet Write node.
  • To overwrite or append data to an existing sheet, you cannot use the Google Sheets Writer node; you must use the Google Sheets Updater node.
  • Additionally there is also Google Sheet Appender node which you can check out.

Br,
Ivan

4 Likes
#7

thank you Ivan, just done!

1 Like
#8

Hola a todos.
Una pregunta al respecto. Si se quiere escribir el fichero en una carpeta compartida del google drive ÂżcĂłmo se hace? Solamente logro crearlas en el raiz del drive. No encuentro esa opciĂłn en los nuevos nodos.
Muchas gracias.