I want to pull the Google spreadsheet URL into a cell within my sheet automatically.

If I copied my spreadsheet, I would like the entry to reflect the URL of the new sheet. Is this possible?

  • Welcome to Web Applications. It's expected that askers share a brief description of what they searched/researched about the question they are asking. Please take the tour and checkout How to Ask to learn about this. – Rubén Feb 17 '17 at 0:36

Yes, it's possible by using Google Apps Script, more specifically by using the getUrl

From the last link:

var ss = SpreadsheetApp.getActiveSpreadsheet();

The above code snippet adds the spredsheets's URL to the logger. To add it to a cell, you could use setValue(value)

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.