Extract E-Commerce Product Information Using Scraping Bee and Make.com

20 steps

Make

Scrapingbee

Google Sheets

Before starting the automation, ensure to create a free (or paid) account on [Scaping Bee.](https://www.scrapingbee.com/)

In the dashboard, you will already see your unique API Key, which you will use later on in establishing connection in Make.

Open the first module.

If the connection is not yet established, simply click on "Add".

Paste the API Key that you have in your Scraping Bee dashboard, and you're all set!

Once the connection is established, simply put the URL of the link that you want to scrape the product features and details.

Leave the "Extract Rules" as is.

Click "Save".

Open the second module. Connect your OpenAI account first to [Make.com](https://Make.com) before proceeding into anything further (see [this guide](https://apps.make.com/openai-gpt-3) for more details)

Check if the variable has been placed correctly in the "Role" section.

Click "Save".

Open the iterator module.

Ensure that the output from the OpenAI module is plugged.

Click "Save".

Open the last module (Google Sheet). You'll need to connect your Google Drive account \[[guide here](https://apps.make.com/google-sheets)\]. Then create a simple Google Sheet with 3 columns.\ \ Column A should be labelled 'Brand', column B 'Description' and column C 'Price'.\ \ Connect your Google Sheet to this module.

Check if the outputs from the Iterator module are plugged accordingly.

Click "Save".

Finally, here's how it should look like after running the automation.