CODEWITHSUNDEEP
google-apps-script
lightweight
lightweight

Reputation: 3327

query google spreadsheet with google apps script

I have a google speadsheet that contains contact info. Currently I'm able to load the spreadsheet in and have a name filter but it loads the actual spreadsheet. What I'm looking for is to have label boxes(address, city, state, etc..) get filled depending on what name the users is searching for, looking similar to a business card and not a spreadsheet..

Upvotes: 0

Views: 3516

Answers (1)

Serge insas
Serge insas

Reputation: 46822

Something like that maybe ?

  • online app
  • code the source spreadsheet key is in the script (var key=...) just add https://docs.google.com/spreadsheet/ccc?key= before this key and you get the url - please make a copy before changing anything, this ss is shared with edit rights to anybody with the link. (there is also an version of the script in the same ss that is partially in English ;-)
  • screen capture below

enter image description here

All this coming from a spreadsheet like below : enter image description here

Upvotes: 1

Related Questions