Search an email on multiple google sheets

Hi there! I’m new to this exciting tool. I’ve used other automation platforms before, but I’m here because I want to create an agent in n8n that can:

  1. Receive a message from Slack containing a unique email address
  2. Search multiple Google Sheets for information related to that email
  3. Return all the relevant findings back to Slack

Can anyone have any ideas/tips for the 2nd step, because I have multiple google sheets with multiple tabs?

1 Like

Hi @Stefania_T

Here’s a couple thoughts on how to accomplish that.

  1. you can use the google sheets node to search for the email in a specific column. Use a set before the google sheets node to define which sheets you want to look in, and what column you want to search in.
  2. You could also create a rag agent where you move data from google sheets into a vector store like supabase. Then tell your agent to look anywhere in the store for that email address.

Best,
Robert

2 Likes

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