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

[Nikola_Sagala]

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?

[Still-learning (GSR)]

In script code try appendRows function

Write multiple rows of data to Google Sheets using Apps Script

[Still-learning (GSR)]

@Nikola_Sagala

example :
name1,class1,gender1 (row 1)
name2,class2,gender2 (row 2)
name3,class3,gender3 (row 3)
input all at once

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

[Nikola_Sagala]

thank you very much, i will try it

[Still-learning (GSR)]

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

[Still-learning (GSR)]

Evening only i will getinto pc. Meanwhile if anyother responds please use it