CSV Importer

✨ Problem Statement: Crafting a CSV Importer for Google Sheets ✨

Problem Statement: Make a CSV Importer for Google Sheets that lets users drag and drop CSV files onto the Google Sheet. The moment they drop the CSV file, allow them to select which columns to import 🗂️.

Tech Stack 🛠️

• Python 🐍

• Tkinter 🖥️

• gspread 📊

• pandas 🐼

• OAuth2 🔐

Workflow 🔄

1. Create or Use Existing Sheet 🗂️ Users have the option to either create a new Google Sheet or use an existing one for the data import. If they choose to create a new sheet, they will be prompted to provide a file name and an access email for sharing the sheet.

2. Import Data 📤 Once the user confirms their selections, then the user is asked to upload the csv file.If a new sheet was created, it will be shared with the specified email for collaborative access.

3. Upload CSV 📁 Users then have to click the "Upload CSV" button. This action prompts them to select a CSV file from their local system. The selected file will be used for further processing.

4. Select Columns ✅ After the CSV file is uploaded, users are presented with a list of columns from the file. They can then choose which columns they want to import into the Google Sheet. This step allows for customization and flexibility in data selection.

5. Close Application 🚀 After the import process is complete, users have the option to close the application using the "Close" button. This concludes the workflow.

This workflow ensures a user-friendly experience, guiding users through the necessary steps to import CSV data into Google Sheets. It offers flexibility in data selection, allows for both new and existing sheets, and provides clear instructions for a smooth process.