Please enable JavaScript.

Coggle requires JavaScript to display documents.

Google Spreadsheet (start (missingID (%%sheet_id%, Share google…

- - - - sheetID
        
        Choose an action
        
        // Add new row
        
        Enter value for column A
        
        %%colA%
        
        %%colB%
        
        Enter value for column B
        
        %%colC%
        
        Enter value for column C
        
        ! %ret% = gsheet_append_values(sheet_id:%sheet_id%, range:'A1', values:[[%colA%, %colB%, %colC%]])
        
        Let's add a row into the spreadsheet. Provide values for 3 columns.
        
        // Continue
        
        !jump sheetID
        
        // Get row
        
        Specify row number
        
        %%rowNum%
        
        ! %values% = gsheet_get_values(sheet_id:%sheet_id%, range: %range%)
        
        Got values: %values[0][0]% | %values[0][1]% | %values[0][2]%
        
        !jump sheetID
        
        ! %range% = 'A'
        
        ! %range% .= ':C'
        
        ! %range% .= %rowNum%
        
        ! %range% .= %rowNum%
        
        // Delete row
        
        Specify row number
        
        %%rowNum%
        
        ! %range% = 'A'
        
        ! %range% .= %rowNum%
        
        ! %range% .= ':C'
        
        ! %range% .= %rowNum%
        
        ! %values% = gsheet_clear_values(sheet_id:%sheet_id%, range: %range%)
        
        !jump sheetID
        
        // Change or update row
        
        Specify row number
        
        %%rowNum%
        
        ! %range% = 'A'
        
        ! %range% .= %rowNum%
        
        ! %range% .= ':C'
        
        ! %range% .= %rowNum%
        
        Now provide values for 3 columns.
        
        Enter value for column A
        
        %%colA%
        
        Enter value for column B
        
        %%colB%
        
        Enter value for column C
        
        %%colC%
        
        ! %ret% = gsheet_update_values(sheet_id:%sheet_id%, range: %range%, values:[[%colA%, %colB%, %colC%]])
        
        Values got updated
        
        !jump sheetID
    - - !jump missingID