Hey Ben - Yes, you can export your Clay data into Webflow CMS - Regarding the CSV method, I'm not that familiar with this but I've found these steps online that you can replicate.
First, create your Clay table with the data structure matching your intended Webflow CMS collection fields. Make sure the column names align with your Webflow fields.
Export path:
1. In Clay, export your table data as CSV
2. In Webflow, go to your CMS Collection
3. Use the "Import items" feature and map the CSV fields to your collection fields
For automation, use Webflow's API:
1. Create an HTTP POST enrichment in Clay using `https://api.webflow.com/collections/{collection_id}/items`
2. Add your Webflow API key in headers: Authorization: Bearer YOUR-API-KEY
3. Format the body to match Webflow's expected structure for your collection
Example:
{
"fields": {
"name": "${row['Title']}",
"slug": "${row['Slug']}",
"description": "${row['Description']}",
"_archived": false,
"_draft": false,
"author": "${row['Author']}",
"main-image": {
"url": "${row['Image_URL']}"
},
"post-summary": "${row['Summary']}",
"post-body": "${row['Content']}"
}
}
You'd need to replace the words like name, slug, description with the actual fields you want to send and then the value with the forward slash /
Note that Webflow has rate limits (60 requests/minute)
We also have a template here: https://www.clay.com/templates/auto-generate-personalized-landing-pages-for-all-prospects
