No-Code Google Maps Scraper with Google AI Studio & n8n
A no-code Google Maps lead scraper built with Google AI Studio (Gemini) and automated with n8n. This repository contains the n8n workflow JSON and all the resources from the full video tutorial.
Watch the full step-by-step tutorial on YouTube: https://www.youtube.com/watch?v=qBHubb2inaQ
Overview
This project demonstrates a powerful, no-code stack for building and automating custom AI applications.
- Google AI Studio is used to "vibe code" an application using natural language prompts.
- n8n acts as the powerful automation bridge, connecting the AI app to any other service.
- Google Sheets is used as the database to store the structured data.
How It Works
The data flow is simple:
- A user runs the app in Google AI Studio.
- Google AI Studio gathers the data and sends it via a
POSTrequest to a n8n Webhook. - The n8n workflow catches the data, splits it into individual items, formats it, and appends each item as a new row in Google Sheets.
[Google AI Studio App] --- (Webhook POST) ---> [n8n Workflow] --- (Append Row) ---> [Google Sheets]
Features
- No Code Required: Build the entire application with natural language and visual workflow automation.
- Flexible & Scalable: Easily modify the prompt in AI Studio to scrape different data, or change the n8n workflow to send data to a CRM, WordPress, or 400+ other apps.
- 100% Free to Start: All tools used in this tutorial have generous free tiers.
🚀 Getting Started
Follow these steps to get your own scraper running in minutes.
1. Prerequisites
- A free Google Account
- A free n8n account (Cloud or self-hosted)
2. Step 1: Set up Google AI Studio
- Open the Google AI Studio App Template:
https://ai.studio/apps/drive/1aVOVu_Ij8r5xeTJnrc7pCLUITH3t6F-m - Make a copy of the app in your own Google Drive.
- You may need to get a Gemini API key (
Get API keyin Google AI Studio) and add it to the app.
3. Step 2: Set up Google Sheets
- Open the Google Sheets Template:
https://docs.google.com/spreadsheets/d/1mOy9gQ6I_x3t5xXwZ9Fog9aMC2FGfgcq5QtbM146ua8/edit?usp=sharing - Go to
File>Make a copyto save it to your own Google Drive.
4. Step 3: Set up the n8n Workflow
- Download the
google-ai-studio-scraper.n8n.jsonfile from this repository. - Import the workflow into your n8n instance.
- Configure the Google Sheets Node:
- Open the "Google Sheets" node in the workflow.
- Create new credentials (OAuth2) and connect the Google Account where you saved your sheet in Step 2.
- In the "Sheet" field, select the Google Sheet you just created.
- Copy Your Webhook URL:
- Open the "Webhook" node (the first node).
- Copy the Production URL.
5. Step 4: Connect AI Studio to n8n
- Go back to your app in Google AI Studio.
- Find the part of the prompt that defines the webhook URL.
- Paste your n8n Production Webhook URL there.
- Save the changes to your AI Studio app.
6. Step 5: Activate and Run!
- Activate your workflow in n8n (toggle the switch on the top right).
- Run your app in Google AI Studio.
- Watch the data appear in your Google Sheet in real-time!
Resources
- Full Video Tutorial: https://www.youtube.com/watch?v=qBHubb2inaQ
-
- n8n: https://n8n.io
- Google AI Studio: https://aistudio.google.com
License
This project is open-sourced under the MIT License. See the LICENSE file for details.
Author
Built by Agrici Daniel - AI Workflow Architect.
- Blog - Deep dives on AI marketing automation
- AI Marketing Hub - Free community, 2,800+ members
- YouTube - Tutorials and demos
- All open-source tools