Please enable JavaScript.
Coggle requires JavaScript to display documents.
Copy integration, 🍉 Spreadsheet integration, - Coggle Diagram
Copy integration
🍉 Spreadsheet integration
start
// Update record
%update=updated value
%rowId=1
$SYS.POST
QUESTION
doc=1IkUINIHZX7zauXKSjvcUPYdJepZtKmo8b4gCDx_8224
range=B%rowId
value=%update
https://api.pipe.bot/docs/spreadsheets/update
else
Something went wrong
?result=1
Row successfuly updated
ANSWER
%result
//Create Record
%text=new record
$SYS.POST
https://api.pipe.bot/docs/spreadsheets/insert
?rowId>0
...Record added with row id %rowId
else
...Something went wrong and we can not create record
QUESTION
doc=1IkUINIHZX7zauXKSjvcUPYdJepZtKmo8b4gCDx_8224
range=SheetName!A1
value=%sys.uid|%text
ANSWER
%rowId
//Search record
%search=search value
$SYS.GET
https://api.pipe.bot/docs/spreadsheets/read
?rowId>0
...RowId:%rowId
...Search result: %value1, %value2
else
...We can not find any record
QUESTION
range=A:A
search=%search
doc=1IkUINIHZX7zauXKSjvcUPYdJepZtKmo8b4gCDx_8224
ANSWER
%rowId=rowId
%value2=2
%value1=1
// Delete record
%rowId=99
$SYS.POST
https://api.pipe.bot/docs/spreadsheets/delete
?result=1
Row successfuly deleted
else
Can not delete row
ANSWER
%result
QUESTION
listId=13516098
rowId=%rowId
doc=1IkUINIHZX7zauXKSjvcUPYdJepZtKmo8b4gCDx_8224
// Async operation
$SYS.POST
https://api.pipe.bot/docs/spreadsheets/insert
...Operation added to queue, going forward
QUESTION
doc=1xcdCL0SINaxV62-VBoIX4E5oTO22uqILmzjoe6PNszM
value=%sys.uid|%text
range=SheetName!A1
ASYNC
//Reading Spreadsheet
$SYS.GET
ANSWER
%result
QUESTION
doc=1IkUINIHZX7zauXKSjvcUPYdJepZtKmo8b4gCDx_8224
range=Sheet1!A1:B1
https://api.pipe.bot/docs/spreadsheets/read
...%result
...Read results
Spreadsheet maps
examples 🍉