I want the user to be able to open a seperate google sheet to the main one used for the app. They can then fill in the columns on a tab that holds outlets/customers. They can then “import” that data by using an “add new row to another table using values from this row” action.
They will not be able to access the main table google sheet and the new import googlesheet will be held in my google account too. How can I allow them to open the file (after giving them access to the google sheet or add a link for the google sheet to open?
Copy and pasting the google sheet link doesn’t work.