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.

When this happens...
Every Hour
Triggers every hour.
TriggerInstant
automatically do this...
Find a File
Search for a specific file by name.
ActionSearch
then do this...
Utilities
Various utilities like "choose value from list" or "look up in table" (with line-item support).
ActionWrite
then do this!
Update Measure Historical Values
Updates historical values of a measure
ActionWrite

Try this template

Free 14-day trial

5,000+ supported apps

Supported triggers and actions

What does this mean?

- Trigger on weekends?
  Should this Zap trigger on Saturday and Sunday?
- Time of DayRequired
  Triggers relative to your timezone settings and defaults to UTC (GMT+00:00) if no preference is set. Note: You can also specify a time with a Custom Value in the formats "hh:mm aa", "hh:mm", or "hhhh" (e.g. "2:30pm", "14:30", or "1430").
Trigger
Instant
Try It
- Day of the MonthRequired
  Day of month this schedule should trigger on.
- Time of DayRequired
  Triggers relative to your timezone settings and defaults to UTC (GMT+00:00) if no preference is set. Note: You can also specify a time with a Custom Value in the formats "hh:mm aa", "hh:mm", or "hhhh" (e.g. "2:30pm", "14:30", or "1430").
Trigger
Instant
Try It
- Drive
  The drive to use. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Shared Drives, you can select it here.
Trigger
Scheduled
Try It
- Drive
  The drive to use. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Shared Drives, you can select it here.
- Folder
  Check a specific folder for new subfolders. Keep clicking to go inside folders. Please note: new folders added to subfolders inside the folder you choose here will NOT trigger this Zap. Defaults to the top-level folder if none is picked.
Trigger
Scheduled
Try It
- FileRequired
  File to Copy
- Convert to Document?
  If yes, we will tell Google to convert this into an editable document.
- File Name
  By default, we name the new copy as "Copy of {original file name}".
- Drive
  The drive to use. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Shared Drives, you can select it here.
- Folder
  Folder to put the new copy into. Keep clicking to drill down into child folders. Defaults to the same folder as the source file's.
Action
Write

- Drive
  The drive to use. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Shared Drives, you can select it here.
- Parent Folder
  Select where to create this new folder. Keep clicking the dropdown to go inside folders. Defaults to the top-level folder if left blank.
- Folder NameRequired
Action
Write
- Drive
  The drive to use. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Shared Drives, you can select it here.
- Folder
  Folder where to place file. Keep clicking the dropdown to go inside folders. Defaults to the top-level folder if left blank.
- File NameRequired
- File ContentRequired
  Use plain text.
- Convert to Document?
  If yes, we will tell Google to convert this into an editable document.
Action
Write

- Drive
  The drive to use. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Shared Drives, you can select it here.
- File IdRequired
- Sharing PreferenceRequired
  This will add a group that the file is shared with, but not remove any existing groups it is shared with. Sharing with an organization is only valid for G Suite users.
- Organization Domain
  Domain name of your G Suite organization (required if you chose a "Sharing Preference" that includes your organization). Example: yourcompany.com
Action
Write
- Api Docs Info
  API docs for Google Drive are located here https://developers.google.com/drive/api/v3/reference
- HTTP MethodRequired
- URLRequired
  Requests can only be made to domains associated by this application.
- Query String Parameters
  These params will be URL-encoded and appended to the URL when making the request.
- Headers
  Authentication headers are included automatically
- Additional Request Headers
  Zapier will apply these optional headers and values to the request in addition to any headers created as part of the authentication mechanism.
- Body
  Zapier will pass this along raw. If you would like to provide complex JSON, try a "Code by Zapier" step to build the structure and pass it along here. For example, {"foo": "bar"} is perfectly valid.
Action
Write
- Folder NameRequired
- Drive
  The drive to use. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Shared Drives, you can select it here.
- Parent Folder
  Keep clicking the dropdown to go inside folders. Defaults to the top-level folder if left blank.
Action
Search
- Folder NameRequired
- Drive
  The drive to use. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Shared Drives, you can select it here.
- Parent Folder
  Select where to create this new folder. Keep clicking the dropdown to go inside folders. Defaults to the top-level folder if left blank.
Action
Search or write
- TransformRequired
Action
Write
- TransformRequired
Action
Write
- Workspace NameRequired
- Plan NameRequired
- Measure NameRequired
- Measure ValueRequired
Action
Write

- Trigger on weekends?
  Should this Zap trigger on Saturday and Sunday?
Trigger
Instant
Try It
- Day of the WeekRequired
- Time of DayRequired
  Triggers relative to your timezone settings and defaults to UTC (GMT+00:00) if no preference is set. Note: You can also specify a time with a Custom Value in the formats "hh:mm aa", "hh:mm", or "hhhh" (e.g. "2:30pm", "14:30", or "1430").
Trigger
Instant
Try It
- Drive
  The drive to use. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Shared Drives, you can select it here.
