Home

Clay Announcements
Clay Support
Discuss Anything
Feedback & Requests
GTM Career Advice
Introduce Yourself
Member Spotlight
Share Content and Events
Share Full-time Jobs
Share Part Time Jobs
Share Tables, Tools, and Workflows

Community Guidelines

Explore Events
Learn Clay here
Clay Cup

Powered by Tightknit

Share Content and Events

How to Split Best-Selling Products into Separate Columns on a Website | Clay

Share Content and Events

How to Split Best-Selling Products into Separate Columns on a Website

·Nov 08, 2024 04:26 PM·

is there anyway to split a websites 2 best selling products into product A and product B both on separate columns?

12 comments

· Sorted by Oldest

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
Edmund E.
·
·
https://app.clay.com/workspaces/400882/workbooks/wb_rjGHbZfsggks/tables/t_B2dVVtpYg6ZY/views/gv_uQcf3nQTDRt3
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?
Edmund E.
·
·
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?
Edmund E.
·
·
google shopping
Edmund E.
·
·
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?
Edmund E.
·
·
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
Channeled
APP
·
·
Hi Edmund E.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: