Did you try reading all the rows and aggregating the results? Something like this post, but with Google sheets rows, instead of emails:
damato
3
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Email Automation: Data parsing into Sheets | 1 | 263 | May 4, 2024 | |
| Watch Email - Export email data to Google spreadsheet? | 8 | 187 | February 16, 2025 | |
| Email Automation Repeatedly Sending + Google Apps Script Webhook Failure (Code 400) | 5 | 104 | May 2, 2025 | |
| Matching email addresses against a list in Google Sheet | 7 | 390 | August 13, 2024 | |
| My filter on Google Sheet is not working and I get duplicated tasks in make | 3 | 71 | January 26, 2025 |