How to Scrape Gym Locations from Google Maps into Google Sheets with n8n and ScrapeHero

Last updated:

A gym directory helps fitness equipment suppliers map local prospects, compare facility coverage by neighborhood, and identify locations for relevant outreach.

Here’s how you can collect a list of gyms from Google Maps without writing any code, using n8n.

What Is n8n?

  • n8n helps you build automations by connecting visual blocks instead of writing code.
  • You work on a blank canvas where you place blocks called “nodes.”
  • Each node has one specific job: read data, search for something, filter results, save data, and so on.
  • If you connect the nodes in order with lines and run the automation, data flows through them one by one.
  • The full connected chain is called a “workflow.”
  • You can run this workflow anytime with one click or on an automated schedule.

Workflow Overview

  1. Reads a list of city names from a Google Sheet
  2. Searches Google Maps for “gyms” using ScrapeHero for each city
  3. Cleans up the results down to just the useful fields
  4. Saves everything into a new Google Sheet

The chain of nodes, in order:

  1. Manual Trigger
  2. Google Sheets (Create)
  3. Google Sheets (Get Rows)
  4. ScrapeHero
  5. Split Out
  6. Edit Fields
  7. Google Sheets (Append)
n8n workflow for scraping business listings from Google Maps

Adding and Connecting a Node

  1. Click the small “+” button on the canvas, or on the output side of the previous node if you already have one placed.
  2. Type the name of the node you want in the search panel that opens and click it from the list.
  3. Configure the node. When you close the configuration window, the node appears on the canvas as a box.

Note: If the node isn’t connected, drag a line from the small dot on the right edge of the previous node to the small dot on the left edge of the new one. This tells n8n the order to run things in.

What You Need

  • An n8n account (free to sign up)
  • A Google Sheet with a list of the cities you want to search
  • Google Cloud credentials that let n8n connect to Google Sheets
  • A ScrapeHero API key, which gives you access to the ScrapeHero Google Maps Scraper

Setting Up Your Credentials

n8n needs permission to access your Google Sheets and your ScrapeHero account. Creating “Credentials” saves a login or key that a node can use, so you don’t have to enter it every time.

  • Google account: The Google nodes (Sheets, Gmail, Docs, etc.) require a Client ID and Client Secret from a Google Cloud project. Create these in the Google Cloud Console, then paste them into n8n’s Google Sheets credential screen. n8n’s guide to Google credentials walks through the full setup.
  • ScrapeHero API key: The ScrapeHero node requires an API key. Sign up for a ScrapeHero account, then copy your API key from your dashboard as shown in ScrapeHero’s API introduction docs. Paste it into the ScrapeHero node’s credential screen in n8n.

Step 1: Add a Manual Trigger

  • A Manual Trigger only runs when you click the “Run” button yourself, so you can run the workflow whenever you want.
Manual Trigger node in n8n

Step 2: Create a New Google Sheet

  • Add a Google Sheets node with the “Create” sheet action.
  • Select the Google credentials.
  • Choose the document in which you want to create the sheet.
  • Give the sheet a name.
Google Sheets Create node settings in n8n

Step 3: Read Your List of Locations

  • Add a second Google Sheets node with the “Get Row(s)” sheet action.
  • Select the Google credentials.
  • Choose the document and the sheet containing the list of locations.
Google Sheets Get Rows node settings in n8n

Step 4: Get Google Maps Listings

  • Add the ScrapeHero node. You need to install the node before you can add it.
  • Choose the ScrapeHero credentials containing the API key.
  • Select the Google Maps Search API from the drop-down.
  • Execute the previous nodes, then drag and drop the locations field from the output of the Google Sheets (Get Row(s)) node into the input field.
  • Add “gyms in” in front of the new expression, so the search reads something like “gyms in Los Angeles”.
ScrapeHero Google Maps Search node settings in n8n

Step 5: Split the Results Into Individual Records

  • The API bundles the results as the value of a single JSON field.
  • Add a Split Out node to break that bundle apart.
  • Drag and drop the JSON field containing the listings into the Fields to Split field. Each listing becomes its own item, so the next nodes can process them individually.
Split Out node settings in n8n

Step 6: Keep Only the Fields You Need

  • Add an Edit Fields node to trim each record down to just the details you care about.
  • Drag and drop the fields you want to keep.
  • For gym research, keep the name, address, phone number, website, rating, and opening hours.
Edit Fields node settings in n8n

Step 7: Save Everything to Google Sheets

  • Add one final Google Sheets node and select the “Append row in sheet” action.
  • Select the Google credentials and the document and sheet where you want to save the data.
  • Set the mapping option to “Map Columns Automatically,” so n8n creates columns in your sheet from the field names in Step 6.
Google Sheets Append node settings in n8n

Once the workflow runs, the empty sheet from Step 2 fills up with clean, organized gym listings.

Use Cases

  • Plan equipment sales routes: Group gym addresses by neighborhood to prioritize in-person visits for fitness equipment and maintenance suppliers.
  • Build a service prospect list: Use gym names, phone numbers, and websites to identify locations for relevant cleaning, software, or repair service outreach.
  • Compare nearby fitness listings: Review categories, ratings, and review counts by area to understand how nearby gyms are represented before assessing competitors.
  • Shortlist partnership candidates: Sort listings by location and use their websites to find gyms that may fit corporate wellness or community program proposals.

Need tailored scraping solutions or Custom APIs? We can build one for you!

Contact us to schedule a brief, introductory call with our experts and learn how we can assist your needs.

Need Full Service?
3000 pages per second, navigate anti-bot measures, AI-powered data quality checks, handle complex JS websites