Skip to content

Validate and enrich a Google Sheet

For most sheets, the file route is enough. Download the sheet as CSV, upload it in the 1lookup.dev dashboard, pick a product and map the column. The result file has your original columns plus the new fields, ready to open as a new sheet or paste back.

Step-by-step guide
HTTP request
curl -X POST https://api.1lookup.dev/v1/email-validation \
  -H "Authorization: Bearer YOUR_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{"email":"jane.doe@example.com"}'
[01/Setup]

Connect Google Sheets in 4 steps

If you want lookups to run from inside the sheet, attach a short script that sends each row to the REST API with your Bearer key and writes the response into the next columns. That script is yours to write and maintain. There is nothing from 1lookup.dev to install in Google Sheets.

  1. 1

    Download the sheet as a CSV file.

  2. 2

    Upload it in the 1lookup.dev dashboard, choose the product and map the input column.

  3. 3

    Wait for the job to finish, then download the result file.

  4. 4

    Import the result into Google Sheets as a new tab, or match it back to the original by a key column.

[02/Recipes]

What to build with Google Sheets

Clean a lead sheet

Upload the sheet as CSV and run Email Validation and Phone Validation, then filter the result to rows where both passed.

Add company columns from a domain column

Run Company Profile Lookup on a column of domains and get size, headquarters and founding year as new columns.

Pull search volume for a keyword list

Put keywords in a column and run Keyword Metrics to add search volume, CPC and difficulty for each one.

Related guides

Google Sheets is a trademark of its owner. This guide describes how to connect using our MCP server and REST API. 1lookup.dev is not affiliated with or endorsed by Google Sheets.

[ Validate ][ Enrich ]
[Get started]

Run your first lookup in two minutes

Create a key, pick a plan and call any product in the catalog. Plans start at $29 a month.

[ Screen ][ Scrape ]