Hi, Is there a way to automatically ingest excel lead files attached to incoming Gmail directly into Clay tables? I see this is possible via Zapier as per documentation, but we don’t use the tool. Looking for alternate solutions.
For automatically ingesting Excel files from Gmail without Zapier, you can use webhooks to send data directly into Clay tables in real-time. [1]
Set up a webhook by going to Import > "Pull in data from a Webhook" in Clay, copy the webhook URL, then configure your email system to send data to that URL when Excel files arrive.
Alternatively, you can use Google App Script to automate the process - convert your Excel files to Google Sheets format and set up a script to send data into a Clay webhook table.
Before diving into the technical setup, I'd recommend trying our built-in AI tool Sculptor (top-right corner of Clay) - it can help you build the automation workflow quickly and it's free to use. Let me know if Sculptor helps or if you need more specific guidance on the webhook setup!
If you still need help with automating Excel file ingestion into Clay tables, I’m here to assist. Would you like to provide more details about your setup or any specific challenges you’re facing?
Let me try the google app script method and reach out for further assistance. Thanks! P.S I did try sculptor but the response was more towards zapier and did not get these suggestions.
Thank you for the update. Feel free to reach out whenever you need further assistance or have more questions about the Google App Script method or anything else related to Clay. I'm here to help.