Please enable JavaScript.

Coggle requires JavaScript to display documents.

TestoviyBot (start (//Test (%jsonid=0 (%to=null (create ($SYS.GET (https…

- - - - $SYS.GET
        
        https://api.pipe.bot/docs/spreadsheets/read
        
        %input
        
        %replace=,
        
        replace /\n/ %input %replace
        
        %input
        
        1 more item...
        
        QUESTION
        
        doc=1HOe0UTDuMhIv-vjusU5wEu6qc_xaRoh0pmnQWAk0l2w
        
        range=Запити в один клік!A2:A
        
        ANSWER
        
        %input
  - - - %to=null
        
        create
        
        $SYS.GET
        
        https://sheets.googleapis.com/v4/spreadsheets/1HOe0UTDuMhIv-vjusU5wEu6qc_xaRoh0pmnQWAk0l2w/values/A2:D1000?key=AIzaSyAl7HTsBYMECtmxK80cFZJoS5tBYSZ5Pbo
        
        test
        
        iii
        
        4 more items...
        
        ANSWER
        
        %json
      - %ask=null
      - %toEmail=null
  - - - %search=1501
        
        $SYS.GET
        
        https://api.pipe.bot/docs/spreadsheets/read
        
        aaa
        
        %replace=,
        
        replace /\n/ %input %replace
        
        1 more item...
        
        QUESTION
        
        doc=19k025vi1kZ8fNl7RU5sEWiCfwuCTC3bsVwVtkz65hU4
        
        range=Унікальні!G1501:G5000
        
        ANSWER
        
        %input
  - - - $SYS.GET
        
        ANSWER
        
        %clockjson
        
        QUESTION
        
        https://api.clockify.me/api/v1/workspaces/5e5bacbb00352a1175bc92df/user/5e5bacbb00352a1175bc92de/time-entries
        
        iii
        
        %toEmail=$.values[%jsonid][2] %json
        
        %ask=$.values[%jsonid][3] %json
        
        $.values %json each(%item)
        
        next
        
        exit
        
        %to=$.values[%jsonid][1] %json
        
        X-Api-Key: XlzjgwA1KhF1vbmO