Hello everybody!
I was interested and I decided to deal with this issue, if you have any ideas, please share. It will be useful to all!
This script is very useful if you want to learn about your bets without going to Google the company table. Everything will be displayed In your table.
Sample Usage
=IMPORTRANGE("
https://docs.google.com/spreadsheets/d/abcd123abcd123", "sheet1!A1:C10")
this is key of spreadsheet: abcd123abcd123
range: "sheet1!A1:C10"
*Spreadsheets must be explicitly granted permission to pull data from other spreadsheets using IMPORTRANGE. The first time the destination sheet pulls data from a new source sheet, the user will be prompted to grant permission. Once access is granted, any editor on the destination spreadsheet can use IMPORTRANGE to pull from any part of the source spreadsheet. The access remains in effect until the user who granted access is removed from the source.
*If the data you are trying to import is too large, you may get an error.
