If I have a user click a URL for a Google Sheet but append the URL they click with parameters (ie. https://docs.google.com/spreadsheets/d/1N0qkLWp3fUm3xpp328MnIz8W4JdBR0990oPU8YW8G0E/edit?playerID=987654) where playerID is the parameter I want to copy into cell A1 of the Google Sheet in the link, how do I do this? If I can just pass the entire URL to cell A1, that's fine, I'll parse out the variable in a function.

  • Welcome to Web Applications. Google Sheets doesn't include that as a built-in feature. Anyway, please add a more details, does the URL could be any URL or should be the spreadsheet URL? Have you considered to use Google Apps Script? P.S. This question might may evolve into asking for a software recommendation... that type off question are off-topic here but might be on-topic on Software Recommendations. Commented Nov 9, 2021 at 18:47
  • the URL would be the URL for the google sheet where the cell would be populated with the URL value Commented Nov 9, 2021 at 19:03
  • basically, I run a fantasy baseball league and host all the stats in google sheets. I have a google sheet that lists all the players, and I would like each player to be a hyperlink so that when the user clicks on that players hyperlink, it takes them to another google sheet where I have a template that looks up the player's statistics based on the playerID in cell A1. I would like the hyperlink to include playerID in the the URL as a parameter, so that when the stats google sheet opens, it populates A1 with the playerID value from the URL parameter. Hopefully that helps clarify things Commented Nov 9, 2021 at 19:05
  • 1
    Thanks for replying. As I mentioned previously, Google Sheets doesn't include that as a built-in feature, but it support cell links. Have you tried to use them instead of custom query strings? Commented Nov 9, 2021 at 19:40
  • 1
    Does this answer your question? All Google Docs URL parameters/functions/commands?
    – Tedinoz
    Commented Nov 17, 2021 at 22:57


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.