I need some assistance with a project

Dear Community,

i need some assistance.

I am the HR Manager of a company with 300 employees. I am reaching out to seek assistance with building a workflow using n8n to manage and retrieve employee information efficiently.

Here’s an overview of what I’d like to achieve:

  • Objective: Create a workflow to easily access employee information (e.g., full names, cell phone numbers, job titles) stored in a spreadsheet.
  • Current Setup: I have an existing spreadsheet that serves as the data source, containing all relevant employee details.
  • Desired Functionality: The ability to search or filter employee data by specific criteria (e.g., name, department) and retrieve the required details quickly.

Questions:

  1. Approach: Could you guide me on how best to approach this project within n8n?
  2. Integrations Needed: What integrations would be required to link my spreadsheet (e.g., Google Sheets or Excel file) with n8n, and how do I ensure seamless data retrieval?
  3. Customization: Is it possible to create a user-friendly interface (like a form or search bar) that triggers the workflow to fetch the data?

I’d appreciate it if you could provide step-by-step instructions or recommend resources to help me get started.

Thank you in advance for your assistance. I look forward to your guidance on building this workflow.

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:

Hi @JvH

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

First off I would recommend to have a look if we have something similar to your use case in our workflow template collection - Discover 800+ Automation Workflows from the n8n's Community
This is usually a great place to start out with some basic nodes and then iterate on it.

There is two ways you can build this, either using a Trigger node for the spreadsheet that you have (Google Sheets or Excel) that will be fired upon certain triggers or use a Schedule node that you can configure to pull at specific intervals.

Have a look in our extensive documentation and also feel free to check out our Tutorials:

For the user-friendly interface that triggers the workflow you could have a look at our Form Node.

If you get stuck or have more specific questions do let us know here :slight_smile: