Scrape and Structure Ecommerce Product Data
30 steps
Make
Google Sheets
1
Before starting the automation, ensure that you have a copy of [this sheet](https://docs.google.com/spreadsheets/d/1joY4MJvZjXBtgAVJwDGySoaSoodY7SZipfsX1ioouYQ/edit?usp=sharing) in Google Sheets.
2
Open the first (HTTP) module.
3
Ensure to put the URL of the XML sitemap from the website that you want to get the data from. You can find out how to locate a website's sitemap \[[from here](https://seocrawl.com/en/how-to-find-a-sitemap/)\].
4
Click "Save".
5
Click on the second module.
6
Ensure that the "Data" variable from the first module is connected.
7
Click "Save"
8
Click on the Iterator.
9
Ensure that the URL output is plugged in the array section.
10
Click "Save".
11
Click on the second HTTP module.
12
Ensure that the value for URL looks like this.
13
Click "Save"
14
Click on the "Markdown" module.
15
Ensure that "Data" from the second HTTP module is plugged in the HTML section.
16
Click "Save".
17
Click on the OpenAI module. Make sure to connect your OpenAI account to [Make.com](https://Make.com) first. See [this guide](https://apps.make.com/openai-gpt-3) for more details.
18
Ensure that the "Markdown" output is placed in the "Text to Parse" section.
19
Click "Save".
20
Click on the Google Sheet module, and establish your Google Account and [Make.com](https://Make.com) connection.
21
Ensure that the Spreadsheet ID matches the Google Sheet that you have prepared before the start of the automation. Once done, click "Save".
22
Click on the filter.
23
Ensure that the conditions are as shown, then hit save.
24
Finally, check the final module.
25
Check the variables placed on each section.
26
Check the variables placed on each section.
27
Check the variables placed on each section.
28
Check the variables placed on each section.
29
Click "Save"
30
The output (on your Google Sheets) should look like this.
