Best answer

Can I lookup a cell in google sheets? I want to lookup the same one each time

  • 17 August 2020
  • 1 reply
  • 183 views

Userlevel 1

Trying to do an incrementing number that doesn’t reset each zap and having the worst time. Any ideas about that or this question?

icon

Best answer by KelseyBratcher 19 August 2020, 02:08

Make a sheet with at least 2 columns and 1 row.

Column 1: ID (I make this 1)
Column 2: value you want to retrieve

Use a look up row action to find the row with the ID (1 in my example). Then it always fetches the same row with whatever the value is.

This makes it easy for a non-zapier user to change it if need be.

I built a case number generator for an attorney. Every now and then. the case number gets broken and needs to be reset. Rather than using storage, which is kind of cumbersome for this purpose, I used sheets so one of his team members could go and manually change the value to whatever the next case number should be.

After a case is generated I also had an action that would take that field and +1 to whatever the value is.

View original

This topic has been closed for comments

1 reply

Userlevel 2

Make a sheet with at least 2 columns and 1 row.

Column 1: ID (I make this 1)
Column 2: value you want to retrieve

Use a look up row action to find the row with the ID (1 in my example). Then it always fetches the same row with whatever the value is.

This makes it easy for a non-zapier user to change it if need be.

I built a case number generator for an attorney. Every now and then. the case number gets broken and needs to be reset. Rather than using storage, which is kind of cumbersome for this purpose, I used sheets so one of his team members could go and manually change the value to whatever the next case number should be.

After a case is generated I also had an action that would take that field and +1 to whatever the value is.