Something like import from csv or simply copy and paste will be tremendously helpful. I know they are working on it but I hope they are Really working on it!
If the number of rows you want to import equals the number of times you are willing to click once per row (1000 rows = 1000 clicks) …
@Manu.n 's solution:
At least, in the meantime, a copy …Google sheets…paste…glide table
@elysium27 If you want to copy over a larger portion of data from Google Sheets then take a look on this thread where a robot is used