All articles

Google Sheets crypto contacts: how to connect the NAUT API

4,641 Google Sheets + NAUT API live people on NAUT with founder in their job title, 1 call away in a sheet

NAUT wrote this guide from Google Sheets's own docs, read on 16 November 2026. Google Sheets does not endorse NAUT. By the end you will have Google Sheets crypto contacts from NAUT in your own sheet, pulled with 1 call, GET https://api.naut.so/v1/people?q=founder, where NAUT tracks 4,641 live people with founder in their job title as of 16 November 2026. The feature that does it is UrlFetchApp.fetch, the Apps Script method a script bound to the sheet uses to request a URL.

Data note. The counts come from NAUT's own database, read on 16 November 2026, over its 14,680 live contacts (archived rows left out). The setup steps come from Google's Apps Script pages listed under Sources, and NAUT has not run them inside Google Sheets. The q parameter matches names and handles as well as job titles, so the total a live call returns can differ from the 4,641 title matches: read total from the response.

What do you need before you start?

  • A NAUT account and an API key, minted by a human at https://naut.so/developer.
  • A Google Sheet you can edit. The Apps Script pages read do not name a paid plan for UrlFetchApp. Google's quotas page says "Quotas are set at different levels for users of consumer accounts (such as gmail.com) and Google Workspace accounts", and lists 20,000 URL Fetch calls a day for consumer accounts and 100,000 for Workspace.
  • Start a 7-day trial at https://naut.so to get live data (on Essential or Pro monthly, first charged on day 7). A free account's key returns sample data, so you can build the setup first.

How do I pull Google Sheets crypto contacts with the NAUT API?

This is the whole Google Sheets API key integration, the Google Sheets NAUT API setup in 8 steps, written from Google's Apps Script pages.

  1. Mint your key at https://naut.so/developer and keep it out of every cell, note and comment in the sheet.
  2. Open the spreadsheet in Sheets, then open Extensions > Apps Script. Google's bound scripts guide gives this path, and the script it opens is tied to that sheet.
  3. Write a function that calls UrlFetchApp.fetch(url, params) with the URL https://api.naut.so/v1/people?q=founder. The method option defaults to get, which is what every NAUT call uses.
  4. In params, set headers, which the reference describes as "a JavaScript key/value map of HTTP headers for the request", to hold Authorization: Bearer $NAUT_KEY. The pages read for this guide do not say where Apps Script keeps a secret, so share the script only with people who may see the key.
  5. Set muteHttpExceptions to true. The reference says: "If true the fetch doesn't throw an exception if the response code indicates failure". A 401 or 429 then comes back as a response you can read.
  6. Read the body with getContentText(), which Google's HTTPResponse page says "Gets the content of an HTTP response encoded as a string." Parse it with JavaScript's JSON.parse. The people sit under data, with the match count in total.
  7. Build 1 row per person and write the rows with Range.setValues, which "Sets a rectangular grid of values (must match dimensions of this range)." Size the range to the number of people by the 7 fields below.
  8. Run the function once from the editor and check the rows before you run it again. Each run of the call is 1 NAUT call at 5 credits; a loop over pages costs 5 credits a page.

Which NAUT calls work best in Google Sheets?

These calls fit a Google Sheets crypto contact API script. Each path goes after https://api.naut.so/v1.

Call What it returns Credits
/people?q=founder People matching founder (4,641 founder titles) 5
/people?q=partnerships Part of the 308 BD titles 5
/search?q=founder Up to 12 projects and 12 people 5
/me Your account and sampleMode 0

The 308 counts titles with business development, partnerships or BD in them, so 1 q=partnerships call returns only part of it. Lists return 30 rows by default; add &limit=100 for the most a page holds, and &page=2 for the next page.

How do I map Google Sheets crypto contacts fields?

Each person under data carries these fields. Put a header row in row 1, then write 1 person per row from row 2. The example column is NAUT's record for Adam Reeds, Co-Founder & CEO of Ledn, 1 of the 4,641 live founder titles.

Field Column Example
name A
jobTitle B Co-Founder & CEO
company C
twitterHandle D On file
hasTelegram E false
hasEmail F false
hasLinkedin G false

