How to Extract More Than 200 Local Business Leads from Google Maps

Ignacio A. · 2026-02-04T10:03:15.894Z

Hello, I see that the feature find local businesses in google maps just allow you to extract max. 200 rows, what can I do if I want to have the maxium number of leads in one table?

How to Extract More Than 200 Local Business Leads from Google Maps | Clay

Clay Support
APP
·
·
To get more than 200 rows from the “find local businesses in Google Maps” feature, enable the “Preferred Google API” toggle in the Google Maps source. This option allows you to pull more than 200 results (up to 1,000), but it costs 1 credit per result. If you want even more leads, segment your search by location or business type and run multiple searches, then combine the results into one table for the maximum number of leads. [1] [2] [3]
Clay Support
APP
·
·
Is that what you were looking for?
Clay Support
APP
·
·
If you need any further assistance with extracting more leads or combining search results, I'm here to help. Would you like to share more about what you're trying to achieve or any specific challenges you're facing?
Ignacio A.
·
·
can I export all the rows for different tables into just one?
Clay Support
APP
·
·
You can merge all rows from different tables into one by using the “Send table data” or “Write to Other Table” feature. In each source table, go to Exports or Actions → Send table data, pick your destination table, and choose which columns to send. Repeat for each table. This will consolidate all your data into a single table for easy export or further work [1] [2] [3] .
Clay Support
APP
·
·
Did that answer your question?
Clay Support
APP
·
·
If you need any more help with merging tables or exporting your data, please let me know. Would you like to provide more details about what you're trying to accomplish so I can assist further?
Ignacio A.
·
·
wich is the limit of rows a "find jobs" table can have?
Clay Support
APP
·
·
A "find jobs" table in Clay can hold up to 50,000 rows if you’re on a paid plan. On a free or trial plan, the limit is 50 rows per table. Each job search can import up to 1,000 jobs per query, but you can run multiple queries and combine results until you reach the table’s row limit. [1] [2] [3]
Clay Support
APP
·
·
Was this helpful?
Ignacio A.
·
·
just 1000 per query? when I search in find jobs feature I can see up to 25000 rows
Clay Support
APP
·
·
The Find Jobs feature can display up to 25,000 results in the UI because that's the total number of jobs matching your search criteria. However, each import query is capped at 1,000 rows, so you need to run multiple queries to bring all results into your table. This helps you target and manage large datasets without exceeding per-query limits. [1] [2] [3]
Clay Support
APP
·
·
Is that what you were looking for?
Clay Support
APP
·
·
If you still need help with managing your job search results or table limits, I’m here to assist. Would you like to share more about what you’re trying to achieve or any specific issues you’re encountering?
Ignacio A.
·
·
I don´t know what you mean by "each import query is capped at 1,000 rows"

18 comments