Stores the value in two columns of the specified Google Sheets into a 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
  • E’: Strings * for specifying Cell range in the Data Item selected at config E

Service Output

  • The values in the areas D ‘and E’ in Sheet C ‘of Spreadsheet B’ are respectively stored in the Data Items
  • selected at config F and G
  • The communication logs are stored in the data item selected at config H

*Note

  • It is premise that the number of values in range D’ and E’ are the same, and there is no empty cell in the middle of the range
  • * Specify “A: A” for all cells in row A, “A2: A” for rows of the second and after, and “A1: A100” for rows 1 to 100 in column A (Reference: A1 notation)
  • ** https://docs.google.com/spreadsheets/d/1exampleEXAMPLEexampleEXAMPLEexampleEXAMPLE0/edit#gid=0

Workflow-Sample

2016-09-26 Episode 502: “Master Reference” is for Eliminating the Fluctuation!