Collect product details from a web page and send them straight into Google Sheets. Ideal for marketers and researchers who track prices, titles, images, and links for quick market checks or content planning.

On start, a manual button runs a fetch that uses Jina AI to read a public web page. The page text goes to an AI extractor that follows a set schema with fields like title, price, image url, and product url. The OpenAI model powers the extraction so it pulls only the fields you ask for. Results are split into single items and then added to a Google Sheet as new rows.

Setup needs accounts for Google Sheets, OpenAI, and Jina AI. Expect faster research, less copy and paste, and cleaner data. Use it for competitor tracking, book or product catalogs, or affiliate research. Run it on demand now and later add a schedule if you want ongoing updates.

• Manual start with a test button to control when data is captured
• HTTP fetch through Jina AI to read a public web page in a clean format
• AI powered information extraction with a clear schema for title, price, image url, and product url
• OpenAI Chat Model provides accurate field level parsing from unstructured text
• Split Out node converts the extracted array into single items for row by row handling
• Google Sheets append adds each product as a new row in your chosen sheet
• Credential based connections for secure access to Sheets, OpenAI, and Jina AI

• Reduce manual copy and paste from 2 hours to 10 minutes per page
• Automate up to 90% of repetitive product research work
• Improve data quality by standardizing fields like title and price
• Handle 5 to 10 times more pages by repeating the same setup
• Connect web content, AI extraction, and Google Sheets in one flow

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, create a Google Sheets OAuth credential. Name it clearly, select the Google account that owns your target spreadsheet, and grant access.
4. In the n8n credentials manager, create an OpenAI API Key credential. Get your API key from your OpenAI account API page, paste it in, and save the credential.
5. In the n8n credentials manager, create an HTTP Header Auth credential for Jina AI. Add an Authorization header with the value Bearer YOUR_TOKEN from your Jina AI account if required, then save.
6. Open the Jina Fetch node. Confirm the URL points to r.jina.ai/http://your-target-url. Keep Allow Unauthorized Certs enabled if needed for the target site.
7. Open the OpenAI Chat Model node. Choose your OpenAI credential and select a suitable model. Keep default settings for temperature and max tokens or adjust as needed.
8. Open the Information Extractor node. Make sure Text is set to {{$json.data}}. Keep the schema with fields for title, price, image_url, and product_url. Ensure the AI Language Model input connects to the OpenAI Chat Model node.
9. Open the Split Out node and verify the field to split is output.results so each product becomes its own item.
10. Open the Google Sheets node. Select your Google Sheets credential, choose the target spreadsheet and sheet, then map each column to the extracted fields. Set operation to Append.
11. Click Execute or Test workflow. After it runs, open your Google Sheet and confirm new rows were added. If no data appears, check the Jina Fetch URL, verify your OpenAI key, and review the schema fields in the Information Extractor.