Data do not stop accumulating as soon as they’re published. Keeping track of constantly changing data—and updating all the linked charts and publications—can be an onerous and expensive task.
The County of Marin Department of Health and Human Services, along with one of their partners, the West Marin Health and Human Services (HHS) Center, has found a clever way to solve this problem with LiveStories. We recently offered a new feature that automatically updates datasets linked to Google Sheets every 24 hours. The West Marin HHS took this feature a step further by linking Google Sheets to Google Forms. They've created a story that automatically updates each day with new data from Google Forms—without anyone even opening a spreadsheet program.
The West Marin HHS Center participates in continuous quality improvement to ensure that it meets the needs of the rural community that it serves. Staff fill out a Google Form for every client visit, collecting information on a variety of client issues, from the reason they visited the Center to their primary language spoken at home. The data on these forms are vital for the Center to measure and refine their work.
The data submitted on the Google Form are automatically captured in a Google spreadsheet, which in turn is connected directly to their LiveStories account. With our automatic update, LiveStories updates the dataset linked to the Sheet every 24 hours automatically. As the center’s staff continue to fill out forms, their data flows into a Google Sheet—and, every night, into LiveStories.
The result: each day, all the charts in the story refresh to show the latest data from client forms. The center doesn’t have to spend time uploading new data or updating charts and text. They can focus on what matters most—gathering insights about their clients to give the best care possible.
If you’d like to learn how LiveStories can "live-stream" your data—or if you already use LiveStories and want to get up-to-speed on our Google integration features—request a demo today: