CODEWITHSUNDEEP
google-apps-script
MorningSleeper
MorningSleeper

Reputation: 415

Anyway to connect sheets by script?

According to the page on IMPORTRANGE, "In the new version of Google Sheets, spreadsheets must be explicitly granted permission to pull data from other spreadsheets using IMPORTRANGE.". I'm using apps script to automatically create sheets based on a template that contains a cell with IMPORTRANGE so do I have to manually go into each newly created sheet after it is created in the script to approve the connection between each sheet or is there a way to do this in apps script after it is created? Both sheets are owned by me but I guess this requirement to connect the sheets is not related to ownership.

Upvotes: 1

Views: 441

Answers (1)

Zig Mandel
Zig Mandel

Reputation: 19834

there is no way to connect them programmatically using importrange, you must manually connect them using the sheets interface. alternatively, you could use scripts and timers directly to make it behave like importRange.

Upvotes: 1

Related Questions