Private Google Sheet-meets-Excel

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 a REST Google API. The Google Sheet can be public (no authorization required) or private (OAuth2 authorization required). This workflow demonstrates an example of an access to a private document.

Private Google Sheet-meets-Excel

 

Resources

EXAMPLES Server: 01_Data_Access/05_REST_Web_Services/05_Private_Google_Sheet-meets-Excel01_Data_Access/05_REST_Web_Services/05_Private_Google_Sheet-meets-Excel*
Download a zip-archive

References:

 

 


* Find more about the Examples Server here.
The link will open the workflow directly in KNIME Analytics Platform (requirements: Windows; KNIME Analytics Platform must be installed with the Installer version 3.2.0 or higher). In other cases, please use the link to a zip-archive or open the provided path manually