# Automatisation Aircall

**URL:** <https://community.make.com/t/automatisation-aircall/56056>\
**Category:** Questions\
**Tags:** get-map-function, arrays, functions\
**Created:** [September 25, 2024, 1:21pm UTC](https://community.make.com/t/automatisation-aircall/56056 "2024-09-25T13:21:32Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Celia\_HEINRICH](https://avatars.discourse-cdn.com/v4/letter/c/d6d6ee/32.png) [@Celia\_HEINRICH](https://community.make.com/u/Celia_HEINRICH)\
**Post date:** [September 25, 2024, 1:21pm UTC](https://community.make.com/t/automatisation-aircall/56056/1 "2024-09-25T13:21:32Z")

</div>

Hello Everyone ,

i would like to do an automatisation start with aircall as starting point. Well i’m working for a call center and every poeple who call someone has to tag the call (“busy”, wrong person", “…”). What i need to do is add all informations per day in a google sheet. So for each caller i would like to add a row in ma google with the name of the personn and the number of “busy” in a column, the number of “wrong person” in a column, etc…  
So my first module is “search calls” with aricall to have all the calls of the day  
my second module is a router to filter by business developper’s name  
the third one is a array agregator to reduce the number of operations, bc we have a lot of calls per day  
the last one is the moduel google sheet to add a row. But in every column i had this functions :  
{{sum(map(6.array.tags; if(6.array.tags.name = “”“Standard - Pas de réponse”“”; 1; 0)))}} but doesn’t work, it always retunr 0 even if i have som calls with this tag.

 ![Capture d'écran 2024-09-25 114015](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/e/b/ebb56131b40429358178fb7dc7788ed68119d9ea.png)  
 ![Capture d'écran 2024-09-25 114045](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/3/f/3feebe2209efc99407b9404fa6cc55137fa194e7.png)

I hope is approximatively clear 🙂 and thank you for your help

---

<div class="post-metadata">

**Author:** ![Celia\_HEINRICH](https://avatars.discourse-cdn.com/v4/letter/c/d6d6ee/32.png) [@Celia\_HEINRICH](https://community.make.com/u/Celia_HEINRICH)\
**Post date:** [September 25, 2024, 2:11pm UTC](https://community.make.com/t/automatisation-aircall/56056/2 "2024-09-25T14:11:19Z")

</div>

I tried another formula which doesn’t seem to work either because my function always returns 0 and not the sum of calls with the tag in question.

 ![Capture d'écran 2024-09-25 160722](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/2/0/202557a82cab836f4a78ff6df86a788d110f9c29.png)

---

<div class="post-metadata">

**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\
**Post date:** [December 24, 2024, 3:25pm UTC](https://community.make.com/t/automatisation-aircall/56056/3 "2024-12-24T15:25:25Z")

</div>