Cascade Strategy + Schedule by Zapier + Google Drive + Formatter by Zapier
Update historical values of measures in Cascade Strategy from Google Drive files every hour
By finding a Google Sheets file in your Google Drive, and choosing the values column, you'll be able to update the historical values of the selected measure in Cascade Strategy hourly and keep them automatically up-to-date.
By finding a Google Sheets file in your Google Drive, and choosing the values column, you'll be able to update the historical values of the selected measure in Cascade Strategy hourly and keep them automatically up-to-date.
- When this happens...Every Hour
Triggers every hour.
- automatically do this...Find a File
Search for a specific file by name.
- then do this...Utilities
Various utilities like "choose value from list" or "look up in table" (with line-item support).
- then do this!Update Measure Historical Values
Updates historical values of a measure
- Free forever for core features
- 14 day trial for premium features & apps
About Cascade Strategy
Cascade helps organizations plan, execute, measure, and adapt their strategies in one place so they see business results faster.
Related categories
About Schedule by Zapier
Schedule is a native Zapier app you can use for recurring tasks. Trigger an action every day of the month, every day of the week or every single day. You can also select the hour of the day. If you're a developer, this is similar to a crontab, cronjob or cron.
Related categories
About Google Drive
Google Drive is Google's file sync app that lets you store all of your files online alongside your Google Docs documents, and keep them synced with all of your devices.
Related categories
Similar apps
Dropbox
File Management & Storage
Box
File Management & Storage
OneDrive
File Management & Storage, Microsoft
About Formatter by Zapier
Data isn't always in the format you need. Perhaps a date is in International format, but your app needs it in American format. Or maybe you need to Title Case a subject, truncate text for a Tweet, or turn Markdown text into HTML for your blog. Zapier's Formatter tool can help.