Please enable JavaScript.
Coggle requires JavaScript to display documents.
π Log users, INPUT %global.doc - id of Google Sheet table %sys.phone -β¦
π Log users
$SYS.GET
QUESTION
doc=%global.doc
range=Log!A:A
search=%sys.phone
ANSWER
%phone=0
%rowId=rowId
https://api.pipe.bot/docs/spreadsheets/read
else
$SYS.POST
QUESTION
value=%sys.phone|%sys.platform|%sys.regtime|%sys.uid|%sys.extuid|%sys.givenname|%sys.avatar
doc=%global.doc
range=Log!A1
ANSWER
%rowId
https://api.pipe.bot/docs/spreadsheets/insert
else
end
?rowId>0
#
ASYNC
?rowId>0
?sys.uid=40536124
Π²ΠΆΠ΅ Π² Π±Π°Π·Ρ %phone
%rowId
#
else
#
INPUT
%global.doc - id of Google Sheet table
%sys.phone - phone
sys: %sys.phone
ASYNC