Getting Heap and Torch Data from Google Docs

One of the great things about Google Docs spreadsheets is how easy it is to add functionality. Google Apps Scripts allows you to write your own functions in JavaScript, right within in the spreadsheet. And now you can retrieve data from Heap CRM and Torch Project Management directly from the script.

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:

Torch WebHook >
Heap WebHook >

2 Responses to “Getting Heap and Torch Data from Google Docs”

  1. WBP SYSTEMS / Weblog » Blog Archive » Easier Google Docs Script Install (Heap CRM) Says:

    [...] Heap CRM Google Apps Scripts into Google Docs is a lot easier thanks to the new insert script menu item. In an open Google [...]

  2. WBP SYSTEMS / Weblog » Blog Archive » Easier Google Docs Script Install (Torch Project Management) Says:

    [...] Torch Project Management Google Apps Scripts into Google Docs is a lot easier thanks to the new insert script menu item. In an open Google [...]

Leave a Reply