Objective 1: I want to sum multiple rows of data (with filters applied) from Database 1 (DB 1), and put the totals of each property in a second database, Database 2 (DB 2). Example - 3 rows of data. 3 columns that are for Calls, DMs, and Sold. If they all say 4 each, then it should sum into DB 2 as 12 for each of them (3 rows * 4 value).

Objective 2: I want a count of pre-defined options from text-properties. Such as select, multi-select, date, person, etc. Example - 3 rows of data. 2 of them contain “Paid in Full” for an option. 1 of them contains “Month to Month”. The 1 row in the DB 2 would show 2 for Paid In Full property, and 1 for Month to Month property.

I have successfully done this in Make (gasp), but I cannot figure out how to do this in Zapier.

Any and all help would be greatly appreciated.

For additional context that may change the solution, sometimes there will be hundreds of rows of data, sometimes maybe just 5-10. This will be on a daily trigger/schedule.