Turn product listing pages into neat rows in a spreadsheet. Great for marketing teams that track prices and titles for research and reporting. Click once and capture data you can use right away.

The flow starts with a manual run, fetches a web page with an HTTP Request, and sends the page text into an AI extractor. The extractor uses a chat model to pull fields like title and price into a clean results list. The Split Out node handles each product as its own item, then the Google Sheets node appends each row to your chosen sheet. No need to write parsers or selectors.

You will need access to a Google Sheets account, an AI key, and header auth for the fetch service. Replace the target URL with your own category or listing page, confirm the extraction schema matches the fields you want, and map the columns in your sheet. Expect faster research, fewer errors, and a consistent format that supports price tracking, content planning, and competitor checks.

• Manual trigger to run the scrape on demand.
• HTTP Request node fetches the full web page content.
• AI powered Information Extractor pulls titles and prices using a chat model.
• Results are structured into a clean list for reliable processing.
• Split Out processes each product as an individual item.
• Append new rows into a selected Google Sheets document and tab.
• Simple configuration to change the target URL and column mapping.

• Reduce manual copy and paste from 2 hours to 5 minutes per page.
• Streamline price and title research by 80% with one click capture.
• Improve data quality by lowering copy errors by up to 90%.
• Connect AI extraction and Google Sheets in a single workflow.
• Handle hundreds of listings per run without extra effort.

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Google Sheets, OpenAI and Jina AI. See the Tools Required section above for links to create accounts with these services.
3. In the n8n credentials manager, connect Google Sheets. If unsure, double click the Save to Google Sheets node, choose Credential to connect with, click Create new credential, and follow the on screen steps to sign in with your Google account.
4. Add your OpenAI key. Double click the OpenAI Chat Model node, select Credential to connect with, click Create new credential, and paste your API key from your OpenAI account API page.
5. Set HTTP Header Auth for the fetch service. Double click the HTTP Request node, choose Credential to connect with, click Create new credential, and follow the on screen steps to add the required header for your Jina AI account.
6. Open the HTTP Request node and replace the URL with your own category or listing page that you want to scrape.
7. Open the Information Extractor node. Review the input schema and ensure it includes the fields you need such as title and price. Adjust names if you want them to match your sheet columns.
8. Open the Google Sheets node. Select your spreadsheet and tab. Confirm the column mapping for each field such as name, title, and price.
9. Test each step. Execute the HTTP Request node and confirm it returns page data. Then run the Information Extractor and check that a results array is produced with the expected fields.
10. Click Test workflow to run end to end. Verify that new rows appear in your sheet. If rows are blank, confirm the extractor input is set to {{$json.data}}, the Split Out node targets output.results, and the sheet columns match your field names.