Enrich Google Maps business and lead data with CoreClaw and Google Sheets

Quick overview

This workflow runs every 30 minutes to start a CoreClaw Google Maps scraping and enrichment job, then saves the returned business details and enriched lead contacts into two Google Sheets tabs.

How it works

1. Runs every 30 minutes on a schedule trigger.
2. Reads rows from a Google Sheets "Query" tab where the Status column is set to false.
3. Starts an asynchronous CoreClaw Google Maps Scraper run via the CoreClaw API using the configured search parameters.
4. Polls the CoreClaw run status until it returns succeeded.
5. Fetches the completed run results from CoreClaw and splits the list into individual places.
6. Appends each place’s business details (name, category, address, phone, website, emails, and social links) to a "CoreClaw Data" tab in Google Sheets.
7. Splits and appends each place’s leads_enrichment records (contact and company fields) to a "CoreClaw Leads" tab in Google Sheets.

Setup

1. Create a Google Sheets OAuth2 connection and select the target spreadsheet and the "Query", "CoreClaw Data", and "CoreClaw Leads" sheets.
2. Create an HTTP Bearer Auth credential with your CoreClaw API token for the CoreClaw API requests.
3. Ensure your "Query" sheet includes a Status column with false for rows you want processed, and update the CoreClaw request body parameters (keywords, base_location, max_results, and lead settings) to match your use case.