Hub
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
Sign in
  • KNIME Hub
  • knime
  • Spaces
  • Finance, Accounting, and Audit
  • Aggregate Google and Excel Sheets for Accounting
WorkflowWorkflow

Aggregate Google and Excel Sheets for Accounting

Excel YTD Google Sheets accounting

Last edited: 

Drag Workflow
Workflow preview
This workflow blends accounting sheets for a restaurant business from an Excel file and from a Google Sheet. Excel sheet is accessed via an Excel Reader node; Google Sheet via the Google Sheets nodes. Before accessing the Google Sheet, a new Google sheet is created on your personal Google account and populated with a subset of the restaurant data.

External resources

  • A Recipe for Delicious Data – Part 2: The new Google Sheets Nodes
  • Blueprints for Finance Analysis

Used extensions & nodes

Created with KNIME Analytics Platform version 4.3.1
  • KNIME Base nodes Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.3.1

  • KNIME Excel Support Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.3.1

  • KNIME Google Connectors Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.3.0

  • KNIME JavaScript Views Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.3.0

  • KNIME Timeseries nodes Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.3.0

Legal

By downloading the workflow, you agree to our terms and conditions.

License (CC-BY-4.0)
Discussion
Discussions are currently not available, please try again later.

KNIME
Open for Innovation

KNIME AG
Hardturmstrasse 66
8005 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • E-Learning course
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • KNIME Open Source Story
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more on KNIME Server
© 2021 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits