Weather-aware daily dispatch brief for your Jobber crews

Every weekday at 5:30am in my local time zone, before my crews head out, build me a weather aware dispatch brief for the day and post it to Slack. Use a cron trigger rather than anything per visit or event driven, because this is a once a day morning briefing.

Make these configurable inputs: the latitude and longitude of my service area rounded to four decimal places, my time zone, the Slack channel to post to, the rain, wind and temperature thresholds that count as risky, and the list of job or service types I consider weather sensitive.

First pull today's schedule from Jobber. Use List Visits filtered to a start and end that cover today in my time zone. For each visit, use Get Visit to pick up the scheduled start and end times and the assigned team members, and Get Property to pick up the service address and any instructions or notes attached to the property. Use List Users when you need to turn assigned team member ids into readable names.

Then get the weather for my service area. Pass my latitude and longitude to NOAA Weather Get Point Metadata to convert them into forecast grid identifiers, then call Get Hourly Forecast for that grid point and keep only the hours that fall inside today. Also call Get Active Alerts for the same point so I can see severe weather warnings, watches and advisories.

Now judge which visits are genuinely at risk. Overlay the hourly forecast onto each visit's scheduled time window and decide based on the type of work. Exterior painting, roofing, lawn treatment, pressure washing, gutter work and landscaping are at risk when rain, high wind or freezing temperatures land inside that window. Indoor work such as interior repairs, appliance installs and in home service calls should be left alone even when the forecast is bad. Default thresholds: precipitation probability at or above 50 percent, sustained wind at or above 20 mph, or temperature at or below 32 degrees Fahrenheit at any point inside the scheduled window. Any active severe weather alert covering the point puts every outdoor visit that overlaps the alert's time range at risk. Infer the type of work from the visit title, the job instructions and the property notes, and when you genuinely cannot tell, treat it as outdoor and say the call is uncertain.

Post one Slack Bot message to my dispatch channel with Send a Message. Put a clearly separated "At risk, consider rescheduling" section at the very top, listing each affected visit with the crew, the time window, the address and the specific reason, for example "11am to 2pm, 80 percent rain, exterior paint". Below that, list the full day grouped by crew, and within each crew in time order, showing the scheduled time, the customer or job name, the service address and a one line weather note for that window. Close with a one line summary of the day's weather and any active alerts.

Never change anything in Jobber. This workflow is read only against Jobber by design: it recommends reschedules and my dispatcher makes the final call on moving a customer. Do not create, update, reschedule or complete visits, and do not message customers.

Handle the edge cases. If there are no visits scheduled today, post a short message saying the schedule is empty instead of a full brief. If a visit has no assigned team member, group it under "Unassigned" so my dispatcher notices it. If nothing is at risk, still post the brief and say the day looks clear. If the latitude and longitude fall outside National Weather Service coverage, post the schedule without risk flags and say that weather data was unavailable for that point.