Google Sheets Data Import Automation

My goal is to turn a manual Google Sheet into a fully self-updating workspace. The sheet must pull fresh data automatically and place it in the correct tabs without my intervention.

The data sources in scope are:
• REST/JSON APIs
• Web pages that need light scraping
• A small internal SQL/MySQL database

Whether you prefer Google Apps Script, AppSheet, or a hybrid approach, the final build should remain lightweight and easy for non-technical teammates to adjust.

Key expectations
1. Time- or event-driven triggers that fetch, parse, and write data into designated ranges.
2. Well-commented code plus a concise setup guide so I can change endpoints or column mappings later.
3. Basic error handling with email or on-sheet alerts whenever a source is unreachable.
4. A brief demo (live or recorded) showing the solution running end-to-end.

When you reply, let me know how you would handle each source type (API, scraping, database), which libraries or connectors you’d use (UrlFetchApp, Cheerio, JDBC, etc.), and your estimated timeline. I’m ready to get this sheet working for us instead of the other way around.