Please enable JavaScript.

Coggle requires JavaScript to display documents.

Variable Commands - Coggle Diagram

- - - - Yes
      - %pattern=/(\w+)_(\d+)/
      - %sheet=$1
      - %line=$2
      - %sheetName=/get https://api.pipe.bot/calc expr=preg_replace('%pattern','%sheet','%sys.lastMessage')
        
        Sheet name: %sheetName
    - - WORD
    - - $SYS.GET
        
        QUESTION
        
        doc=%sheetId
        
        range=common!A1:B20
        
        ANSWER
        
        %questions
        
        https://api.pipe.bot/docs/spreadsheets/read
        
        %questions[0]
    - - $SYS.GET
        
        https://sheets.googleapis.com/v4/spreadsheets/1dWEuiCcvCLlU8h5Gnxe1H6kunVQG7JpVSXF-1rGuDpg/values/commonOld!A1:Z2
        
        %error=$.error %questions
        
        %values=$.values %questions
        
        %message=Про что вы хотите узнать?
        
        %columnNumber=0
        
        1 more item...
        
        ?error
        
        Ошибка: %error
        
        %error=null
        
        ANSWER
        
        %questions
        
        Authorization: Bearer %googleToken
        
        QUESTION
        
        majorDimension=COLUMNS