How to input a lot of data at once into a spreadsheet

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

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.