Back to Integrations
integrationClearbit node
integrationGoogle Sheets node

Clearbit and Google Sheets integration

n8n lets you integrate Clearbit with Google Sheets to build powerful workflows. Design automation that extracts, transforms and loads data between your apps and services. You can choose from thousands of ready-made apps or use our universal HTTP connector to sync apps not yet in our library.

Integrate Clearbit and Google Sheets

Build your own Clearbit and Google Sheets integration

Create custom Clearbit and Google Sheets workflows by choosing triggers and actions. Nodes come with global operations and settings, as well as app-specific parameters that can be configured. You can also use the HTTP Request node to query data from any app or service with a REST API.

How to connect Clearbit and Google Sheets

  • Step 1: Add the first step

  • Step 2: Add Clearbit and Google Sheets nodes

  • Step 3: Connect Clearbit and Google Sheets

  • Step 4: Run workflow

Enrich website visitors with Leadfeeder & Clearbit and save to Google Sheets

Use Case

When trying to maximize your outreach, website visitors are often an overlooked source of qualified new leads. This workflow allows your to track and enrich new website visitors and saves them to a Google Sheet once they meet a pre-defined criteria.

What this workflow does

This workflow fires once a day and gets all your leads saved in Leadfeeder. It then takes the leads that meet a pre-defined engagement criteria, e.g. that they visited your site 3 times, and enriches them additionally with Clearbit. From there it filters the leads again by a criteria on the company, e.g. a minimum employee count, and saves matching leads into a Google Sheet document.

Setup

  1. Add your Leedfeeder credentials. The name should be Authorization and the value Token token=yourapitoken. You can find your token via Settings -> Personal -> API-Token
  2. Add your Google Sheet credentials
  3. Save the Leedfeeder account names you want to use in the Setup node
  4. Copy the Google Sheets Template and add its URL to the Setup node

How to adjust this to your needs

  • Adjust and/or remove the engagement and company criteria
  • Add more ways to enrich a company

Potential ideas to enhance the use of this workflow

  • Automatically reach out to users that meet the criteria / that get added to the sheet
  • Create a workflow that finds the right employee in companies that are identified by this workflow

Nodes used in this workflow

Over 3000 companies switch to n8n every single week

Clearbit supported actions

Autocomplete
Auto-complete company names and retrieve logo and domain
Enrich
Look up person and company data based on an email or domain
Enrich
Look up a person and company data based on an email or domain

Google Sheets supported actions

Create
Create a spreadsheet
Delete
Delete a spreadsheet
Append or Update Row
Append a new row or update an existing one (upsert)
Append Row
Create a new row in a sheet
Clear
Delete all the contents or a part of a sheet
Create
Create a new sheet
Delete
Permanently delete a sheet
Delete Rows or Columns
Delete columns or rows from a sheet
Get Row(s)
Retrieve one or more rows from a sheet
Update Row
Update an existing row in a sheet

Looking to integrate Clearbit and Google Sheets in your company?

Why use n8n to integrate Clearbit with Google Sheets

Build complex workflows, really fast

Build complex workflows, really fast

Handle branching, merging and iteration easily.
Pause your workflow to wait for external events.

Code when you need it, UI when you don't

Simple debugging

Your data is displayed alongside your settings, making edge cases easy to track down.

Use templates to get started fast

Use 1000+ workflow templates available from our core team and our community.

Reuse your work

Copy and paste, easily import and export workflows.

Implement complex processes faster with n8n

red iconyellow iconred iconyellow icon