Best answer

Simple Alternatives to Storage by Zapier

  • 7 May 2020
  • 4 replies
  • 1251 views

Userlevel 3
Badge

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?

icon

Best answer by AndrewJDavison_Luhhu 13 May 2020, 10:15

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Userlevel 7
Badge +10

@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?

Userlevel 3
Badge

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

Userlevel 7
Badge +10

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

Userlevel 3
Badge

@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!