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.
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"}'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
Download the sheet as a CSV file.
- 2
Upload it in the 1lookup.dev dashboard, choose the product and map the input column.
- 3
Wait for the job to finish, then download the result file.
- 4
Import the result into Google Sheets as a new tab, or match it back to the original by a key column.
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.
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.
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.