Append hourly KAM portfolio report rows to spreadsheet
Append hourly KAM portfolio report rows to spreadsheet
Your hourly KAM portfolio query lacks a central log, leaving vacancy and account counts fragmented. It appends hourly results to a shared sheet so KAMs see current counts before daily reviews.
Overview
Scattered hourly query results create blind spots for KAMs and coordinators; centralizing them delivers one reliable view for portfolio health. This flow writes each run into a shared sheet and pings the team channel so stakeholders see refreshed counts within an hour and enter daily reviews prepared.