🔓 Unlock all 10,000+ workflows & prompts free Join Newsletter →
✅ Full access unlocked — explore all 10,000 AI workflow and prompt templates Browse Templates →
Home n8n Workflow
January 21, 2026

Implisense to Google Sheets, Germany lookalikes ready

Lisa Granqvist Partner Workflow Automation Expert

Your “lookalike research” process usually starts with good intentions, then turns into tabs, exports, half-baked filters, and a spreadsheet nobody fully trusts. By the time you’ve found 50 decent German companies, you’re already wondering if half of them even match your ICP.

This Implisense Sheets automation hits growth marketers first, because pipeline needs volume. But sales ops and founders feel it too, especially when the team argues about what “ideal” even means. The outcome is simple: a clean, CRM-ready Google Sheet of Germany lookalikes plus an ICP report you can share as-is.

Below is what the workflow does, what you’ll need, and how to adapt it so the list actually matches your segment.

How This Automation Works

See how this solves the problem:

n8n Workflow Template: Implisense to Google Sheets, Germany lookalikes ready

The Challenge: Finding Germany Lookalikes Without Messy Data

Building a German lookalike list sounds straightforward until you do it more than once. You start with a few “perfect” customers, then try to find similar companies, then realize your sources disagree on names, addresses, and even industries. Next comes the cleanup: deduping, normalizing fields, and translating internal notes into something sales can use. It’s not just time. It’s the constant second-guessing, because one wrong assumption early (bad base companies, weak filters) pollutes every lead you touch afterward.

The friction compounds. Here’s where it breaks down in real teams.

  • People copy company IDs from random places, so the “base set” quietly degrades and recommendations get noisier.
  • You end up exporting, re-importing, then cleaning the same fields every week (name formats, locations, sizes, domains).
  • Filters like region, NACE industry codes, or size class are applied inconsistently, so the list looks big but doesn’t convert.
  • No one can explain why the ICP is the ICP, which means stakeholders don’t trust the targeting document.

The Fix: Implisense Lookalikes + ICP Report, Logged to Sheets

This workflow starts with a small set of base company IDs that represent your best-fit customers. It serializes those identifiers, adds your targeting filters (German regions, NACE codes, and company size classes), then sends a recommendation request to the Implisense API to fetch similar companies from official sources like the Handelsregister. If you enable “explanation mode,” it also pulls term features used in the recommendations, cleans and sorts them in both English and German, and feeds that into an OpenAI chat model to generate a readable ICP narrative. Finally, the automation maps the returned companies into consistent, CRM-ready fields and prepares outputs you can store and share. In plain terms: you get a list that’s usable, plus a story that tells your team why that list makes sense.

The workflow kicks off on demand (or from a message trigger), validates and formats your base IDs, then calls Implisense for lookalikes. After that, it splits the list into individual companies, normalizes the fields, and writes the results to Google Sheets alongside the generated ICP report.

What Changes: Before vs. After

Real-World Impact

Say you build one German lookalike list per week for a new segment. Manually, a typical process is: about 20 minutes to collect base companies, then maybe 3 hours of research and export across sources, plus another hour cleaning fields in Sheets. With this workflow, you paste in 3–10 base IDs, run it, and wait for processing (often around 10–20 minutes). You’re mostly left with review time, not data-entry time, so you get back about 3 hours every week.

Requirements

  • n8n instance (try n8n Cloud free)
  • Self-hosting option if you prefer (Hostinger works well)
  • Implisense API (RapidAPI) for Germany lookalike recommendations
  • Google Sheets to store lists and the ICP report
  • OpenAI API key (get it from your OpenAI dashboard)

Skill level: Intermediate. You’ll connect credentials and edit a few filters (regions, NACE codes, size classes) without writing real code.

Need help implementing this? Talk to an automation expert (free 15-minute consultation).

The Workflow Flow

Launch with a base set. The workflow starts when you run it manually (or pass company IDs from a trigger like Telegram or another upstream source). It checks you have enough base companies to get meaningful results.

Serialize and filter the request. Your company IDs are formatted into the structure Implisense expects, then the workflow adds your targeting constraints like German state/region codes, NACE industries, and company size classes.

Fetch lookalikes and generate an explanation. An HTTP request hits Implisense’s recommendation endpoint and returns ranked similar companies. If “explanation mode” is enabled, term features are extracted, split into English and German digests, and sent into an OpenAI chat model to write a clear ICP narrative.

Normalize for CRM and store it. The list is expanded into one row per company, mapped into consistent fields, then pushed into Google Sheets (and optionally staged for Excel/CRM imports). You end with a shareable sheet and an ICP report in the same place.

You can easily modify location filters to focus on one Bundesland, or adjust the score threshold to tighten quality. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the Manual Trigger

Set up the entry point so you can run the workflow on demand during setup and testing.

  1. Add the Manual Launch node as the trigger.
  2. Leave all fields at their defaults, since this is a manual trigger.
  3. Keep Flowpast Branding as a reference-only sticky note (no configuration required).

Step 2: Connect Implisense API Access and Run Settings

Define API access and run parameters that control the size and explanation behavior for the lookalike request.

  1. Open Auth Headers and set x-api-key to your API key (replace [CONFIGURE_YOUR_API_KEY]).
  2. Open Run Settings and set explain to false.
  3. In Run Settings, set size to 3.
  4. Verify the connection order: Manual LaunchAuth HeadersRun Settings.

⚠️ Common Pitfall: If you leave [CONFIGURE_YOUR_API_KEY] in Auth Headers, the API call will fail.

Step 3: Set Up Company ID Serialization

Prepare the company identifiers so they can be sent in the lookalike API request.

  1. In Sample Company IDs, keep the provided jsCode to output a list of id values for testing.
  2. In Serialize Identifiers, keep the function that builds serialization from each item.json.id.
  3. In Format Serialization, set serialization to {{ $json.serialization.replace(/[,]/g,'","').trim() }} and enable keepOnlySet.
  4. Confirm the flow: Run SettingsSample Company IDsSerialize IdentifiersFormat Serialization.

Step 4: Configure the Lookalike Request and Routing

Send the lookalike request and route outputs based on the explain flag.

  1. In Request Lookalikes, set URL to https://api.implisense.com/recommend?explain={{ $('Run Settings').item.json.explain }}&size={{ $('Run Settings').item.json.size }}.
  2. In Request Lookalikes, set Request Method to POST and enable JSON Parameters.
  3. Set Body Parameters JSON to { "baseCompanies": [ "{{ $json["serialization"].slice(0,-3) }}" ], "locationsFilter": [ { "type": "state", "code": "de-be" } ] }.
  4. In Route ICP vs Lookalikes, set the rule to equals with leftValue {{ $('Run Settings').item.json.explain }} and rightValue true.
  5. Confirm flow: Format SerializationRequest LookalikesRoute ICP vs Lookalikes.

Tip: With explain set to false in Run Settings, the workflow follows the lookalike branch instead of the ICP narrative branch.

Step 5: Set Up Term Processing and the AI Narrative

Extract term features, build language digests, and generate the ICP narrative with OpenAI.

  1. In Extract Term Features, keep the function that iterates items[0].json.targetProfile.features and outputs new items; note it continues on error.
  2. Extract Term Features outputs to both Filter English Terms and Filter German Terms in parallel.
  3. In Filter English Terms, keep the filter for item.json.key === 'term.en', then use Sort Terms Desc and Build EN Digest to generate the English digest string.
  4. In Filter German Terms, keep the filter for item.json.key === 'term.de', then use Sort Terms Desc 2 and Build DE Digest to generate the German digest string.
  5. Use Combine Term Digests with mode combine and combinationMode multiplex, then map the combined output in Prepare Prompt Text with text set to {{ $json["digest"] }}.
  6. In Generate ICP Narrative, select model gpt-5-mini and set the user content to {{ $json.text }}; keep the system content as provided in the node.
  7. Credential Required: Connect your openAiApi credentials in Generate ICP Narrative.
  8. In Store ICP Report, set icp_report to {{ $json.output[0].content[0].text }}.

Tip: The AI branch is only reachable when Route ICP vs Lookalikes matches the explain = true condition.

Step 6: Configure Output Mapping for Lookalike Results

Expand the lookalike response and map fields into CRM-ready output.

  1. In Expand Company List, set fieldToSplitOut to companies.
  2. In Map CRM Fields, map fields exactly as follows: crmLeadScore to {{Math.round($json.score * 100)}}, crmAccountName to {{$json.name}}, crmDomain to {{$json.url}}, crmCity to {{$json.city}}, crmZip to {{$json.zip}}, crmStreet to {{$json.street}}, crmImplisenseId to {{$json.id}}, crmProfileUrl to {{$json.profile}}, crmExplanation to {{$json.explanation}}, and crmIsActiveCompany to {{$json.active}}.
  3. Confirm the branch flow: Route ICP vs LookalikesExpand Company ListMap CRM Fields.

Step 7: Test and Activate Your Workflow

Validate both the lookalike and ICP narrative branches before turning the workflow on.

  1. Click Execute Workflow to run from Manual Launch.
  2. Verify a successful lookalike run returns data into Map CRM Fields when explain is false.
  3. Set Run Settingsexplain to true and re-run; confirm Store ICP Report receives icp_report.
  4. Once confirmed, switch the workflow to Active for production use.
🔒

Unlock Full Step-by-Step Guide

Get the complete implementation guide + downloadable template

Watch Out For

  • Implisense (RapidAPI) credentials can expire or need specific permissions. If things break, check your RapidAPI subscription status and the Basic Auth token used in the “Request Lookalikes” step first.
  • If you’re using Wait nodes or external processing, timings vary. Bump up the wait duration if downstream nodes fail on empty responses.
  • Default prompts in AI nodes are generic. Add your brand voice early or you’ll be editing outputs forever.

Common Questions

How quickly can I implement this Implisense Sheets automation automation?

Usually about an hour if you already have API access and a target Google Sheet.

Can non-technical teams implement this lookalike research?

Yes, but someone needs to be comfortable editing filters like region codes and NACE industries. No coding is required; it’s mostly credentials and careful configuration.

Is n8n free to use for this Implisense Sheets automation workflow?

Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in OpenAI API costs and your Implisense/RapidAPI plan.

Where can I host n8n to run this automation?

Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.

How do I adapt this Implisense Sheets automation solution to my specific challenges?

You’ll mainly tweak the request builder that sets locationsFilter, industriesFilter (NACE), and sizesFilter. You can also tighten or loosen the THRESHOLD in the “Filter & Normalize Results” logic, or increase the “size” parameter in the request URL to give Implisense more candidates. For the narrative output, swap the prompt text that feeds the OpenAI node so the ICP reads like your internal docs. If your CRM needs different columns, adjust the “Map CRM Fields” mapping so the sheet matches your import format.

Why is my Implisense connection failing in this workflow?

Most of the time it’s an auth issue: the Basic Auth token is missing, expired, or added to the wrong HTTP request. Also check that your RapidAPI plan allows the endpoint you’re calling, and that n8n is sending headers from the “Auth Headers” configuration you set. If you changed the request shape in the builder, one typo can lead to a 400 response that looks like a “connection” failure.

What’s the capacity of this Implisense Sheets automation solution?

If you self-host n8n, there’s no execution limit (it mainly depends on your server and API limits). In practice, this workflow usually handles a list of about 100 lookalikes per run comfortably, and you can scale by running segments separately and raising the request “size” parameter when needed.

Is this Implisense Sheets automation automation better than using Zapier or Make?

Often, yes. This workflow has branching logic (ICP report vs lookalike list), transforms term features, and does multi-step normalization before writing to Sheets, which is where Zapier/Make can get expensive or awkward. n8n also gives you a self-hosted path, so you are not paying per tiny step forever. That said, if you only need “call API → append row to Sheet,” Zapier or Make can be quicker to set up. Talk to an automation expert if you want a second opinion on complexity vs. speed.

You don’t need more “leads.” You need a repeatable way to define the segment, pull relevant German lookalikes, and hand sales a sheet they’ll actually use. Set it up once and let the workflow do the heavy lifting.

Need Help Setting This Up?

Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.

Lisa Granqvist

Workflow Automation Expert

Expert in workflow automation and no-code tools.

×

Use template

Get instant access to this n8n workflow Json file

💬
Get a free quote today!
Get a free quote today!

Tell us what you need and we'll get back to you within one working day.

Get a free quote today!
Get a free quote today!

Tell us what you need and we'll get back to you within one working day.

Launch login modal Launch register modal