Google sheets write node

Hi All,

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

Thank you!
William Paiva

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.

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

Hi All,

Now it is possible.

1 Like

hi, please How?
thank you in advance

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

thank you Ivan, just done!

1 Like

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.