Stores the sum of specified range of a Google Sheet in a Numeric-type Data Item, and stores its communication log in a String-type Data Item. Comma removal version corresponds to the case where the decimal separator “,” is mixed
Data Input
- B’: Google Sheets ID ** stored in the Data Item selected at config B
- C’: Sheets Title stored in the Data Item selected at config C
- D’: Strings *** for specifying Cell range in the Data Item selected at config D
Service Output
- The sum of the cells of range D’ of the sheet C’ of Sheet B’ will be stored in the Data Item selected at E
- The communication logs are stored in the data item selected at F
*Note
- “+3.14”: 3.14, “314e-2”: 3.14, “090”: 90, “2016-12-23”: 2016, ‘Begin with letter’: 0 (parseFloat() sum)
- ** https://docs.google.com/spreadsheets/d/1exampleEXAMPLEexampleEXAMPLEexampleEXAMPLE0/edit#gid=0
- Spreadsheet ID: 1exampleEXAMPLEexampleEXAMPLEexampleEXAMPLE0
- *** Specify the sum of all cells of column A as “A:A”, the sum of the four cells of till the second row of column A and B as “A1:B2” (Reference: A1 notation)