Clay Icon

Automated Google Search: Discover Company Diversity Stats

ยท
ยท

Hi, I have automated a google search to discover company stats on diversity. I have the results that I need and have scraped the data i needed which now sits in the in workflow. Sadly, the body text doesn't appear in the cell as it says the content exceeds the cells word limit. I can see the data, but I am unable to do anything with it. Is there any workaround this? https://app.clay.com/workspaces/48066/tables/t_VR1CbK2im6wQ/views/gv_2BM2RrYbZlzV

  • Avatar of Clay Team
    Clay Team
    APP
    ยท
    ยท

    Hey Aaron, thanks for reaching out! That's something that was brought up recently and the team will be looking into options for the cell size limits. For now, you can still split the text from the Scrape into 2 or more columns.You can use the formula generator to extract different sections of the text with a prompt like: 1st column: "return the first 8000 characters from /bodyText" 2nd column: "return the next 8000 characters after the first 8000 from /bodyText" ...Alternatively, you can also ask chatGPT to summarize and give you specific insights based on that text and that should help too.