This node writes the input data table to a new Google Sheets spreadsheet.
If you want 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.
\n \t\t\n \n ","shortDescription":"This node writes the input data table to a new Google Sheets spreadsheet.","keywords":["Spreadsheet"],"deprecated":false,"streamable":false,"tags":["IO","Write"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABmJLR0QAAAAAAAD5Q7t/AAAACXBIWXMAAQOFAAEDhQGlVDz+AAAAB3RJTUUH4QgVDwseVNwtfgAABBtJREFUOBEBEATv+wEEmFD/AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEAAAAAAAAAAD7Z68AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAFmVEAAAAAAAIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABAAAAAAAAAAAAAAAAAWZUQAAAAAAAAAAAPtnrwAFmVEAAAAAAAAAAAAAAAAAAAAAAAAAAAD7Z68AAAAAAAAAAAACAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQAAAAAAAAAAAAAAAD7Z68AAAAAAAAAAAAAAAAA+2evAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEAAAAAAAAAAAAAAAABZlRAAAAAAAAAAAA+2evAAWZUQAAAAAAAAAAAAAAAAAAAAAAAAAAAPtnrwAAAAAAAAAAAAIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABAAAAAAAAAAAAAAAAPtnrwAAAAAAAAAAAAAAAAD7Z68AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABBJhQ/wAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAaVgbQ+WvbE4AAAAASUVORK5CYII=","views":[],"inPorts":[{"objectClass":"org.knime.google.api.sheets.data.GoogleSheetsConnectionPortObject","color":"16a965","dataType":"Google Sheets","optional":false,"name":"Google Sheets Connection","description":"A Google Sheets connection."},{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Buffered data table","description":"Table to be written to a google sheet"}],"outPorts":[],"dynInPorts":[],"dynOutPorts":[],"additionalSiteInformation":{"url":"https://update.knime.com/analytics-platform/5.12","trusted":true,"enabledByDefault":true,"name":"KNIME Analytics Platform 5.12 Update Site","version":"5.12.0"},"dialog":[{"fields":[{"name":"Spreadsheet name","description":"The name of the spreadsheet to be created.","optional":false},{"name":"Sheet name","description":"The name of the sheet to which the table should be written.","optional":false},{"name":"Add column header","description":"Here you determine whether the column names should be written in the first row.","optional":false},{"name":"Add row header","description":"Here you determine whether the row ID's should be written in the first column.","optional":false},{"name":"For missing values write","description":"By selecting this option, you can specify a string you want to substitute for missing values. If the option is left unchecked, the cells with missing values remain empty.","optional":false},{"name":"Write raw (do not parse numbers, dates, hyperlinks, etc.)","description":"Values are written into the spreadsheet as-is ("raw"), i.e. they will not be parsed. Uncheck the option, if values should be written into the spreadsheet as if they were entered via the Google Sheets website. If unchecked, numbers will stay as numbers, but other strings may be converted to numbers, dates, etc. following the same rules that are applied when entering text into a cell via the Google Sheets website. For example, strings like =hyperlink("example.com", "example") will be parsed to hyperlinks if this option is unchecked.","optional":false},{"name":"Open spreadsheet after execution","description":"Opens the spreadsheet after it has been written successfully. The spreadsheet will be opened in the systems's default browser.","optional":false},{"name":"Exclude/Include columns","description":"Select the columns that will be written to the sheet file. If the columns in the input table change, they will automatically be excluded.","optional":false}]}],"links":[],"kudos":[],"kudosCount":0,"bundleInformation":{"bundleVersion":"5.4.3.v202503031608","bundleName":"KNIME Google API Nodes","bundleSymbolicName":"org.knime.google.api","bundleVendor":"KNIME AG, Zurich, Switzerland","featureSymbolicName":"org.knime.features.google.api","featureName":"KNIME Google Connectors","featureVersion":"5.12.0.v202605041104","featureVendor":"KNIME AG, Zurich, Switzerland","extensionId":"*9KacbeCTeoRZrjhi"},"frequentSuccessors":[{"id":"*dClw0vmaM4zoM5sa","factoryName":"org.knime.google.api.sheets.nodes.sheetappender.GoogleSheetAppenderFactory","probability":0.2857142857142857},{"id":"*gJekgZlKJzBdxGF-","factoryName":"org.knime.base.node.meta.looper.variableloopend.VariableLoopEndNodeFactory","probability":0.2857142857142857},{"id":"*AApA5VHd41CVDe7u","factoryName":"org.knime.base.node.meta.looper.LoopEndNodeFactory","probability":0.14285714285714285},{"id":"*poHAFve1qUYVbcyD","factoryName":"org.knime.google.api.sheets.nodes.reader.GoogleSheetsReaderFactory","probability":0.14285714285714285},{"id":"*Y_8cAJatl5UQNkJy","factoryName":"org.knime.base.node.flowvariable.variabletotablerow2.VariableToTable2NodeFactory","probability":0.14285714285714285}]}