getGoogleSheetValueForResource v0.0.1

getGoogleSheet, it uses OAuth2 Waylay Channel. sheetId is the google sheet id. range is in format Sheet1!A1:D5

Specify resource you are interested in, which must be in the first column in your sheet. In the column field, select the entry you are interested in.

For instance

device,email,phone
abc,foo1@bar.io,+111111
cde,foo2@bar.io,+111111

And you are interested in email linked to the device abc, then your input arguments are:

  • resource is: abc
  • column is: email

Required properties:

  • sheetId
  • range
  • resource
  • column

States:

  • Found
  • Not Found

Raw data:

  • value (object[])