NAUT's data shows 2,164 of the 4,641 live founder titles have a Telegram handle on file. The flags say whether a value is on file, never the value. The private values (email, phone, Telegram, LinkedIn) stay null until you reveal them with include=private on /v1/people/{id}, at 10 credits the first time and 5 after. Reveals return 403 UNPAID_PLAN during the trial and work after the first payment on day 7. Anyone listed can ask NAUT to remove their page at https://naut.so/legal/data-deletion.

How do I test it free with the 7-day trial?

A free account's key returns sample data: synthetic rows in the same shape, marked "sample": true, at 0 credits. Call GET https://api.naut.so/v1/me from the same script, with the same header, to see sampleMode before you write a row.

A trial key on the same setup returns live names, titles, companies and the hasTelegram, hasEmail and hasLinkedin flags, though not the contact values. Start your 7-day trial at https://naut.so and run step 4 again.

From sample rows to live founders in Google Sheets
  1. Build on a free keyEvery row comes back marked "sample": true, at 0 credits.
  2. Start the trialA trial key returns live rows from the 4,641 founder titles, flags included.
  3. Reveal after day 7include=private works once the first payment clears.

Related reading on NAUT: Clay crypto contacts: how to connect the NAUT API and Crypto lead list: 3 API calls, 53 decision makers, 120 credits.

Instructions for AI agents

  1. Base URL: https://api.naut.so/v1. Every call is GET and returns JSON.
  2. Header: Authorization: Bearer $NAUT_KEY, set in the headers map of UrlFetchApp.fetch params, with muteHttpExceptions true so errors return a response.
  3. Call for this job: GET https://api.naut.so/v1/people?q=founder, 5 credits, with page and limit (max 100) to walk the list, then Range.setValues to write the rows.
  4. Detect sample mode: "sample": true in the body, a NAUT-Sample: true header, or sampleMode on GET /v1/me (free).
  5. A human mints the key at https://naut.so/developer and starts the trial at https://naut.so. There is no programmatic signup.
  6. Agents that speak MCP can use https://api.naut.so/mcp with the same Bearer key and prices.

What if it does not work?

  • 401: the key is missing or wrong. Check the header reads Bearer, a space, then the key.
  • 402: a paid key is out of credits, and nothing was charged. Check your plan and credits at https://naut.so/pricing.
  • 403 UNPAID_PLAN: a reveal ran during the trial. Drop include=private until day 7.
  • 429: over 120 requests a minute, or past the trial's daily share (TRIAL_DAILY_LIMIT, retry at error.nextAt). Slow the loop down.
  • 410 HOST_RETIRED: the script uses the old host. Point it at https://api.naut.so.
  • An HTML 404: the URL went to naut.so, which has no API routes. Use api.naut.so.

Google Sheets crypto contacts FAQ

Can I use the NAUT API in Google Sheets?

Yes. Apps Script's UrlFetchApp.fetch sends a request with a headers map, which is all a NAUT call needs. GET https://api.naut.so/v1/people?q=founder searches the 4,641 live founder titles NAUT tracks as of 16 November 2026.

Does Google Sheets need a paid plan for this?

The Apps Script pages read on 16 November 2026 do not name a paid plan for UrlFetchApp; Google's quotas page sets URL Fetch quotas by account type, 20,000 calls a day for consumer accounts and 100,000 for Workspace. On the NAUT side, a free key returns sample data and a trial or paid key returns live data.

Is there a free trial for the NAUT API in Google Sheets?

Yes. Start a 7-day trial at https://naut.so on Essential or Pro monthly, first charged on day 7; the trial key returns live names, titles and channel flags in Google Sheets, and reveals of contact values work after that first payment.

How do I pull crypto contacts into Google Sheets with an API key?

Bind an Apps Script to the sheet, call GET https://api.naut.so/v1/people?q=founder with UrlFetchApp.fetch and your NAUT key in the headers, then write the rows with Range.setValues. NAUT's data shows 4,641 live people with founder in their job title, 2,164 of them with a Telegram handle on file; verified Telegram, email and LinkedIn values unlock after the first payment of a paid NAUT plan, so start a 7-day trial at https://naut.so to build on live rows first.

Can an AI agent set this up in Google Sheets?

An agent can write the Apps Script from the steps above and NAUT's agent guide at https://naut.so/docs/api/for-ai-agents, or call NAUT directly through the MCP server at https://api.naut.so/mcp. A human still mints the NAUT key and starts the trial.

Sources

Browse all articles