how to input a lot of data at once into google spreadsheet. I want to input a lot of student data. Or maybe input all at once to airtable
example :
name1,class1,gender1 (row 1)
name2,class2,gender2 (row 2)
name3,class3,gender3 (row 3)
input all at once
Can someone help me with this?
In script code try appendRows
function
1 Like
try this code… credit to @TimAi2
ref : METRIC RAT AI2 - Google Sheets for AppInventor
finally web url must be set like this ,
Your_Script url?ID=Sheet_ID&SH=Sheet_Name&FN=writeRange&REF=Enter_The_Cell_Ref&DATA=[[data should goes here]]
This script code will write numerous data into ghseet at once
1 Like
thank you very much, i will try it
https://script.google.com/macros/s/AKfycbweSaCWSeyoslavNSsYv4mm4AZyZ5BiKZYtWSQ1Xo-bIJYG0u-nT51Z9ZZzCuuxsZKL/exec?ID=1czQhoW3UmadeVf1AwzCzSoNDaWAKx4Wcca-3yhPLZRI&SH=Sheet1&FN=writeRange&REF=A4:D10&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"]]
testing url
Check Here before and after running the above url in new tab
By changing the ref cells try to test , how fast it is ading the bulk data in gsheet
2 Likes
Evening only i will getinto pc. Meanwhile if anyother responds please use it
system
(system)
Closed
10
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.