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.
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
The scenario starts when you add a website row in Google Sheets. Read the sheet on a schedule if you prefer a batch.
Apify loads the homepage. Loop a few internal paths only if you need more context — cap them in JavaScript.
A JavaScript node de-duplicates URLs and keeps at most a few pages per prospect.
ChatGPT summarizes the scraped text and returns a multi-line opener.
Google Sheets writes the icebreaker next to the URL, or appends a row if you log to another tab.
Add a Google Sheets connection. Use a tab with a Website column. Trigger on each new row, or batch by reading the sheet on a schedule.
Add an Apify connection and scrape the prospect URL from the sheet. Put the Apify API key on the Apify connection.
Ask ChatGPT for a short summary plus a multi-line icebreaker. This is a Latenode AI node; you do not paste an OpenAI API key into it.
Update the sheet so the icebreaker lands beside the URL. Use JavaScript to cap pages before the AI step.
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.
