Clay Icon

Combining Multiple Review Site URLs into a List Format

Β·
Β·

Say I run an an enrichment pulling multiple review site urls for a company. Is there a way to combine them into a list format?

  • Avatar of Devin M.
    Devin M.
    Β·
    Β·

    The use case would be to make it easier to run a claygent on the list of urls from one column and also make it easier to push back to our crm

  • Avatar of Owen C.
    Owen C.
    Β·
    Β·

    Hi Devin, thanks for reaching out! Are you referring to the actual content within the reviews displayed on the website? If so, that’s absolutely possible! Here's how this workflow could look: 1. Create a table containing the URLs of the review sites for each company. Use this table to perform qualification or research on the companies while preparing for the next steps. 2. Use a Claygent prompt to extract the key data points related to the reviews from the review URL. These could include the review date, rating, description, and other relevant details. The extracted data will be structured in a JSON array format for easier processing. 3. Since the data scrapped is in JSON array format, you can write it to another table. In this new table, each row will represent an individual review tied to a company from the original table. Hope this answers your question! Let us know how else we can assist. :)

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    Hi Devin M.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: