This template runs on a schedule, reads ZIP codes and business categories from Google Sheets, searches Google Maps with Outscraper for each pair, then writes name, address, phone, and website into a results sheet after JavaScript drops duplicate place ids. Connect Outscraper and Google Sheets. Put the Outscraper API key on the Outscraper connection.
Latenode bills workflow runtime in CPU seconds. The first 10,000 CPU seconds are free each month, then usage follows pay-as-you-go CPU-second pricing. Plug-and-Play (PnP) AI nodes are billed separately—each PnP token is $1 USD, charged pay-as-you-go at vendor cost plus a small processing fee, with no API keys required.
Full pricing — how CPU seconds work →Workflow preview
A schedule starts the run and Google Sheets loads the ZIP codes and categories you listed.
Outscraper searches places for each ZIP plus category. Put the Outscraper API key on the Outscraper connection.
JavaScript drops repeat place ids and shapes name, address, phone, and website columns.
Google Sheets writes the batch and can mark that ZIP and category as done.
Add an Outscraper connection and paste your Outscraper API key there.
Add a Google Sheets connection. Use one sheet for ZIP codes and categories, and another for name, address, phone, website, and place id.
Add a schedule. Read the ZIP and category rows, search places on Google Maps with Outscraper, drop duplicates in JavaScript, then add rows. Add a short delay between searches if you run a long list.
Start with one ZIP and one category. Confirm the results sheet before you widen the list.
FAQ
More templates
This template runs a local-business Google search with Serper on a schedule, maps name, address, phone, and rating in JavaScript, and appends the batch to Google Sheets. Put the search query and location on the Serper step. Connect Serper and Google Sheets, then put the Serper API key on the Serper connection.
This template starts when a webhook receives a destination, scrapes Booking.com hotel listings with Bright Data, and asks ChatGPT for a short list with title, address, original price, and final price. JavaScript calls Bright Data and maps those fields. Supabase stores the rows. Put the Bright Data API key in that JavaScript node. Connect Supabase. ChatGPT is a Latenode AI step.
This template reads a username list from Google Sheets, runs your Apify Instagram profile actor, and writes cleaned profile fields back to the sheet. A schedule starts each batch. JavaScript maps username, bio, and follower counts, then Google Sheets appends the row and marks the username as done. Connect Apify and Google Sheets. Put the Apify API key on the Apify connection.
