Icon

Aggregate Google and Excel Sheets for Accounting

Aggregate Google and Excel Sheets for Accounting
2016 Restaurant Transactions ($100 and more) 2016 Restaurant Transactions (less than $100) We use an Excel Reader node and the Google Sheets nodes to access the data stored respectively in Excel and Google Sheet format.You are supposed to provide Google authentication and write data to your private Google Sheet. Visualization Note! The reference blog posts uses the WTD Data 2017 Public datasetthat was previously available as a public Google Sheet. Since this datasetis not provided any more, we changed the workflow to first write a subset ofthe 2016 data into a private Google Sheet and then access the data fromthere. Consequently, the comparison between years 2016 and 2107changed to comparison between large and small restaurant bills in 2016. calculate YTD valuescalculate revenuesfor each monthYTD Revenueslarge vs. smallMonthly Revenueslarge vs. smalljoin aggregatedlarge and small billsconvert string DATE_TIME to date/time cellsintroduce colors for monthly andYTD revenuescalculate revenuesfor each monthcalculate YTD valuesCreate connection toGoogle SheetsserviceConnect to Googlewrite RestaurantData2016readRestaurantData2016>=100< 1002016 data Moving Aggregation Total Sum by Month Bar Chart Bar Chart Join + MissingValues String to Date&Time Colors Total Sum by Month Moving Aggregation Google SheetsConnection GoogleAuthentication Google SheetsWriter Google SheetsReader Row Filter Row Filter Excel Reader 2016 Restaurant Transactions ($100 and more) 2016 Restaurant Transactions (less than $100) We use an Excel Reader node and the Google Sheets nodes to access the data stored respectively in Excel and Google Sheet format.You are supposed to provide Google authentication and write data to your private Google Sheet. Visualization Note! The reference blog posts uses the WTD Data 2017 Public datasetthat was previously available as a public Google Sheet. Since this datasetis not provided any more, we changed the workflow to first write a subset ofthe 2016 data into a private Google Sheet and then access the data fromthere. Consequently, the comparison between years 2016 and 2107changed to comparison between large and small restaurant bills in 2016. calculate YTD valuescalculate revenuesfor each monthYTD Revenueslarge vs. smallMonthly Revenueslarge vs. smalljoin aggregatedlarge and small billsconvert string DATE_TIME to date/time cellsintroduce colors for monthly andYTD revenuescalculate revenuesfor each monthcalculate YTD valuesCreate connection toGoogle SheetsserviceConnect to Googlewrite RestaurantData2016readRestaurantData2016>=100< 1002016 data Moving Aggregation Total Sum by Month Bar Chart Bar Chart Join + MissingValues String to Date&Time Colors Total Sum by Month Moving Aggregation Google SheetsConnection GoogleAuthentication Google SheetsWriter Google SheetsReader Row Filter Row Filter Excel Reader

Nodes

Extensions

Links