I recommend turning off URL shortening, since the LocationMapUrl will then give you lat/lon without any further processing.
This Trigger fires every time any friend checks in on Foursquare or Swarm in an area you specify.
This action will add a single row to the bottom of the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created after 2000 rows.