Skip to main content

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:

  1. My keys could potentially be longer than 32 characters
  2. I might need to store more than 500 keys

 

Does anyone know of a workaround to Storage by Zapier for this kind of thing?

In the past @JakeatGrantMe, I’ve just used a Google Sheet as an alternative.


@AndrewJDavison_Luhhu  Thank you for your response!

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!


@JakeatGrantMe 

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?


@AndrewJDavison_Luhhu That’s great! Thank you very much for your help!