How to create a Zap Run Log with Sub-Zaps and Zapier Tables

How to create a Zap Run Log with Sub-Zaps and Zapier Tables

Contribution by Troy Tessalone

Zapier Partner at Automation Ace.

NOTE: See screenshots below for context.

PROBLEM

The Zap Run history Task Usage tab shows Task Usage by Zap, but does NOT show Zap Runs by Zap.

https://zapier.com/app/history/usage

SOLUTION

Create your own Zap Run Log with Sub-Zaps and Zapier Tables!

APPS

NOTE: Using these apps count as 0 Tasks in Zap Runs!

1. Sub-Zaps
   1. Help: https://help.zapier.com/hc/en-us/sections/16075022072077-Sub-Zap-Looping
2. Zapier Tables
   1. Help: https://help.zapier.com/hc/en-us/categories/13398036609933-Tables

PREP

Create a Zapier Table with 3 fields:

1. Date
   1. Type: Date & Time
2. Zap ID
   1. Type: Text
3. Zap Run Count
   1. Type: Number

ZAPS

There are 2 types of Zaps that will be used:

• Parent Zaps
  • Calls the shared Sub-Zap
• Sub-Zap
  • Shared across Parent Zaps

STEPS

Parent Zaps

1. Trigger: [APP] - [EVENT]
   1. Up to you!
2. Action: Sub-Zap - Call a Sub-Zap
   1. Input Arguments
      1. Zap ID
         1. Map the system variable: Zap ID
            1. Help: https://help.zapier.com/hc/en-us/articles/36855498205453-Introducing-system-variables
3. Action: [APP] - [EVENT]
   1. Up to you!

Sub-Zap

1. Trigger: Sub-Zap - Start a Sub-Zap
   1. Input / Argument List
      1. Zap ID (required)
2. Action: Zapier Tables - Find Records
   1. Table: [SELECT]
   2. Create record if not found
      1. Check the checkbox to create record if it does not exist yet, thus configuring a find/create record step logic
   3. Filter Count: 2
   4. Lookup Fields
      1. Date is exactly Today
      2. Zap ID is exactly [Zap ID]
         1. Map variable from Zap step 1: Zap ID
3. Action: Zapier Tables - Increment or Decrement Value
   1. Table: [SELECT]
   2. Record
      1. Map the variable from Zap step 2: Record ID
   3. Number Field: Zap Run Count
   4. Increment Amount: 1
4. Action: Sub-Zap - Return from a Sub-Zap
   1. Output / Return Values
      1. Record ID
         1. Map the Record ID from Step 3
      2. Zap Run ID
         1. Map the system variable: Run ID
            1. Help: https://help.zapier.com/hc/en-us/articles/36855498205453-Introducing-system-variables

###