Quick Overview This workflow collects local business leads from Google Maps using ScraperAPI and stores them in Google Sheets, letting you submit a niche and location via an n8n form and automatically deduplicate and append new businesses to your leads spreadsheet. How it works Creates a new Google Sheets spreadsheet with a “Leads” tab when you run the manual setup trigger. Triggers when a user submits the “Find local business leads” n8n form with a niche, location, and optional max results. Builds a Google Maps search query from the form inputs and reads existing rows from the target Google Sheet for deduplication. Uses ScraperAPI’s Google Maps Search to fetch metadata for the query, then extracts the results-page URL and fetches the autoparsed Google Maps results. Parses the returned businesses into lead fields (for example name, phone, address, website, rating, coordinates, and a Google Maps link) and filters by the minimum rating setting. Removes businesses already present in the sheet (matched by name + address), caps the batch to the requested maximum, and appends the new leads to Google Sheets.
Tags
Google SheetsRelated workflows
See all Google Sheets→WBacklink Monitoring Automation with Google Sheets + DataForSEO
What This Workflow Does This n8n workflow reads backlinks from a Google Sheet, sends each one to the DataForSEO On-Page API, and checks: Whether the backlink is still live on the target page Whether it's dofollow or nofollow Whether it's missing (i.e., lost) The result is then written back to the same Google Sheet under a Status column. Your result will look like this: Step-by-Step Setup Instructions Add your DataForSEO and Google Sheets credentials in n8n Make sure your Google Sheet has these columns: Backlink URL, Landing page, and Status Click the Test Workflow button to check a batch of backlinks Workflow Breakdown Trigger: Manual test start Read Data: Pulls backlink URLs and target pages from Google Sheets Format URLs: Extracts domain from URL Send POST Request to DataForSEO: Triggers a crawl on the backlink URL Wait 20 seconds: Allows crawl to finish Fetch Link Results: Retrieves backlink data from DataForSEO Validate Backlink: Checks if the backlink is live, and whether it’s dofollow Update Google Sheets: Logs the status as Live, Lost, or Lost (Nofollow)
WCSV to HubSpot Uploader with Dynamic Field Mapping and Google Sheets Integration
Who is this for? This n8n workflow is designed for Customer Success Managers (CSM), marketers, sales teams, and data administrators who need to automate the process of uploading and processing CSV data in HubSpot. It is ideal for users who regularly import contact lists, update CRM records, or sync data between systems. What problem does this workflow solve? Manually uploading and processing CSV files in HubSpot can be time-consuming and error-prone, especially when dealing with large datasets or complex field mappings. This workflow automates data validation, indexing, and field mapping, reducing manual effort and ensuring data consistency. What this workflow does Generating the list of the fields directly from Hubspot API Indexing: Organizes and prepares CSV data for HubSpot import. Data Processing: Cleanses and transforms data. Field Mapping: Maps CSV columns to HubSpot fields dynamically. Import Execution: Uploads processed data to HubSpot Setup Prerequisites: HubSpot API credentials (Private App token). Google sheets credentials. n8n instance (cloud or self-hosted). Installation: Import the workflow JSON into n8n. Configure the HubSpot nodes and the Google Sheets nodes with yo
WAutomated Funding Intelligence: CrunchBase to Google Sheets Tracking Workflow
🚀 Automated Funding Intelligence: CrunchBase to Google Sheets Tracking Workflow! Workflow Overview This cutting-edge n8n automation is a sophisticated startup funding intelligence tool designed to transform market research into actionable insights. By intelligently connecting CrunchBase, data processing, and Google Sheets, this workflow: Discovers Funding Opportunities: Automatically retrieves latest funding rounds Tracks industry-specific investments Eliminates manual market research efforts Intelligent Data Processing: Filters funding data by location and industry Extracts key investment metrics Ensures comprehensive market intelligence Seamless Data Logging: Automatically updates Google Sheets Creates real-time investment database Enables rapid market trend analysis Scheduled Intelligence Gathering: Daily automated tracking Consistent market insight updates Zero manual intervention required Key Benefits 🤖 Full Automation: Zero-touch funding research 💡 Smart Filtering: Targeted investment insights 📊 Comprehensive Tracking: Detailed funding intelligence 🌐 Multi-Source Synchronization: Seamless data flow Workflow Architecture 🔹 Stage 1: Funding Discovery Scheduled Trigger**: