.png&w=3840&q=75){kind=logo}
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?
💤 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!
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!
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.
- Avi M.··
One idea is if I map all the necessary fields to each column and then I map it out
- 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!
- Avi M.··
Thank you Bruno! This looks like it might work
- Avi M.··
Do you have the table that you made that on?
Bo (.··Hey! Not at the moment, but I’ve pinged him, and he’ll get back to you once he’s back tomorrow. 😊
- Avi M.··
Is there a way to create the formula that writes in separate columns simultaneously?
- 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! 👍
- 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!
- Avi M.··
All good. Is the write to table a better way to do it ?
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
- Avi M.··
I'll do it your way bc i still cant figure out the write to table way lol