Google Maps leads to Google Sheets
A 67Leads Sheets feed is a private CSV link for one saved search. Put it in
IMPORTDATA and a Google Sheet lists the newest leads you own that match the search, in the
same columns as a CSV export. Reading the feed never spends credits. It is available on every paid plan, including the $6.70 pack (1,000 leads).
Steps
- Run a search in the app and press Save this search under the search box.
- Open Integrations. Under Google Sheets feed find the search and press Make a Sheets feed.
- Press Copy formula. It looks like
=IMPORTDATA("https://67leads.com/api/feed/<token>.csv"); the part in quotes is the feed URL. - In Google Sheets, click cell A1 of an empty sheet and paste the formula. The rows fill in below.
What is in the feed
The feed lists leads you already own that match the saved search, newest first, one row per business. Leads you have not exported yet are not in it, so a new match joins the sheet once you export it. That is what keeps the feed free: it only re-reads leads that are already yours.
It returns 500 rows by default and never more than 2,000. A search with more owned leads than that shows the newest ones.
Columns
The same columns as a CSV export in the default layout, with a header row:
company owner_name phone_e164 email email_status website city state postal_code category relevance toll_free rating review_count timezone email_verified email_type last_checked no_website site_down pitch_tags first_seen business_status maps_url social_url last_review_at hours_summary site_issues site_builder site_score is_chain site_tech email_checked_at listing_seen_at audit_url pitch_audit_line new_on_maps pitch_line pitch_angle pitch_facts
Other layouts, such as Instantly or HubSpot, are for file exports: see integrations.
How often it refreshes
Google Sheets decides when IMPORTDATA refetches; 67Leads does not control it.
Google's help page on calculation settings lists IMPORTDATA with a refresh of
1 hour (Google Docs Editors Help: calculation settings, checked 16 Nov 2026). The function's own page is
Google Docs Editors Help: IMPORTDATA. Each fetch gets current data, not a cached copy. A feed answers at most
120 fetches an hour; past that the fetch is refused until the hour turns over.
Does it spend credits?
No. A feed only reads leads you already own. It never takes a new lead, never counts against your daily limit and never charges credits, however often Sheets refetches.
Rotate or revoke the link
The link is the only credential, so treat it like a password. In Integrations, New URL makes a new token and the old link stops working at once (it answers "Feed not found"); paste the new formula into your sheet. Revoke deletes the feed. If the plan lapses, the feed answers with a 402 "Feed paused" message until the account is on a paid plan again.
Want a ping instead of polling?
Saved-search alerts show a "N new leads" badge in the app, checked every hour, on every plan. They never send email. To push new matches to your own tools, use webhooks.
WebhooksIntegrationsLead lists by nichePricing
Questions
Save a search in 67Leads, make a Sheets feed in the Integrations panel, copy the formula and paste it into a cell in Google Sheets. The leads you own that match the search fill the sheet.
500 by default, never more than 2,000.
No. It only reads leads you already own.
Press New URL in the Integrations panel. The old link stops working at once.
Yes. The feed is available on every paid plan, including the $6.70 pack (1,000 leads).