Skip to main content
Question

How to Trigger an Action Flow With a Selected Case ID From a View and Write It to Google Sheets

  • March 10, 2026
  • 1 reply
  • 79 views
João Costa
Level 1
Forum|alt.badge.img+1

 

Hello everyone,

I’m trying to configure an Action Flow with the following logic:

  1. From a View, I want to retrieve only the selected case ID.
  2. Pass that case ID into the Action Flow.
  3. Inside the Action Flow, add the corresponding user ID and activity.
  4. Write these three values into a Google Sheet (case ID, user ID, activity).

Here is what I currently have:

  • In Get Rows, I am mapping the Input.
  • In Inputs, I created the variable input as an Array, and in Specification I set it as a Collection.
  • The View contains multiple columns and additional data, but I only want to map the case ID from the selected row.

My final goal is:

➡️ In the View, I have a table that includes the case ID. I want to select that specific case ID, even though there are other fields and values in the same row.
➡️ Trigger the Action Flow with that mapped case ID.
➡️ Add the corresponding user ID and activity inside the Action Flow.
➡️ Write everything into a single row in Google Sheets.

If anyone can explain step by step how to configure this — from the Get Rows, to whether a For Each is needed, and finally the Add Row in Google Sheets — I would really appreciate it.

Thanks in advance for your help!

!--endfragment>

1 reply

yevhen.riabt12
Level 3
Forum|alt.badge.img

one of the ways for scheduled action flows:

Step‑by‑step approach:

  1. Use an augmented variable
    Start by creating an augmented variable that will store the status for each case/row. (like - selected/not selected)
    When you want to select a raw - you just change variables from dropdown.

  2. Filter based on the augmented variable
    In your get rows (or get cases) logic, add a filter so that only cases with the selected status are retrieved.

  3. Add a second augmented variable (not to send cases twice)
    Create another augmented variable specifically for that purpose. (like - sent to google/ not sent). And add this Status as a filter to Get rows as well. 

  4. Use the “Update Augmented Attribute” module
    For updating this second variable automatically when data is send out to google sheets, you will need to use the module Update Augmented Attribute so your workflow can mark cases as processed or sent. (like - sent to google/ not sent)

Community Code of ConductAccessibility statement