Stores the sum of specified range of a Google Spreadsheets into a Numeric type data item, and stores its communication log in a String type data item.

Data Input

  • B’: Google Spreadsheet ID ** stored in the Data Item selected at config B
  • C’: Sheet 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 Spreadsheet 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
  • *** 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)
  • Comma removal version corresponds to the case where the decimal separator “,” is mixed

Leave a Reply

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