tinyDB to spreadsheet

Discuss
1

“https://script.google.com/macros/s/AKfycbxhqO80ohNW2nvxyKCa2NoLsr_oUyQevnAcFRyVcFhk29pyiXNhrlkl1ZYiZFxlUCqn2g/exec?ID=1_r0EJYi_GpvP-1An_O3TGmJu2H1NLW4VSJhu_2d9u9c&SH=Test&FN=writeRange&DATA=[[“1”,“2”,“3”,“4”],[“1”,“2”,“3”,“4”],[“1”,“2”,“3”,“4”],[“1”,“2”,“3”,“4”],[“1”,“2”,“3”,“4”],[“1”,“2”,“3”,“4”],[“1”,“2”,“3”,“4”],[“1”,“2”,“3”,“4”],[“1”,“2”,“3”,“4”],[“1”,“2”,“3”,“4”]”

can help me for this url, i want make it on block, but for variable &DATA something error for my block, i want make output tinyDB like script that variable &DATA

2

[[“1”,“2”,“3”,“4”],[“1”,“2”,“3”,“4”],[“1”,“2”,“3”,“4”],[“1”,“2”,“3”,“4”],[“1”,“2”,“3”,“4”],[“1”,“2”,“3”,“4”],[“1”,“2”,“3”,“4”],[“1”,“2”,“3”,“4”],[“1”,“2”,“3”,“4”],[“1”,“2”,“3”,“4”]]
Try this

3

You are using writeRange which requires the range auch as A1:D10 as per your code

You may try appendRow instead of writeRange which doeanot require any REF meanwhile share your script file to find any error in vode

4

ohh, how if we want make send data from tinyDB to spreadsheet ?, can you tell me the block code
thanks

5

Already many topics are there in community and solved this work in muti direction and this is one method

How to sync tinydb data to google sheets? - #3 by Still-learning Understand?

6

oke thanks, i will see this

7

image
image712×186 10.1 KB

why like this ?
sorry this error i have fix it, but when sync data, respone " something wrong "

8

image
image723×529 42.1 KB

my scrip line this

9

Shiw the blocks,

Because you are trying to select the item which is not in Yailist

Show us your blocks

No issue with the script code