I have a zap which does the following:
- (Trigger: New or Updated Spreadsheet Row in Google Sheets): I manually copy and paste many rows into a specific Google worksheet. Each row represents an inventory product.
-
A Sub-Zap is called which looks to Sheets to find an existing Oauth token to check whether it is expired. If it is expired, it generates a new Oauth token. If it is not expired, the Sub-Zap ends.
-
Goes through 3 separate zaps to add the product to ebay (ebay API requires three separate calls to create a product).
The problem is that the Sub Zap runs once for each new row added. The Sub-Zap has several steps, so this adds multiple Tasks for each row (product) added. However, I really only need to run this Sub-Zap one time; to either grab the existing unexpired Oauth token from Google Sheets, or to generate a new Oauth token if it is expired. How can I run the Sub-Zap only once and then pass the Oauth token to the rest of my zap for each row (product) added? Rather than run it once for each row.