Google-Colab-combine-two-excel-wbks

Combine two excel workbooks

Dashboard

Description

Project consists of a simple Python script that will combine two excel workbooks into one, securely authenticated via google, and automatically output the file to google drive. The file inside Google Drive is linked to Google Data Studio and used to update a dashboard.

Languages and Utilities Used

• Python
• Google Colab
• Google Data Studio

Environments Used

• Windows 10 (21H2)

Program walk-through:

Google Colab secure sign on with Google account:

Google account approval needed:

New workbook created and uploaded to Google Drive:

Workbook created in Google Sheets:


Google Data Studio Dashboard consumes excel workbook and automatically updates: