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:
- My keys could potentially be longer than 32 characters
- I might need to store more than 500 keys
Does anyone know of a workaround to Storage by Zapier for this kind of thing?
Best answer by AndrewJDavison_LuhhuView original
In the past
@JakeatGrantMe, I’ve just used a Google Sheet as an alternative.
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!
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.