I recommend turning off URL shortening, since the LocationMapUrl will then give you lat/lon without any further processing.
If
New check-in by friend in area
This Trigger fires every time any friend checks in on Foursquare or Swarm in an area you specify.
Then
Add row to spreadsheet
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.
ID tMrQZ5gj
Discover more time saving integrations for Foursquare and Google Sheets