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)

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: