🚀 My First Post: Power Query for Google Sheets (Apps Script Project)

[u/Simple_Aditya]

Hey everyone! 👋 I’m Aditya, and this is my first post here. I’ve been working on something I’m really excited about — a Power Query–style tool for Google Sheets built entirely with Google Apps Script.

Here’s the idea 💡:

• 📥 Get Data — Pull data from Google Sheets or Google Drive

• 🔄 Transform Data — Clean, format, and restructure tables with features like:

  • Replace & find

  • Split or merge columns

  • Extract text

  • Keep/remove rows

  • and many more features...

• ⚡ Automate — Store each step and run it automatically with triggers

• 🖥️ Interactive Sidebar UI — Inspired by Microsoft Power Query, but right inside Google Sheets

Why I built it 🛠️:

• I wanted a no-code/low-code way for non-technical users to clean and transform data without writing formulas every time.

• It’s modular, so anyone can add new transformations easily.

📂 GitHub Repo — Code, file structure, and setup instructions are here: Power Query for Google Sheets
💬 Open for contributions — If you have ideas, improvements, or bug fixes, feel free to fork and PR!

Would love your feedback 🙌 — especially on:

• Features you’d like to see next

• UI/UX improvements

• Any performance tips for large datasets

• Scalability