Hi, I’ve automated a flow where lead files get parsed from email via Google Apps Script and pushed as Google Sheets into a dedicated Google Drive folder. As next step I want these files into clay tables for processing. Question: Can Clay automatically create a new Clay table every time a new Google Sheet is added to the folder via webhook?
Clay can't automatically create new tables for each Google Sheet, but you can set up webhook automation to send data from your Google Sheets into existing Clay tables. [1]
Here's what you can do: Use Google Apps Script to monitor your folder and send data from new sheets to a Clay webhook table. Each Clay table has a unique webhook endpoint that receives data via HTTP POST requests. [2]
The setup involves creating a webhook table in Clay (click + Add > Monitor webhook), then configuring your Google Apps Script to POST data to that webhook URL whenever new sheets appear in your folder.
This approach sends all your lead data into one Clay table where you can process and enrich it, rather than creating separate tables for each sheet.
Is that what you were looking for?
Unfortunately, I can't route all leads from different files into a single clay table. Its because of the further automation requirements.
I understand you need separate tables for each file. Unfortunately, Clay can't automatically create new tables via webhook - each webhook endpoint is tied to one specific table. [1]
Your options are:
1. Manually create multiple webhook tables in Clay, each with its own unique URL, then route different Google Sheets to different webhook endpoints
2. Try using Sculptor (our built-in AI tool in the top-right corner) to help automate table creation workflows
Could you try Sculptor first to see if it can help with your specific automation needs?
I tried sculptor but haven't got responses so end up asking for help here.
Got it. Unfortunately, Clay can't automatically create new tables via webhook - each webhook endpoint is tied to one specific table. [1]
Your best option is to pre-create multiple webhook tables in Clay, each with its own unique URL, then modify your Google Apps Script to route different sheets to different webhook endpoints based on your automation requirements. [2]
Since you need separate tables for different automation flows, you'll need to manually set up the webhook tables first (+ Add > Monitor webhook), then handle the routing logic in your Google Apps Script. [3]
Is that what you were looking for?
Gotcha.
Great! If you have any more questions or need further assistance with your automation setup, feel free to ask. I'm here to help.
I got one more question related to template. Lets say I build a workbook with all enrichment/ automation functions. Can I easily apply this template to each new table for quick processing without re-config?
Yes! You have a few options for templating your enrichment workflows:
Column Group Templates: Select multiple columns (hold ⌘/ctrl), right-click and "Save as template". This saves your enrichment sequence as a reusable template you can apply to new tables. [1]
Personal Table Templates: Duplicate your workbook and move it to a separate location. This keeps the table structure without data, so you can duplicate it when needed. Add "[Template Do Not Delete]" to the title to avoid confusion.
Workbook Sharing: You can also share entire workbooks as templates using "Share as Template" - this creates a shareable link that preserves table structure and relationships. [2]
The column group template approach is probably best for your use case since it lets you quickly apply your enrichment/automation setup to any new table without rebuilding everything from scratch. [3]
Is that what you were looking for?
Okay, will give this a try. Thanks for the help once again!
You're welcome! Take your time trying it out, and if you have any more questions or need further assistance, just let me know. I'm here to help.
