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.
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 search for the query and location you set.
Serper runs a Google search for local businesses. Put the Serper API key on the Serper connection.
JavaScript turns each hit into name, address, phone, and rating columns.
Google Sheets writes the batch into the spreadsheet you connect.
Add a Serper connection and paste your Serper API key there. Set the Google search query and location on that step.
Add a Google Sheets connection. Use a sheet with columns for name, address, phone, and rating, then map the JavaScript output into new rows.
Add a schedule. Add JavaScript between Serper and Sheets to normalize name, address, phone, and rating. Run once and confirm the new rows.
FAQ
More templates
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.
This template watches Google Sheets for a new prospect website, scrapes the homepage with Apify, and asks ChatGPT for a multi-line cold-email icebreaker. The icebreaker is written back next to the URL. Connect Google Sheets and Apify, then keep a Website column in the sheet.
