I want to know how i can run a prompt using AI where i would want AI to run a search on the companies website to find out the product categories that the company specialises in and get the output for each category in a seperate column
You can just ask Claygent to do that for you. And then add a heading for column in 'define outputs' at the bottom. if you're struggling to get the prompt to do what you want, try asking chatgpt to write the prompt for you.