< Go back to blog
Tutorials

September 9, 2024

How To Scrape Lead Data from Google Places with Dumpling AI in Make.com

In this tutorial, I will guide you through the process of creating an automation scenario using Make.com to scrape Google Places data with Dumpling AI and store it in Google Sheets.

Step 1: Set Up Dumpling AI Module

  1. Create a new scenario in Make.com and search for the Dumpling AI module in the module selector.
  2. Add the Search Google Places action from the Dumpling AI module to the canvas. This action will perform the scraping.
  3. Set up your Dumpling AI connection. If you don’t have an existing connection, click the ‘Add’ button to connect your Dumpling AI account. To get Dumpling AI API key, Go to Dumpling AI, sign up for a free trial, no credit card required, you will get 100 free credit.

In the module configuration, fill in the following fields:

  • Query: The type of business or place you want to search for. In this example, we’ll use Plumbers.
  • Country: Set the country where you want to find businesses, e.g., Canada.
  • Location: Specify the city or region, e.g., Toronto.
  • Limit: Define the maximum number of results to fetch, e.g., 30.

Step 2: Aggregate Data with Array Aggregator

  1. Add an Array Aggregator module after the Dumpling AI search. This will collect the data fields from the Dumpling AI results.
  2. In the aggregator, map the following fields from the Dumpling AI results, this is according to the data, you want to collect ,you do not need to check all these:
    • Title
    • Rating
    • Address
    • Website
    • Category
    • Phone Number
    • Rating Count

Step 3: Insert Data into Google Sheets

  1. Add the Google Sheets module to the scenario by selecting the Add Multiple Rows action.
  2. Connect your Google account if you haven’t done so already.
  3. Set up the following parameters:
    • Spreadsheet ID: This is the unique identifier of your Google Sheet. You can find it in the URL of the sheet.
    • Sheet Name: Specify the name of the sheet where you want to insert the data (e.g., Sheet1).
    • Table First Row: Set the range for the first row of your table (e.g., A1:Z1).
    • Rows: Map the rows from the Array Aggregator using the variable to insert the data from the previous step.

Step 4: Test and Run the Scenario

  1. Save your scenario and run it once to ensure everything is working correctly.
  2. Review the data in your Google Sheet to make sure all the fields are populated as expected.
Connecting dumpling AI to google sheets using an array aggregator on Make.com

Step 5: Set Up Scheduling

  1. Once you’ve tested your scenario and it works as expected, go to the Scenario settings and set the schedule to run at specific intervals (e.g., daily or weekly).

You have now successfully set up an automation using Make.com that scrapes data from Google Places via Dumpling AI and automatically stores it in a Google Sheet.

Download the blueprint used in this blog post

Click here to access the blueprint. Whether you’re just starting out or looking to refine your AI Automation skills, our community has got the tools and support to help you succeed.

Related Posts

How To Automate Client Research for Upcoming Sales Calls Using Dumpling AI, Google calendar, ChatGPT and Make.com.
Tutorials

How To Automate Client Research for Upcoming Sales Calls Using Dumpling AI, Google calendar, ChatGPT and Make.com.

October 1, 2024

How to Create an Auto-Email Organizer Using Make.com
Tutorials

How to Create an Auto-Email Organizer Using Make.com

September 29, 2024

How to Automate Proposal Creation Using Dumpling AI, ChatGPT, Google Slides in Make.com
Tutorials

How to Automate Proposal Creation Using Dumpling AI, ChatGPT, Google Slides in Make.com

September 26, 2024

How To Automate PDF Invoice Extraction to Google Sheets Using Dumpling AI and Make.com.
Tutorials

How To Automate PDF Invoice Extraction to Google Sheets Using Dumpling AI and Make.com.

September 23, 2024

How To Automate Employee Onboarding Process in Make.com
Tutorials

How To Automate Employee Onboarding Process in Make.com

September 20, 2024

How To Scrape Paginated Data using Dumpling AI and ChatGPT in Make.com
Tutorials

How To Scrape Paginated Data using Dumpling AI and ChatGPT in Make.com

September 17, 2024