About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

Formula - How to increase a number per 1 (+1)

Raoni
Userlevel 1
Badge

Hello 👋, 

Fisrt, Sorry for my English 😕

I'm an Airbnb host and use zapier to automate a certain number of tasks.

I also use Notion for accounting, stock management, and cleaning tasks.

In this case I would like to count the number of guests I have per month so I know how many cleaning tasks I have to pay the cleaning lady.

Do you guys, have any idea how I could increase the number of bookings per 1 (+1) each time a booking is made ?

 

For now I've set up email parser.

Each time I receive a bookings confirmation from Airbnb it creates a an event on Gcal and updates my data bases on Gsheets and Notion. 

But I would like to have a counting system so I don't need to manually count bookings.

 

I'm not sure what app I should use for that, maybe using code by zapier :

-> using "look up row" task on Gsheets 

-> getting the value on a cell made for that (let say it's 2 bookings)

-> use a formula to increase the value (+1) That's the part I'm lost.

-> update the same cell with the new value.

 

I hope my explanations are clear enough so you can give me your help 😄 

 

To resume, I guess I need to find the right code formula to increase by 1 the data found in a gsheet or Notion cell.

icon

Best answer by christina.d 20 July 2022, 22:46

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.

12 replies

Danvers
Userlevel 7
Badge +12

Hi @Raoni!

You can do this by adding a Formatter by Zapier step into your Zap. The Formatter app does lots of different things, and one of them is to work with numbers, including doing maths!

First you need a step to find the Row in Google Sheets, which will give you the original number. 

Then add a Formatter step choosing Numbers for the event and ‘Add’ for the operation. 

In the ‘Values’ boxes, add the number from Google Sheets in one box and then type the number one in the next box. This will add 1 to the existing number whenever the Zap runs

Finally, use a Google Sheets ‘Update Row’ step to update the row that you need to, using the output of the Formatter step (ie the Formatter step will give you the number you need, and you then need to put it into the spreadsheet).

 

I hope that all makes sense, let us know if you have any questions!

Raoni
Userlevel 1
Badge

Hi Danvers,

It totally makes sense ! I didn't thought about formatter but now you mentioned it, it sounds obvious 😅

Will try it out tonight but I'm very optimistic. 🙂

Thank you very much for your help.

 

Troy Tessalone
Userlevel 7
Badge +14

Hi @Raoni 

Good question.

If you use Storage there is the action to: Increment Value

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
GetUWired
Userlevel 7
Badge +12

Hi @Raoni 

I know you already have a lot of suggestions but if you are storing the count in GSheets you do not need a formatter step to increment the value. You can just have 
Trigger: New Booking
Action: Lookup Row in GSheets
Action: Update Row in Gsheets -- in this step you can pass the value returned from the previous step into a formula. In other words pass back ={{insert value from lookup}} +1. Google sheets will do the math for you. 

jesse
Userlevel 7
Badge +9

@Raoni Looks like you’ve had some great suggestions on this thread! We just wanted to check in to see how you’re doing. Were you able to find success with any of the advice above? We’d love to know so we can help others running into similar issues. Let us know! 🙂

Raoni
Userlevel 1
Badge

Hi Jesse,

Thank you for your message.

I got some great suggestions indeed ! Unfortunately i couldn’t manage time to work it out yet but once it will be done iI’ll post an answer here with my feedback for sure.

Thanks again to @Danvers, @Troy Tessalone and @GetUWired for the help and suggestions.

 

christina.d
Userlevel 7
Badge +9

Hi friends, swinging by to summarize some of the recommendations here:

You can do this by adding a Formatter by Zapier step into your Zap. The Formatter app does lots of different things, and one of them is to work with numbers, including doing maths!

First you need a step to find the Row in Google Sheets, which will give you the original number. 

Then add a Formatter step choosing Numbers for the event and ‘Add’ for the operation. 

In the ‘Values’ boxes, add the number from Google Sheets in one box and then type the number one in the next box. This will add 1 to the existing number whenever the Zap runs

Finally, use a Google Sheets ‘Update Row’ step to update the row that you need to, using the output of the Formatter step (ie the Formatter step will give you the number you need, and you then need to put it into the spreadsheet).

There was another recommendation here to shorten the zap by:

...if you are storing the count in GSheets you do not need a formatter step to increment the value. You can just have 
Trigger: New Booking
Action: Lookup Row in GSheets
Action: Update Row in Gsheets -- in this step you can pass the value returned from the previous step into a formula. In other words pass back ={{insert value from lookup}} +1. Google sheets will do the math for you. 

 

Finally Troy had a different take:

If you use Storage there is the action to: Increment Value

 

Hope this helps!

Raoni
Userlevel 1
Badge

Hi all,

I worked on it and went with @Danvers solution with Formatter beacause i wanted to deal with it directly in Notion without creating a Gsheet database for it.

Works great and i’m sure all the solutions were good.

Thank you all.

jesse
Userlevel 7
Badge +9

@Raoni wonderful! Thank you for letting us know what worked for you. 🙂

K
Userlevel 1

Very instructing way of use. I’m also a host on Airbnb and I have made full of zaps for automatically send message to my guest and the people who make the cleaning of my loft. Can we exchange together ? 

jesse
Userlevel 7
Badge +9

@Komet Oohh this sounds super interesting! If you’re up for sharing, I bet there are dozens of Community members who would love to hear about the Zaps you have setup to manage your Airbnb operations. We’d love to have you author a post in our Show & Tell forum if you’re up for it! 🙏

K
Userlevel 1

Hello

i have made some post about the subject.

Regards 

Terms & Conditions