.png&w=3840&q=75){kind=logo}
How to Split Best-Selling Products into Separate Columns on a Website
is there anyway to split a websites 2 best selling products into product A and product B both on separate columns?
Tanvi R.··Hi Edmund, thanks for reaching out and welcome to Clay! There's likely a way to do this with Claygent in Clay. Do you mind sending the link to the table with the websites you are scraping so we can take a look? https://downloads.intercomcdn.com/i/o/1171717996/ac7729f84b426e1d0358af02/image.png?expires=1731085200&signature=e143dc32624692f9cba2de47ec56b8a650fac7a2396756f42d73e43d9da79172&req=dSEgF85%2FmohWX%2FMW1HO4zYTywSr8DpIU2BKsam%2FhVPvNqw%3D%3D%0A
- Tanvi R.··
Your approach looks amazing Edmund, great work here! I see you used Claygent and GPT to pull the most popular products and then sort them into Product A and Product B columns. Do you have any other questions here that I can help with?
How do i connect my google api key to clay? theres only gemini and google translate
- Tanvi R.··
Hey Edmund, which enrichment are you looking to use your google key for?
google shopping
and google doc api
- Tanvi R.··
Hi Edmud, here's a tutorial on how to connect your Google Sheets account to Clay as we have a native integration for this: https://www.clay.com/university/lesson/google-sheets-clay-101 For Google Shopping and Google Docs, you can use an HTTP API column as we do not have a native integration with them. Could you share more about what you're looking to achieve with these integrations?
look for best selling products in terms of $ revenue generated vs a quick search using gpt
- Tanvi R.··
Got it Edmund, in this case I'd actually recommend using Apify's Google Shopping Insights Actor to find insights on top products on google shopping. You can then pull this data into your Clay table using the Pull Data from Apify Actor table source and further enrich this information. Could you share the type of workflow you're looking to build with this information? Here's a tutorial on using Apify with Clay: https://www.clay.com/university/lesson/deep-dive-apify-actors-limitless-research Let me know if this helps!
Alex B.··This is impressive work. I'm blown away everyday by the stuff you can do in clay
