Hi, is there anyway to paginate the google perform search enrichment within clay my goal is to receive more than 100 results for the same query
Yes, you can paginate Google search results in Clay to get more than 100 results. Use our paginated database extraction template that allows you to add page numbers to the first column, giving each page its own row. The template creates dynamic URLs for each page, enabling you to scrape multiple pages of search results systematically. After extracting the paginated data, you can write it to a new table for further enrichment and analysis. Copy this pagination template to get started with extracting data from paginated Google search results.
Hey Charlie S. You’re correct google Search Enrichment in Clay is limited to roughly 100 results per query because of Google’s API restrictions clay doesn’t currently support native pagination, so the best workaround is to break your query into multiple, narrower searches (for example, by date range, location, or keyword variation) and then combine the outputs this approach effectively bypasses the single-query cap and lets you gather more than 100 results
Exactly right! That's the most effective approach for getting more than 100 Google search results in Clay. Breaking queries into narrower searches by date range, location, or keyword variations is the best workaround for Google's API limitations. You can then combine all the outputs to build a comprehensive dataset that exceeds the single-query cap.
Charles A. Anytime! Glad I could help 🙌