I'm attempting to make a database for our server network in order to log a player's information for easy-access. Here is an example, manually written (No automatic functions or scripts or anything):

I would like to set up this spreadsheet to automatically insert and update the information labeled by top row based on a manually inserted Steam Profile Link. The only things that I want to be left alone in order to be manually inserted are the Positions, Status, Alias(es) and Discord Tag.

I have been unsuccessful in finding anything to assist in completing this task and have little to no experience in writing scripts for Google Spreadsheets.

  • The question is too broad, please limit it to one specific problem and include a brief description of you search/research efforts. – Rubén Aug 10 at 2:31
  • @Rubén I've narrowed down the description more and included my search efforts. – Christopher Aug 10 at 2:55
  • Are the Steam user profiles publicly available or a Steam API is required to access them? – Rubén Aug 10 at 3:00
  • Whether or not the profile is public or private, the SteamID, SteamID3, and SteamID64 values are publicly available as well as the profile link. Here's an example of a site that is able to extract the other information via the profile link: steamidfinder.com – Christopher Aug 10 at 3:36
  • 2

Your Answer


By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Browse other questions tagged or ask your own question.