How do you open a specific link (URL) for a logged-in user

Your error:

image

This is the useful part, which relates to this part of your script:

image

Possible causes:

  1. The ID is incorrect
  2. Your script is incorrectly deployed
    • Have you deployed your script for "Anyone" ?
    • Is the spreadsheet owned/shared with the script creator ? (google account)
    • permissions have not been correctly reviewed

A guide: