How to get a pivot table function on clay?

Clay doesn't have a traditional pivot table function, but we offer similar functionality through our Lookup integration and Write to Table feature.

For pivoting data between tables, use the Lookup integration which works like VLOOKUP in spreadsheets. You can also use Write to Table to transfer and reorganize data across tables - it's useful for parsing lists into rows or mapping columns between tables. [1] [2]

Both features require your Clay API key, which you can find in Settings > Account > API key.

Is that what you were looking for?

If you need any more help with using the Lookup integration or Write to Table feature, please let me know. Would you like to share more about what you're trying to achieve with pivot tables so I can assist further?