Ask Janek AI with Janek

All questions

make.com Web scraping Basics with AI · published 25 May 2025

Play at 3:52 Watch on YouTube Scraping

How do I add one Google Sheets row per product from a scraped page in Make?

I tell the AI to return JSON, I parse that JSON, and I map each field onto its own sheet column.

I add JSON, Parse JSON, and create a data structure. I add product name, then URL, then price, and I leave the other structure settings. The JSON string is the AI result. The AI does not return JSON until the prompt asks for it. I ask it to extract a list of products from the scraped data and to return that list as JSON. Each item has the product name, the URL, and the price. I also tell it not to capitalize every word, because it was doing that. I put an example of the JSON in the prompt. I tell it not to add extra double quotes, markdown, or a fence around the JSON, because it sometimes wraps the JSON a second time and the parser fails.

On Google Sheets, Add a row, the columns are product name, URL, and price. I map each one from the parsed JSON, not from the raw AI text. One run then adds a row per product. The same prompt can ask for contact details instead of products, or this sheet can feed the social posting scenario.