Icon

Conexion_​Google_​Sheet

Public Google Sheet meets Excel Sheet.

Accounting Sheets for a Restaurant Business. In 2016 an Excel File was used. In 2017 a Google Sheet was used. Now we want to compare the monthly and YTD revenues for both years. Will Excel Sheets and Google Sheets blend? Excel sheet is accessed via an Excel Reader node; Google sheet via the new Google Sheets nodes available with KNIME Analytics Platform 3.5. This workflow demonstrates an example of access to both a public (no authorization required) or a private (OAuth2 authorization required) Google Sheet document. All you need is a Google account which has an access to the document. ... yes, they blend!

URL: Blog post at https://www.knime.org/blog/GoogleSheet-meets-Excel-part2

Taller 05 ETL Acceso a archivo de Google SheetCon este workflow me conecto a un archivo de hoja de cálculo de google.Modificado por: Marcial ReyesFuente: KNIME ExamplesActividad:1) Exportar a un archivo de EXCEL en su pc Public Access to Google Sheet with 2017 dataCreate connection toGoogle SheetsserviceConnect to Google Google SheetsReader Google SheetsConnector Google Authenticator(Deprecated) Taller 05 ETL Acceso a archivo de Google SheetCon este workflow me conecto a un archivo de hoja de cálculo de google.Modificado por: Marcial ReyesFuente: KNIME ExamplesActividad:1) Exportar a un archivo de EXCEL en su pc Public Access to Google Sheet with 2017 dataCreate connection toGoogle SheetsserviceConnect to GoogleGoogle SheetsReader Google SheetsConnector Google Authenticator(Deprecated)

Nodes

Extensions

Links