- Folder
  Check a specific folder for new files. Keep clicking to go inside folders. Please note: new files added to subfolders inside the folder you choose here will NOT trigger this Zap. Defaults to the top-level folder if none is picked.
Trigger
Scheduled
Try It
- Drive
  The drive to use. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Shared Drives, you can select it here.
- Folder
  Check a specific folder for updated files. Keep clicking to go inside folders. Please note: files updated within 5 minutes after creation or located in subfolders of the folder you choose here will NOT trigger this Zap. Defaults to the top-level folder if none is picked.
- Include Deleted
  Should this trigger also on files that are deleted?
Trigger
Scheduled
Try It
- Drive
  The drive to use. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Shared Drives, you can select it here.
- Folder
  Folder where to place file. Keep clicking the dropdown to go inside folders. Defaults to the top-level folder if left blank.
- FileRequired
  A file to be uploaded. Can be an actual file or a public URL. See this help doc for more information
- Convert to Document?
  If yes, we will tell Google to convert this into an editable document.
- File Name
  By default, we use the same name and extension as the original file.
- File Extension
  Advanced: Can only be used if you also specify a file name.
- Idempotency Key
Action
Write
- FileRequired
  File to Move
- Drive
  The drive to use. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Shared Drives, you can select it here.
- FolderRequired
  Destination folder to move into. Keep clicking to drill down into child folders.
Action
Write
- Drive
  The drive to use. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Shared Drives, you can select it here.
- Folder
  Folder to find/replace this file into. Keep clicking to drill down into child folders. Places at the top-level if none picked.
- File to ReplaceRequired
- FileRequired
  A file to be uploaded. Can be an actual file or a public URL. See this help doc for more information
- Convert to Document?
  If yes, we will tell Google to convert this into an editable document.
- File Name
  By default, we use the same name and extension as the original file.
- File Extension
  Advanced: Can only be used if you also specify a file name.
- Idempotency Key
Action
Write
- FileRequired
  File to create a shortcut to
- Drive
  The drive to use. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Shared Drives, you can select it here.
- Folder
  Destination folder for shortcut. Keep clicking to drill down into child folders.
Action
Write
- File NameRequired
- Drive
  The drive to use. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Shared Drives, you can select it here.
- Folder
- File Types
  Restrict the search to specific file types. If you only want a single file extension, you can simply add that to the name search above.
Action
Search
- File NameRequired
- Drive
  The drive to use. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Shared Drives, you can select it here.
- Folder
  Folder where to place file. Keep clicking the dropdown to go inside folders. Defaults to the top-level folder if left blank.
- File Types
  Restrict the search to specific file types. If you only want a single file extension, you can simply add that to the name search above.
- FileRequired
  A file to be uploaded. Can be an actual file or a public URL. See this help doc for more information
- Convert to Document?
  If yes, we will tell Google to convert this into an editable document.
- File Name
  By default, we use the same name and extension as the original file.
- File Extension
  Advanced: Can only be used if you also specify a file name.
- Idempotency Key
Action
Search or write
- TransformRequired
Action
Write
- TransformRequired
Action
Write
- WorkspaceRequired
- PlanRequired
- ActionRequired
- Action ValueRequired
Action
Write
- Workspace NameRequired
- Plan NameRequired
- Measure NameRequired
- dateRequired
- valueRequired
Action
Write

About Cascade Strategy

Cascade helps organizations plan, execute, measure, and adapt their strategies in one place so they see business results faster.

Related categories

Business Intelligence

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.

Learn more

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.

Related categories

Get started for free

You can't add more hours to the day. Zapier is the next best thing.

By signing up, you agree to Zapier's terms of service and privacy policy.

Cascade Strategy + Schedule by Zapier + Google Drive + Formatter by Zapier

Update historical values of measures in Cascade Strategy from Google Drive files every hour

Every Day

Trigger on weekends?

Time of DayRequired

Every Month

Day of the MonthRequired

Time of DayRequired

New File

Drive

New Folder

Drive

Folder

Copy File

FileRequired

Convert to Document?

File Name

Drive

Folder

Create Folder

Drive

Parent Folder

Folder NameRequired

Create File from Text

Drive

Folder

File NameRequired

File ContentRequired

Convert to Document?

Add File Sharing Preference

Drive

File IdRequired

Sharing PreferenceRequired

Organization Domain

API Request (Beta)

Api Docs Info

HTTP MethodRequired

URLRequired

Query String Parameters

Headers

Additional Request Headers

Body

Find a Folder

Folder NameRequired

Drive

Parent Folder

Find or Create Folder

Folder NameRequired

Drive

Parent Folder

Numbers

TransformRequired

Utilities

TransformRequired

Update Measure Current Value

Workspace NameRequired

Plan NameRequired

Measure NameRequired

Measure ValueRequired

Every Hour

Trigger on weekends?

Every Week

Day of the WeekRequired

Time of DayRequired

New File in Folder

Drive

Folder

Updated File

Drive

Folder

Include Deleted

Upload File

Drive

Folder

FileRequired

Convert to Document?

File Name

File Extension

Idempotency Key

Move File