Did you try reading all the rows and aggregating the results? Something like this post, but with Google sheets rows, instead of emails:
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Email Automation: Data parsing into Sheets | 2 | 247 | August 2, 2024 | |
| Watch Email - Export email data to Google spreadsheet? | 9 | 132 | May 17, 2025 | |
| Email Automation Repeatedly Sending + Google Apps Script Webhook Failure (Code 400) | 6 | 71 | May 19, 2025 | |
| Matching email addresses against a list in Google Sheet | 8 | 343 | August 27, 2024 | |
| My filter on Google Sheet is not working and I get duplicated tasks in make | 4 | 56 | February 10, 2025 |