Hello Everyone ,
i would like to set up an automation starting with Aircall. I work for a call center, and every person who makes a call needs to tag it (e.g., “busy”, “wrong person”, etc.). My goal is to add all this information to a Google Sheet daily. Specifically, for each caller, I want a row in my Google Sheet showing their name and the count of “busy” calls in one column, “wrong person” calls in another, and so on.
So, my first module is "search calls" with Aircall to retrieve all calls for the day.
My second module is a router to filter by business developer's name.
The third is an array aggregator to reduce the number of operations, as we handle a large volume of calls daily.
The final module is the Google Sheets module to add a row. However, in each column, I'm using these functions:
{{sum(map(6.array.tags; if(6.array.tags.name = “”“Standard - Pas de réponse”“”; 1; 0)))}} but it’s not working. It consistently returns 0, even when there are calls with that specific tag.
I hope this is reasonably clear
and thank you for your assistance.