Доработать интеграцию asana.com и google sheet

В гугл таблицу выгружается массив в json

Его нужно записать в ячейки таблицы, разделив события.

дата события | название задачи | id задачи | имя ответственного

Нам нужно события при перемещении карточки и изменении ответственного, а также на отдельную страницу изменение даты дедлайна.

дата события | название задачи | дедлайн | имя ответственного

Событие изменение статуса задачи:

{"data":[{

"user":{"gid":"1150701873267203","resource_type":"user","name":"Irina"},

"created_at":"2019-11-28T05:08:20.184Z",

"type":"task",

"action":"added",

"resource":{"gid":"1150778230638022","resource_type":"task","name":"test 3","resource_subtype":"default_task"},

"parent":{"gid":"1150704132093786","resource_type":"section","name":"Done"}},

{"user":{"gid":"1150701873267203","resource_type":"user","name":"Irina"},

"created_at":"2019-11-28T05:08:20.186Z",

"type":"task",

"action":"removed",

"resource":{"gid":"1150778230638022","resource_type":"task","name":"test 3","resource_subtype":"default_task"},

"parent":{"gid":"1150704132093785","resource_type":"section","name":"In Progress"}},

{"user":{"gid":"1150701873267203","resource_type":"user","name":"Irina"},

"created_at":"2019-11-28T05:08:20.318Z",

"type":"story",

"action":"added",

"resource":{

"gid":"1151622275317239",

"resource_type":"story",

"created_at":"2019-11-28T05:08:20.193Z",

"created_by":{

"gid":"1150701873267203",

"resource_type":"user",

"name":"Irina"},

"type":"system",

"text":"moved this Task from In Progress to Done"},

"parent":{"gid":"1150778230638022","resource_type":"task","name":"test 3","resource_subtype":"default_task"}}],

"sync":"be6c1028f50c93683eeb75160c7d430b:0"}

Событие изменение даты:

{"data":[{"user":{"gid":"1151704075864797","resource_type":"user","name":"Boris"},"created_at":"2019-11-28T17:27:40.440Z","type":"task","action":"changed","resource":{"gid":"1150950395807720","resource_type":"task","name":"Задача отв Борис","resource_subtype":"default_task"},"parent":null},{"user":{"gid":"1151704075864797","resource_type":"user","name":"Boris"},"created_at":"2019-11-28T17:27:40.398Z","type":"story","action":"removed","resource":{"gid":"1151708987827798","resource_type":"story","created_at":"2019-11-28T17:19:24.769Z","created_by":{"gid":"1151704075864797","resource_type":"user","name":"Boris"},"type":"system","text":"changed the due date to December 31"},"parent":{"gid":"1150950395807720","resource_type":"task","name":"Задача отв Борис","resource_subtype":"default_task"}},

{"user":{

"gid":"1151704075864797","resource_type":"user","name":"Boris"

},

"created_at":"2019-11-28T17:27:40.461Z",

"type":"story",

"action":"added",

"resource":{

"gid":"1151709612917845",

"resource_type":"story",

"created_at":"2019-11-28T17:27:40.285Z",

"created_by":{

"gid":"1151704075864797",

"resource_type":"user",

"name":"Boris"

},

"type":"system",

"text":"changed the due date to December 30"

},

"parent":{"gid":"1150950395807720","resource_type":"task","name":"Задача отв Борис","resource_subtype":"default_task"}}

],"sync":"58d1fa77357a1efe5260759050c0705b:0"}

Событие изменение дедлайна:

{"data":[

{"user":{"gid":"1150701873267203","resource_type":"user","name":"Irina"},"created_at":"2019-12-03T12:18:07.286Z","type":"task","action":"changed","resource":{"gid":"1150778230638022","resource_type":"task","name":"Задача 2","resource_subtype":"default_task"},"parent":null},

{"user":{"gid":"1150701873267203","resource_type":"user","name":"Irina"},"created_at":"2019-12-03T12:18:07.260Z","type":"story","action":"removed","resource":{"gid":"1152193366135963","resource_type":"story","created_at":"2019-12-03T12:16:51.030Z","created_by":{"gid":"1150701873267203","resource_type":"user","name":"Irina"},"type":"system","text":"changed the due date to January 8"},"parent":{"gid":"1150778230638022","resource_type":"task","name":"Задача 2","resource_subtype":"default_task"}},

{"user":{"gid":"1150701873267203","resource_type":"user","name":"Irina"},"created_at":"2019-12-03T12:18:07.290Z","type":"story","action":"added","resource":{"gid":"1152193366135964","resource_type":"story","created_at":"2019-12-03T12:18:07.175Z","created_by":{"gid":"1150701873267203","resource_type":"user","name":"Irina"},"type":"system","text":"changed the due date to January 13"},"parent":{"gid":"1150778230638022","resource_type":"task","name":"Задача 2","resource_subtype":"default_task"}}

],"sync":"d00077bce158b1fa6a9f6a66feff18ff:0"}