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 | 2 | 252 | August 2, 2024 | |
| Watch Email - Export email data to Google spreadsheet? | 9 | 153 | May 17, 2025 | |
| Email Automation Repeatedly Sending + Google Apps Script Webhook Failure (Code 400) | 6 | 77 | May 19, 2025 | |
| Matching email addresses against a list in Google Sheet | 8 | 359 | August 27, 2024 | |
| My filter on Google Sheet is not working and I get duplicated tasks in make | 4 | 59 | February 10, 2025 |