Clay Icon

Easily Organize Scraped Reviews into Google Sheets or Clay

Ā·
Ā·

I had an AI scrape a website for reviews, how do I easily seperate them into 4 collumns each and then all in separate rows? Row 1: Company Name, Location, Rating, Review. Row 2: Company Name, Location, Rating, Review. etc. I've been trying to sync it with google sheets and trying to set it up in there but it's not working. Is there an easier way to do this maybe in clay? Haven't been able to find it

  • Avatar of Channeled
    Channeled
    APP
    Ā·
    Ā·

    You can efficiently organize your review data in Clay using these steps:1. Use Clay's Chrome Extension to scrape the website data, which allows you to select specific attributes you want to extract. 2. When selecting attributes to scrape, choose the four specific fields you need: ā€¢ Company Name ā€¢ Location ā€¢ Rating ā€¢ Review text 3. Alternatively, you can use Clay's native integrations with review platforms: ā€¢ Google Business Reviews ā€¢ Yelp Reviews ā€¢ These integrations automatically structure the data in an organized format.Clay's native scraper is designed to easily pull and organize specific types of data, making it simpler than manual organization in Google Sheets. Sources: Data points: Company Product Reviews | Clay.com Find Reviews with Yelp Get transcript of any YouTube video in seconds | Clay Deep Dive: Clay Scrapers [Limitless Research] - Clay University

  • Avatar of Channeled
    Channeled
    APP
    Ā·
    Ā·

    Looks like you're still looking for help. We're escalating this over to our support team and someone should be in touch soon. In the meantime, feel free to include any other information that may be helpful in solving your issue!

  • Avatar of Tanvi R.
    Tanvi R.
    Ā·
    Ā·

    Hey there, thanks for reaching out! To separate each of these fields into their respective columns, you will want to format your AI output as a JSON response. This will structure your output formulaically so that it is easy to parse and pull into other columns/rows. In your AI column, you can go to define outputs > select JSON Schema > select generate with prompt to ask AI to build this json schema structure for you. Here's a tutorial explaining how JSON schema improves your AI output performance: https://www.loom.com/share/4f7b6e6ecba44811af419a1ae0932d1b Let me know if this makes sense and if you have any further questions

  • Avatar of Channeled
    Channeled
    APP
    Ā·
    Ā·

    This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.