Best answer

Updating a Google Sheet Row by adding 1.

  • 11 May 2020
  • 1 reply
  • 633 views

I’m currently using a software that will update every single time a person opens an email.

The software itself doesn’t give a variable as to how many times this person has opened an email, however, I can update a row every time some does open an email.

 

That means that every time the zap triggers and I use it to find a row (create one if it doesn’t exist) I can ADD 1 to the cell in question.

 

I was wondering what I can use in Zapier in this particular section:

 

To simply add whatever is in there by the number 1.

 

Does anyone have any experience with this?

icon

Best answer by AndrewJDavison_Luhhu 12 May 2020, 14:34

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.

1 reply

Userlevel 7
Badge +10

Hi @kevinparady94 

So, you’ll want to add 3 steps:

  1. Lookup Spreadsheet Row - use this to get the row with the number,
  2. Formatter->Number->Perform Mathematical Function - take number from previous step + 1
  3. Update Spreadsheet Row - use this to update the row with result from previous step.