Hey there Neil thanks for reaching out, is there a particular table where you are working on this so that we can take a look.
This will require using Clays Webhook and HTTP API that allows people to connect to basically anything with an API.You can use a webhook to pull data into a Clay table and then our HTTP API integration to push it back out. Check out the docs for those here:
Import Data to Clay Using Webhooks | Clay Help CenterHTTP API with Clay | Clay Help Center