Count Items in Google Sheet

Questions
1

Hi,

I have a google sheet with a column called “INFO”. I want to count how many rows in this column contain the value 1 and enter this total in cell E1. How would I go about this?

Thanks.

2

Hey @tamone!

Welcome to the community :tada:

I have build a small workflow that might help you with your use case. Please note that the Google Sheet node doesn’t have the functionality to add data to a specific cell. Your column should have a name which allows the node to map the information to the correct cell.
Here’s the sample workflow:

You can copy and paste the workflow in the Editor UI. Make sure to configure the credentials and update the spreadsheet ID.

3

Hi,

The “Total” is always 3 regardless of how many Results the Google Sheets Lookup finds.

Do I need to somehow refer the {{$items.length}} back to this node?

Thanks.

4

Hey @tamone,

I found the solution! The expression we were using in the Set node earlier was incorrect. You can use the below Set node to get the length of the items.

5

Great - that works, thank you!

6

Is it possible to do a lookup that checks 2 columns? e.g. lookup all rows that have Name = 1 AND Type = 3?

Thanks.

7

Thanks you very much, you save me long time search :smiley: