Auto-fill GoogleSheet with targeted leads

Define your search criteria (job title, company, industry, country, headcount range) in a Google Sheets tab, and FullEnrich automatically finds matching contacts and populates a second tab with enriched leads.

Make

What this scenario does: When a new row appears in your "Search Criteria" Google Sheets tab (with job title, company, industry, country, headcount range, and limit), FullEnrich searches for matching people and adds them as new rows in your "Leads Found" tab with first name, last name, job title, company, domain, LinkedIn URL, and location.

1. Import the template into Make

Click Get Template above to download the blueprint JSON. In Make, go to Scenarios → Create a new scenario, click the ... menu at the bottom and select Import Blueprint. Upload the JSON file. You'll see 4 modules:

Module 1: Google Sheets - Watch Rows (trigger on new rows in Search Criteria tab)
Module 2: FullEnrich - Universal API Request (search for people)
Module 3: Iterator — loop through each found contact
Module 4: Google Sheets - Add a Row (add leads to your Leads Found tab)

2. Prepare your Google Sheets spreadsheet

You need one spreadsheet with two tabs:

Search Criteria tab — with headers in row 1:

Column A: Job Title — e.g. VP Sales
Column B: Company — e.g. Acme Corp
Column C: Industry — e.g. Software Development
Column D: Country — e.g. France
Column E: Headcount Range — e.g. 51-200
Column F: Limit — how many leads to find (e.g. 10)

Leads Found tab — with headers in row 1:

Column A: First Name
Column B: Last Name
Column C: Job Title
Column D: Company
Column E: Domain
Column F: LinkedIn
Column G: Location

Add at least one row of search criteria so you can test the scenario.

3. Connect your accounts

Open each module and connect the required accounts:

Module 1 (Watch Rows): Connect your Google account and select the spreadsheet and the Search Criteria tab. Make sure "Table contains headers" is set to Yes.
Module 2 (FullEnrich): Connect your FullEnrich API key. The template already has the People Search endpoint configured — it maps Job Title, Company, Industry, Country, Headcount Range, and Limit from your spreadsheet columns.
Module 4 (Add a Row): Connect the same Google account and select the same spreadsheet but the Leads Found tab.

4. Configure the Iterator

Module 3 is an Iterator — it takes the array of people returned by FullEnrich and loops through each one. The template is pre-configured to iterate over body.people. No changes needed unless you've modified the FullEnrich response structure.

5. Test the scenario

Click Run once, then add a new row in your Search Criteria tab with values like:

Job Title: Sales Manager
Company: (leave blank to search all companies)
Industry: Software Development
Country: France
Headcount Range: 51-200
Limit: 5

Check that new rows appear in the Leads Found tab with contact names, job titles, companies, domains, LinkedIn URLs, and locations.

6. Activate the scenario

Toggle the scenario ON and set a scheduling interval (e.g. every 15 minutes). Every time you add a new row to the Search Criteria tab, the scenario will automatically find matching leads and populate the Leads Found tab.

Tip: The Leads Found tab is populated with First Name, Last Name, Job Title, Company, Domain, LinkedIn URL, and Location. You can add more columns and map additional fields from the FullEnrich response in Module 4 (e.g. email, phone).

Troubleshooting

Problem	Solution
FullEnrich returns no people	Check that the search criteria are valid. Try broader values (e.g. wider headcount range, less specific job title). Make sure "Table contains headers" is set to Yes in Module 1.
Module 1 doesn't pick up new rows	Make sure the scenario is toggled ON and the schedule is set. After importing, you may need to run it once first so Make learns which rows are "new".
Rows not added to Leads Found	Verify that Module 4 is connected to the correct spreadsheet and the Leads Found tab. Make sure the tab has headers in row 1.
Wrong data in columns	Check that the column mapping in Module 4 matches your Leads Found tab headers (A = First Name, B = Last Name, etc.).

n8n

What this workflow does: When a new row is added to your "Search Criteria" Google Sheets tab (with job title, company, industry, country, and limit), FullEnrich searches for matching people and appends them as new rows in your "Leads Found" tab with first name, last name, job title, company, domain, LinkedIn, and location.

4 nodes: Google Sheets Trigger → FullEnrich People Search → Split Results → Append to Leads Found

1. Import the workflow

Click Copy Template URL above. In n8n, go to Workflows → Add Workflow → ⋯ (three-dot menu) → Import from URL and paste the URL. You'll see 4 nodes (with sticky notes explaining each step):

Google Sheets Trigger — polls the "Search Criteria" sheet for new rows
FullEnrich People Search — calls the People Search API with your criteria
Split Results — splits the people array into individual items
Append to Leads Found — adds each contact as a new row in your "Leads Found" sheet

2. Prepare your Google Sheets spreadsheet

You need one spreadsheet with two tabs:

Search Criteria tab — with headers in row 1: Job Title, Company, Industry, Country, Limit

Leads Found tab — with headers in row 1: First Name, Last Name, Job Title, Company, Domain, Linkedin, Location

3. Connect your accounts

Open each node and connect the required credentials:

Google Sheets Trigger: Connect your Google Sheets OAuth2 account, select your spreadsheet, and choose the Search Criteria tab. Set the event to Row Added.
FullEnrich People Search: Add your FullEnrich API key as a Header Auth credential (Authorization: Bearer YOUR_KEY). The template already has the People Search endpoint and body configured — it maps Job Title, Company, Industry, Country, and Limit from your sheet columns.
Append to Leads Found: Connect the same Google Sheets account, select the same spreadsheet, and choose the Leads Found tab.

4. Test and activate

Click Test workflow, then add a new row in your Search Criteria tab with values like:

Job Title: Sales Manager
Company: (leave blank to search all)
Industry: Software Development
Country: France
Limit: 5

Verify that new rows appear in the Leads Found tab with contact details. Once confirmed, toggle the workflow to Active.

Tip: The workflow includes sticky notes on each node explaining what it does. The Split Results node transforms the FullEnrich response array so each person becomes a separate row in Google Sheets.

Troubleshooting

Problem	Solution
Trigger doesn't pick up new rows	Make sure the workflow is Active and the trigger is set to poll every minute. After importing, you may need to add a test row first.
FullEnrich returns no people	Try broader search criteria (less specific job title, wider location). Verify the API key is correctly set as a Header Auth credential.
Rows not added to Leads Found	Make sure the Append node is connected to the correct spreadsheet and the Leads Found tab. Verify the tab has the correct column headers.
Wrong data in columns	Check that the column headers in your Leads Found tab match exactly: First Name, Last Name, Job Title, Company, Domain, Linkedin, Location.