Checking a list of URLs in a Google Sheet

Questions
1

Hi Team,

I’m trying to check the contents of a Google Sheet with an IF block. If the sheet contains a URL it closes the case in TheHive, if not, it checks Virustotal for its threat level, adds it to the sheet and closes the case if it’s not malicious. The IF block doesn’t seem to recognise that the URL is already present.

Thanks for the great work
Sam

2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
3

Hi @sam.newton

Thanks for posting here and welcome to the community! :cupcake:

Could you share an example where the IF node didn’t perform as expected?

4

Hi Ria,
Thanks for your response.
Although the URL is in the list in column 1, it still takes the false path, checks Virustotal and adds it to the list again. It does this multiple times. My intention is that if it’s on the list, close the alert.

Kind regards
Sam

5

Hi there,

Please see the information below:

  • n8n version: 1.62.3
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app): Docker
  • Operating system: Linux Ubuntu 22.04
6

If it helps, further investigation reveals that it is only checking the first row of the sheet.

7

Hi Team, does anyone have any ideas here? I tried using Airtable as well and it still only checks the top record in the list.

Thanks
Sam

8

Hi @sam.newton

Sorry for the late reply!

Can you check that your If node has the Execute Once toggle turned off?

image

9

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