Check out MaineHarbors.com or TidesOnline.com to see the forecast tide for the day you're looking to go play. Put in about 2 hours after Portland high tide.
Report - Reports of Sheepscot Reversing Falls and related gauges
Reports give the public a chance to report on river conditions throughout the country as well as log the history of a river.