Here is a sample worksheet:
You will notice that I have two menus (each with two options). However you can also interact with this data as a formula like so:
And in every other respect they are just spreadsheet cells. So here I've used the functions to reference the user name and category cell and then just filled the columns:
The reverse is also possible. You could use a script to retrieve data in a spreadsheet and post it to Heap and/or Torch. One use case is when using Google Forms you could have all or part of a form submission automatically posted to Heap or Torch.
The developer documentation and sample code is here: