ZenRows’ integration with Make enables you to extract data without writing code. This guide takes you through the steps of integrating ZenRows with Make using a real-life scraping example.

​
What Is Make?

Make is a no-code platform for automating tasks by connecting applications and services. The platform operates on scenario workflows, where connected services or apps execute tasks sequentially based on a user’s input. Make integrates with several services, including ZenRows, Google Sheets, Gmail, and many more, allowing users to link processes visually. ZenRows’ integration with Make enables users to automate ZenRows’ web scraping service, from data collection to scheduling, storage, and monitoring.

​
Available ZenRows Integrations

  • Monitor your API usage: Returns the Universal Scraper API usage information
  • Make an API Call: Sends a GET, POST, or PUT request to a target URL via the Universal Scraper API.
  • Scraping a URL with Autoparse: Automates the Universal Scraper API to auto-parse a target website’s HTML elements. It returns structured JSON data.
    The autoparse option only works for some websites. Learn more about how it works in the autoparse FAQ.
  • Scraping a URL with CSS Selectors: Automates data extraction from an array of CSS selectors.

​
Real-World End-to-End Integration Example

We’ll build an end-to-end Amazon scraping Scenario using Make and ZenRows with the following steps:
  1. Pull target URLs from Google Sheets into Make’s Iterator
  2. Utilize ZenRows’ Scraping a URL with Autoparse integration option to extract data from URLs automatically
  3. Save the extracted data to Google Sheets

​
Step 1: Create a new Scenario on Make

  1. Log in to your account at https://make.com/
  2. Go to Scenarios on the left sidebar
  3. Click + Create a new scenario at the top right
Start Make scenario

​
Step 2: Connect the Google Sheets containing the target URLs

  1. Enter your Scenario’s name at the top-left (e.g., Amazon Scraper)
  2. Click the + icon in the middle of the screen Name scenario
  3. Search and select Google Sheets from the modal Flow control module selection
  4. Select Get Range Values from the options Make Google Sheets range setup
  5. If prompted, click Create a connection to link Make with your Google account Google connection Make
  6. Click the Search Method dropdown and select Enter manually
  7. Paste the Google Sheets ID in the Spreadsheet ID field
  8. Enter the sheet’s name in the Sheet Name field
  9. Provide the range of cells containing the target URLs in the Range field (e.g., A2:A11)
  10. Click Save
Make Google Sheets setup box

​
Step 3: Load the Target URLs into an Iterator

  1. Click + next to the Google Sheets module to create a new connection
  2. Search and select Flow Control, then click Iterator Make Iterator setup
  3. Place your cursor in the Array field and select the column containing the target URLs (i.e., A) from the integrated Google Sheets
  4. Click Save Make Iterator cell

​
Step 4: Connect ZenRows with the Make workflow

  1. Click the + icon
  2. Search and select ZenRows
  3. Click Scrape a URL with Autoparse Make ZenRows integration
  4. Click Create a Connection Make ZenRows connection setup
  5. Under Connection type, select ZenRows
  6. Enter a connection name in the Connection name field
  7. Provide your ZenRows API key in the API Key field Make ZenRows connection setup
  8. Click Save
  9. Place your cursor in the URL field, then select Value from the Flow Control option in the modal box Make ZenRows URL field setup
  10. Click Show advanced settings
  11. Select Yes for Premium Proxy and JavaScript Rendering
  12. Click Save
Make ZenRows advanced setup

​
Step 5: Store the scraped data in a Google Sheets

  1. Click Run once in the lower left corner to scrape data from the URLs Make ZenRows run
  2. Add another named sheet (e.g., Products) to the connected Google Sheets. Include the following columns in the new sheet:
    • Name
    • Rating Value
    • Review Count
    • Price (USD)
    • Out of Stock
  3. Click the + icon to add another module. Then, select Google Sheets.
  4. Select Add a row Make Google Sheets add row setup
  5. Select Enter manually from the Search Method dropdown ⇒ enter the Spreadsheet ID and Sheet Name.
  6. Under Column Range, select A-Z. Then, map the columns using the data extracted from ZenRows. Make Google Sheets column mapping
  7. Place your cursor in each column field and map it with the extracted data field as follows:
    • A = Value (from the Iterator)
    • B = title
    • C = avg_rating
    • D = review_count
    • E = price
    • F = out_of_stock
    Make ZenRows scraped data mapping
  8. Click Save

​
Step 6: Run the Make Scenario and Validate the Extraction

Click Run once in the lower-left corner of the screen. The workflow runs iteratively for each URL in the connected Google Sheets. The workflow scrapes the data into the Products sheet as shown: Make Google Sheets add row setup Congratulations! You’ve successfully integrated ZenRows with Make and automated your web scraping workflow.

​
ZenRows Configuration Options

ZenRows supports the following configuration options on Make:
ConfigurationFunction
URLThe URL of the target website
Headers
Premium ProxyWhen activated, it routes requests through the ZenRows Residential Proxies, instead of the default Datacenter proxies
Proxy Country
JavaScript RenderingEnsures that dynamic content loads before scraping
Wait for Selector
Wait Milliseconds
Window WidthSets the browser’s window width
Window HeightSets the browser’s window height
JavaScript Instructions
Session IDUses a session ID to maintain the same IP for multiple API requests for up to 10 minutes
Original StatusReturns the original status code returned by the target website

​
Troubleshooting

​
Issue: The workflow returns incomplete data

Solution: Ensure that JavaScript Rendering and Premium Proxy are enabled in the ZenRows configuration.

​
Issue: [400] Error with internal code ‘REQS004’

Solution 1: Double-check the target URL and ensure it’s not malformed or missing essential query strings. Solution 2: If using the CSS selector integration, ensure the extractor parameter is a valid JSON array of objects (e.g., [{"title":"#productTitle", "price": ".a-price-whole"}]).

​
Issue: Failed request or 401 unauthorized response

Solution 1: Ensure you supply your ZenRows API key. Solution 2: Double-check to ensure you’ve provided the correct ZenRows API key.

​
Issue: The Google Sheets module cannot find the spreadsheet

Solution: Double-check the Spreadsheet ID and ensure the Google Sheets API is enabled for your account.

​
Integration Benefits & Applications

Integrating Make with ZenRows has the following benefits:
  • It enables businesses to automate data collection and build a complete data pipeline without writing code.
  • You also overcome scraping challenges, such as anti-bot measures, dynamic rendering, geo-restrictions, and more.
  • By automating the scraping process, you only focus on data processing and analysis rather than worrying about building out complicated scraping logic.
  • Scaling up with Make integration is also easy, as you can add URLs continuously to your queue.
  • You can also schedule the scraping job to refresh your data pipeline at specific intervals.

​
Frequently Asked Questions