Clay Icon
Join the Community
02 Support

How to Extract Data from Serper.dev in Tabular Format

Avatar of Garv M.Garv M.
·
·

Hi can someone please tell me how do I extract all the information from serper.dev result in a tabular format. In some cells there are upto 20 website given as a result in some only 3 I need to extract them all

3 comments

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    To extract information from a URL into a tabular format, including multiple website results per cell, you have two main options: 1. Use our Clay Chrome Extension: • Install the extension and open it on the target page. • Click "Select Data to Add from Page". • Choose "Select a List" and click on the first few items to detect patterns. • Add attributes for each item (text, images, etc.). • The extension will apply the mapping to all items in the list. • Name and save your recipe. 2. Use the "Parse Data from URL with ScrapeMagic" feature: • Input the URL you want to extract data from. • Specify the fields to extract, including a description for each field. • Optionally, use the DOM Content Selector for more precise extraction. Both methods can handle multiple website results per cell. If you need further assistance, please request human help by clicking "Talk to a person".

  • Avatar of Garv M.
    Garv M.
    ·
    ·

    It is actually the result from seper.dev I connected Via API how do I get all the info?

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    To extract all information from a Serper.dev API result into a tabular format in Clay, you can use our "Extract Values from Data" and "write to table" features. Here's how: 1. Use the "Extract Values from Data" integration to process your Serper.dev API result. 2. In the integration setup: • Input your API result data in the "Data" field. • Choose the appropriate "Extraction Type" for websites. • If needed, specify "Object Fields" to target specific data. 3. After extraction, use the "write to table" feature to map the extracted data to a new table. 4. In the "write to table" setup: • Select your Clay account. • Choose a destination table. • Map each extracted item to individual rows in the new table. This process will create a tabular format with each website in its own row, regardless of how many were in each original cell.