Clay Icon

Organizing Document Templates with Clay for Formatting Scraped Docs

·
·

I have scraped docs that I need to format to fit certain templates of another doc. Is there a way to organize that with clay?

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    💤 You've caught us outside of our support hours (9am-9pm EST), but don't worry - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in the thread below so that we can help you as quickly as possible!

  • Avatar of Bruno R.
    Bruno R.
    ·
    ·

    Hi Avi, thanks for reaching out. This seems like an interesting use case! Can you give me a bit more context into where the scraped data is currently stored, whether it is structured or not, where you want to push it to, etc.? I'd be happy to look into how you could build this workflow out in Clay. I hope this was helpful. If there's anything else I can assist you with, please let me know!

  • Avatar of Avi M.
    Avi M.
    ·
    ·

    Hey Bruno, here's an example. You can see a couple rows of scrapped product with different columns. Under the "Specification" column there are a bunch of individual ones I need to parse out to separate columns on another sheet. for example. reference number, movement, bezel all need to be in their own columns.

  • Avatar of Avi M.
    Avi M.
    ·
    ·

    One idea is if I map all the necessary fields to each column and then I map it out

  • Avatar of Bruno R.
    Bruno R.
    ·
    ·

    Hi Avi, thanks for following up with these details. It looks like your product specifications are quite structured, so you should be able to parse them out into individual columns using formulas. You should then be able to export the sheet with the parsed out columns to a CSV and then import it back to a google sheet. I recorded this video for you to show you how you can set this up: https://www.loom.com/share/15d41463e0f147408ed649a2521d245c?sid=3fc9fac2-2401-45a1-976b-e98a2fb97321 I hope this was helpful. If there's anything else I can assist you with, please let me know!

  • Avatar of Avi M.
    Avi M.
    ·
    ·

    Thank you Bruno! This looks like it might work

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

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

  • Avatar of Avi M.
    Avi M.
    ·
    ·

    Do you have the table that you made that on?

  • Avatar of Bo (.
    Bo (.
    ·
    ·

    Hey! Not at the moment, but I’ve pinged him, and he’ll get back to you once he’s back tomorrow. 😊

  • Avatar of Avi M.
    Avi M.
    ·
    ·

    Is there a way to create the formula that writes in separate columns simultaneously?

  • Avatar of Avi M.
    Avi M.
    ·
    ·

    Like in this table I want to write each image link to it's own column

  • Avatar of Bo (.
    Bo (.
    ·
    ·

    Hey, thanks for reaching out! 😊 Yes, you can do this by following these steps: 1. Use the “Extract values from data” feature. 2. Apply a custom extraction with a regex pattern like this: https://[^\s,"]+ (to extract URLs). 3. Ensure your data is separated by commas (,). I’ve already made the switch, so now you can have it as individual column values. You can also extract it into a new table using the “Write to table” integration. Here’s a quick video showing you how to extract a list of results into their own rows in a new table: Loom Video. Let me know if you need further assistance! 👍

  • Avatar of Bruno R.
    Bruno R.
    ·
    ·

    Hi Avi, apologies for the delay here. Here's the template of the table I built to test out your use, case. You should be able to import it into your workspace and copy the formulas directly: https://app.clay.com/shared-table/share_zDF6XA9u9DnW. I hope this was helpful. If there's anything else I can assist you with, please let me know!

  • Avatar of Avi M.
    Avi M.
    ·
    ·

    All good. Is the write to table a better way to do it ?

  • Avatar of LuisArturo
    LuisArturo
    ·
    ·

    Hey there Avi thanks for reaching out, while this may vary from person to person, I would say Write to Table would be the simpler method, due to not having to use a Regex pattern

  • Avatar of Avi M.
    Avi M.
    ·
    ·

    I'll do it your way bc i still cant figure out the write to table way lol