Name: Smartsheet row discussion closure watcher
Author: recued-core

Smartsheet row discussion closure watcher

by recued-core v3 32 views

Use “Smartsheet row discussion closure watcher” in Recued. It checks saved items on a schedule and updates them when the connected service reports a final status.

Complete workflow

Smartsheet Row Discussion Closure Loop 4 pinned recipes

Use Smartsheet Row Discussion Closure Loop in Recued for sheets, rows, discussions, and comments. It includes 2 ready-to-run workflows and 1 related pack in one install.

You are viewing one recipe in this workflow. Installing it opens the complete pack so its other recipes and background automations arrive together.

Smartsheet row discussion closure watcher

This recipe Background automation

Use “Smartsheet row discussion closure watcher” in Recued. It checks saved items on a schedule and updates them when the connected service reports a final status.

smartsheetsheetsrowsdiscussions

by recued-core pinned v3

Comment on Smartsheet row with closure watch

Use “Comment on Smartsheet row with closure watch” in Recued. It carries out the named workflow using the connections and settings you choose.

smartsheetsheetsrowsdiscussions

by recued-core pinned v2

Smartsheet row discussion closure watcher timeout

Background automation

Use “Smartsheet row discussion closure watcher timeout” in Recued. Low-frequency timeout role for the connected service. It moves a limited batch of expired rows from active to timedout, deletes the active copy only after the durable timeout write succeeds, and notifies the owner once per batch.

smartsheetwatchertimeoutowner-review

by recued-core pinned v2

Smartsheet row discussion closure watcher lifecycle review

Use “Smartsheet row discussion closure watcher lifecycle review” in Recued. It carries out the named workflow using the connections and settings you choose.

smartsheetwatcherreviewclose

by recued-core pinned v1

View pack details, dependencies, and permissions →

How it works 105 steps

Inspect the data fetches, transforms, gates, and output this recipe runs.

Data fetch

▼ shared_row_watches core.storage.shared.list

List storage shared

▼

Process (104 steps)

■ now date_add

Add 0 days to

■ watch_rows filter

Filter by condition

■ watch_rows_for_connection filter

Filter by condition

■ watch_rows_with_sheet filter

Filter by condition

■ watch_rows_with_row filter

Filter by condition

■ watch_rows_with_discussion filter

Filter by condition

■ watch_rows_with_terminal_column filter

Filter by condition

■ never_checked_watch_rows filter

Filter by condition

■ checked_watch_rows filter

Filter by condition

■ checked_watch_rows_oldest_first sort

Sort by value.last_checked_at

■ fair_watch_rows flatten

Flatten nested lists in

■ candidate_rows slice

Take a subset of

■ batch_count count

Count items in candidate rows

■ candidate_count count

Count items in watch rows with terminal column

■ has_candidate compare

Check if candidate rows has data

■ has_connection compare

Check if connections smartsheet has data

■ skip_row_read any

Check if any of the conditions are true

■ batch_context_envelopes merge

Combine objects together

■ batch_contexts map

Extract from each item

◆ row_details recued-core.smartsheet.row.read

Read row on smartsheet

skip: step.skip_row_read equal true

■ row_details_live_batch_context pick

Keep only specific fields from

■ row_details_batch_context_envelopes merge

Combine objects together

■ row_details_batch_contexts map

Extract from each item

■ live_row_id default

Apply default

■ live_row_id_live_batch_context pick

Keep only specific fields from

■ live_row_id_batch_context_envelopes merge

Combine objects together

■ live_row_id_batch_contexts map

Extract from each item

■ has_live_row compare

Check if item live row id has data

■ has_live_row_live_batch_context pick

Keep only specific fields from

■ has_live_row_batch_context_envelopes merge

Combine objects together

■ has_live_row_batch_contexts map

Extract from each item

■ row_cells default

Apply default

■ row_cells_live_batch_context pick

Keep only specific fields from

■ row_cells_batch_context_envelopes merge

Combine objects together

■ row_cells_batch_contexts map

Extract from each item

■ terminal_cells filter

Filter by condition

■ terminal_cells_live_batch_context pick

Keep only specific fields from

■ terminal_cells_batch_context_envelopes merge

Combine objects together

■ terminal_cells_batch_contexts map

Extract from each item

■ has_terminal_cell compare

Check if item terminal cells has data

■ has_terminal_cell_live_batch_context pick

Keep only specific fields from

■ has_terminal_cell_batch_context_envelopes merge

Combine objects together

■ has_terminal_cell_batch_contexts map

Extract from each item

■ terminal_cell_value default

Apply default

■ terminal_cell_value_live_batch_context pick

Keep only specific fields from

■ terminal_cell_value_batch_context_envelopes merge

Combine objects together

■ terminal_cell_value_batch_contexts map

Extract from each item

■ terminal_cell_norm lowercase

Convert item terminal cell value to lowercase

■ terminal_cell_norm_live_batch_context pick

Keep only specific fields from

■ terminal_cell_norm_batch_context_envelopes merge

Combine objects together

■ terminal_cell_norm_batch_contexts map

Extract from each item

