I have a list of data in table in Google sheet and I want the clay to automatically get that data in Clay when ever I add them in sheet how can I do so.
You can automatically sync data from Google Sheets to Clay using two methods: 1. Google Sheets Integration (requires Starter plan or higher): • Add the Google Sheets integration in Clay • Use the "Lookup, Add or Update Row" action with auto-update enabled • This syncs data between your Clay table and Google Sheet 2. Webhook Method (for Enterprise users): • Set up a Google Apps Script that sends data to Clay via webhook • The script can be configured to run periodically when new data is added • Enable auto-update in your Clay table to process incoming data automatically
How to setup webhook
To set up a webhook that syncs Google Sheets data to Clay: 1. In Clay, click "+ Create New" and select "Import data from Webhook" or click "+ Add" and search for "Webhooks" 2. Copy the generated webhook URL 3. In Google Sheets, go to "Extensions > Apps Script" 4. Create a script that: • Loops through your sheet data • Sends each row to your Clay webhook URL • Includes a delay between requests Note: This is an advanced method that works best with passthrough tables (Enterprise feature). For simpler integration, consider using the Google Sheets integration available on Starter plan or higher.