A monthly counter in sheets

Hi,

I have create a workflow to test and want to build a counter in it.
I was thinking to count in Google Sheet, how ofter a collegue will use the workflow and max it, to for example 5 times a month.

I cant seem to get it working, it doenst count and it doesnt stop the workflow with 6 or more requests.

Looking for advice on my mistakes.

You may have to set the object to a number in the if node like with:

.toNumber()

As it may be comparing with a string.

Where does the initial Count object come from? Form submission?
It may be easier to fetch the current count from sheets initially, and then add one to it later in the flow or earlier before the check.

Nice one!
Yes, it comes from the form submission.

Or could I also set a max. number in the sheet already and compare if that is matched, per month. If matched, the flow stops and otherwise it will continue

There is also a path that goes directly to the end without any limit checks.

This path needs to be removed, otherwise the AI agent will be triggered twice because there are two paths.

The “Clone Original Form Input” should be placed immediately after the “If” condition. To access the form’s values, a $json variable can be used with $('On form submission').item.json.

2 Likes

@Franz thank you so much!
Let me try this out, straight away.

@Franz I have tried somethings and this is the closed I get.
The issue now it, it seems to be checking, but still not count in my sheet.
It felt like such an easy workflow, but somehow i struggle.

1 Like

I’ve created a small workflow that checks and updates monthly limits/counts in Google Sheets.

Also, the ‘Test workflow’ path shows an example of how it can be used in another workflow.

The sheet includes “action,” “month,” and “count” columns.

It can also be expanded as needed.

Your workflow should than look something like this.

1 Like

Legend!

Thank you so much! It worked out.
Without your help, I dont think I could have get it working :raised_hands:

2 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.