It would appear that if you write a Google Apps script attached to a spreadsheet that makes API calls to Google Maps, it will only let you ask for directions 1,000 times in one day.
Why the heck do I know that? Well, you're just going to have to keep an eye out for a @streetsmn…