■ terminal_value_matched compare

Check if item terminal cell norm is one of setting terminal values

■ terminal_value_matched_live_batch_context pick

Keep only specific fields from

■ terminal_value_matched_batch_context_envelopes merge

Combine objects together

■ terminal_value_matched_batch_contexts map

Extract from each item

■ terminal_status all

Check if all conditions are true

■ terminal_status_live_batch_context pick

Keep only specific fields from

■ terminal_status_batch_context_envelopes merge

Combine objects together

■ terminal_status_batch_contexts map

Extract from each item

■ skip_close any

Check if any of the conditions are true

■ skip_close_live_batch_context pick

Keep only specific fields from

■ skip_close_batch_context_envelopes merge

Combine objects together

■ skip_close_batch_contexts map

Extract from each item

■ closed_watch_key replace

Replace text in item watch key

■ closed_watch_key_live_batch_context pick

Keep only specific fields from

■ closed_watch_key_batch_context_envelopes merge

Combine objects together

■ closed_watch_key_batch_contexts map

Extract from each item

◆ close_watch core.storage.shared.write

Write storage shared

skip: item.skip_close equal true

■ close_watch_live_batch_context pick

Keep only specific fields from

■ close_watch_batch_context_envelopes merge

Combine objects together

■ close_watch_batch_contexts map

Extract from each item

◆ delete_closed_active_watch core.storage.shared.delete

Delete storage shared

skip: item.close_watch.ok not_equal true

■ delete_closed_active_watch_live_batch_context pick

Keep only specific fields from

■ delete_closed_active_watch_batch_context_envelopes merge

Combine objects together

■ delete_closed_active_watch_batch_contexts map

Extract from each item

■ notify_terminal_enabled compare

Check if setting notify when terminal equals true

■ notify_terminal_enabled_live_batch_context pick

Keep only specific fields from

■ notify_terminal_enabled_batch_context_envelopes merge

Combine objects together

■ notify_terminal_enabled_batch_contexts map

Extract from each item

■ should_notify_terminal all

Check if all conditions are true

■ should_notify_terminal_live_batch_context pick

Keep only specific fields from

■ should_notify_terminal_batch_context_envelopes merge

Combine objects together

■ should_notify_terminal_batch_contexts map

Extract from each item

■ should_notify all

Check if all conditions are true

■ should_notify_live_batch_context pick

Keep only specific fields from

■ should_notify_batch_context_envelopes merge

Combine objects together

■ should_notify_batch_contexts map

Extract from each item

◆ notify_owner core.notification.send

Send notification

skip: item.should_notify not_equal true

■ notify_owner_live_batch_context pick

Keep only specific fields from

■ notify_owner_batch_context_envelopes merge

Combine objects together

■ notify_owner_batch_contexts map

Extract from each item

■ refreshed_watch_value merge

Combine objects together

skip: item.delete_closed_active_watch.ok equal true

■ refreshed_watch_value_live_batch_context pick

Keep only specific fields from

■ refreshed_watch_value_batch_context_envelopes merge

Combine objects together

■ refreshed_watch_value_batch_contexts map

Extract from each item

◆ refresh_active_watch core.storage.shared.write

Write storage shared

skip: item.delete_closed_active_watch.ok equal true

■ refresh_active_watch_live_batch_context pick

Keep only specific fields from

■ refresh_active_watch_batch_context_envelopes merge

Combine objects together

■ refresh_active_watch_batch_contexts map

Extract from each item

■ closed_batch_rows filter

Filter by condition

■ refreshed_batch_rows filter

Filter by condition

■ closed_batch_count count

Count items in closed batch rows

■ refreshed_batch_count count

Count items in refreshed batch rows

■ summary to_summary

Format results as a summary card

▼

Output

summary summary

Settings 4 configurable

Configurable at install. Defaults shown — change them anytime in Recued.

channels setting = [object Object]

batch limit setting = 5

terminal values setting = complete,completed,done,closed

notify when terminal setting = true

Uses (5 operations)

Shared store List storage shared core.storage.shared.list

Pack operation Read row on smartsheet recued-core.smartsheet.row.read

Shared store Write storage shared core.storage.shared.write

Shared store Delete storage shared core.storage.shared.delete

Notifications Send notification core.notification.send

Trust & control

What installing this recipe would let it do. Recued grants these permissions at install — review them there before approving.

Permissions it requires

Send notificationsRead your Smartsheet connection

Declared by the recipe — Recued grants these at install, where you review them before approving.

What it's allowed to do

Read Shared store core.storage.shared.list read-only

Write Shared store core.storage.shared.write external change

Write Shared store core.storage.shared.delete external change

Read Notifications core.notification.send external change

1 more isn't listed here. You'll see it at install.

Data it touches

SurfacesShared storeNotifications

Warehousedata.shared

About

recued-core

Details

105 steps 4 configurable settings recipe_id: row-discussion-closure-watcher-smartsheet

Smartsheet row discussion closure watcher

Complete workflow

Uses (5 operations)

Trust & control

Permissions it requires

What it's allowed to do

Data it touches

About

Tags

Details