Hi there!
I have some data coming in from a webhook and for my subsequent steps I need to know if it’s the first, second, or third (or anything more than 3rd) time the data has passed through the Zap.
I thought I might use Storage by Zapier for this, but I’m stuck on two things:
Does anyone know of a workaround to Storage by Zapier for this kind of thing?
Best answer by AndrewJDavison_Luhhu
Well, you were talking about using Storage, but mentioned the limitations - in this case, you can use Google Sheets in the same way.
Two columns - ‘key’ and ‘value’
The zap would have a “Find or Create Spreadsheet” row step, a “Formatter->Number->Perform Math Operation” step to iterate the count and and “Update Spreadsheet Row” step to update the count on th sheet.
Make sense?
+10In the past
Can you describe how a setup in sheets would allow me to determine the number of times the data has passed through? Or rather what step(s) would I use to see if a value appears in a sheets column once, twice, or more than three times? My brain is failing me on coming up with an approach for this.
I appreciate your help!
+10Well, you were talking about using Storage, but mentioned the limitations - in this case, you can use Google Sheets in the same way.
Two columns - ‘key’ and ‘value’
The zap would have a “Find or Create Spreadsheet” row step, a “Formatter->Number->Perform Math Operation” step to iterate the count and and “Update Spreadsheet Row” step to update the count on th sheet.
Make sense?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
