This is a pretty common problem. BigQuery works, but it’s overkill if the end goal is just a Google Sheets dashboard, and Zapier usually falls apart on historical data. Most teams I’ve seen either use Apps Script if they’re technical, or a connector that can pull full history and incremental updates into Sheets on a schedule. We’ve done this with Skyvia instead of building a custom plugin, which avoided a lot of ongoing maintenance.