Icon

05_​Private_​Google_​Sheet-meets-Excel

Private 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 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 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? Excelsheet 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.Blog post available at https://www.knime.org/blog/GoogleSheet-meets-Excel ... yes, they blend! 2017 Restaurant Transactions Semi-automatic way to obtain an acces token through OAuth2.0 for a private Google Sheets document and to build a REST query 2016 Restaurant Transactions ACCESS PRIVATE DOCUMENT with Authorization Token or Refresh Token To visualize Private Accessto Google Sheetwith 2017 dataExchange authorization codefor access tokenInsert Authorization code / Refresh token, Client ID and Client secretextract access tokencalculate YTD valuesYTD Revenues2017 vs. 2016Monthly Revenues2017 vs. 2016calculate YTD valuesjoin aggregated2016 and 2017dataintroduce colors for monthly andYTD revenuescalculate revenuesfor each monthcalculate revenuesfor each monthextract DATE_TIME,TABLE and SUMcolumnsInsert Spreadsheet IDand Range of the datacells to extract2016 data GET Request POST Request POST Request Wizard JSON Processing Moving Aggregation Bar Chart(JavaScript) Bar Chart(JavaScript) Moving Aggregation Join + MissingValues Colors Total Sum by Month Total Sum by Month JSON Processing GET Request Wizard(Private Access) Excel Reader (XLS) Private 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? Excelsheet 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.Blog post available at https://www.knime.org/blog/GoogleSheet-meets-Excel ... yes, they blend! 2017 Restaurant Transactions Semi-automatic way to obtain an acces token through OAuth2.0 for a private Google Sheets document and to build a REST query 2016 Restaurant Transactions ACCESS PRIVATE DOCUMENT with Authorization Token or Refresh Token To visualize Private Accessto Google Sheetwith 2017 dataExchange authorization codefor access tokenInsert Authorization code / Refresh token, Client ID and Client secretextract access tokencalculate YTD valuesYTD Revenues2017 vs. 2016Monthly Revenues2017 vs. 2016calculate YTD valuesjoin aggregated2016 and 2017dataintroduce colors for monthly andYTD revenuescalculate revenuesfor each monthcalculate revenuesfor each monthextract DATE_TIME,TABLE and SUMcolumnsInsert Spreadsheet IDand Range of the datacells to extract2016 data GET Request POST Request POST Request Wizard JSON Processing Moving Aggregation Bar Chart(JavaScript) Bar Chart(JavaScript) Moving Aggregation Join + MissingValues Colors Total Sum by Month Total Sum by Month JSON Processing GET Request Wizard(Private Access) Excel Reader (XLS)

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: annamartin
Created at: 2017-04-08
On NodePit since: 2019-07-12
Last update: 2024-04-25
Created with KNIME version: v3.7.0
Tags: Google Google Sheet Excel Excel Sheet YTD REST REST service Excel

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!