Google Drive Spreadsheet and Springpad – Embedding Links

One of the things you can do with Google Drive Spreadsheets is to embed links into your spreadsheets for connections outside the sheet.  If you combine that with Springpad shared springs you can create very powerful reference materials tied to you spreadsheets.  The process is:

  1. Copy the Share URL for the Springpad note or notebook to your clipboard
  2. In your Google Drive Spreadsheet use this formula in the cell where you want the URL:
Where URL is the URL for the Springpad note and Text is the text replacement for the URL to be shown in the spreadsheet.
It’s a quick and simple process, but very powerful for building indexes of reference materials as well as organizing supporting content for your spreadsheets.