0 ×

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

Workflow

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.
Google Google Sheet Excel Excel Sheet YTD REST REST service 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? 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)

Download

Get this workflow from the following link: Download

Resources

Nodes

05_​Private_​Google_​Sheet-meets-Excel consists of the following 65 nodes(s):

Plugins

05_​Private_​Google_​Sheet-meets-Excel contains nodes provided by the following 8 plugin(s):