Answer webhooks(custom webhook)
→google sheets(search rows)
connection(bandit1397@gmail.com)
search method(select from my drive)
spreadsheet name(1EEsd2nzWRlD9F41ipwn9fTYEsqJJlTgNZy3PDAxtKno)
sheet name(시트1)
table contains headers(yes)
column range(A-BZ)
filter(A Equal to 1. requestID and B Equal to 1. hospital and E Does not exist)
Order by(blank)
sort order(descending)
Limit(1)
→google sheets(update a row)
connection(bandit1397@gmail.com)
search method(select from all)
spreadsheet ID(1EEsd2nzWRlD9F41ipwn9fTYEsqJJlTgNZy3PDAxtKno)
sheet name(시트1)
row number(6. row number)
table contains headers(yes)
use column headers as IDs of the columns(yes)
values in columns(requestID A: 6. arequestID(A), hospital(B): 6.hospital(B), summary(C): 6.summary(C), eta(D):6.eta(D), response(E): 1.response, time(F):6.time(D)
request webhook(custom webhook)
→iterator
flow control
array(1. hospitsls[])
→rowter
Gmail
connection(bandit1397@gmail.com)
to(4.email)
subject(1.summary)
body type(raw html)
content(응급환자 수용 요청입니다 아래 버튼을 눌러 응답해 주세요)
Google sheets
connection(bandit1397@gmail.com)
search methon(select from all)
spreadsheet ID(1EEsd2nzWRlD9F41ipwn9fTYEsqJJlTgNZy3PDAxtKno)
sheet name(시트1)
table contains headers(yes)
use colums headers as IDs of the columns(no)
values in columns(A: 1.requestID), B:4.name, C:1.summary, D:1.eta, E:blank, F:now)
