Yes, you can automate data import from Google Sheets to Clay without downloading/uploading CSV files. Use Google Apps Script to send data directly to a Clay webhook table.
Set up the automation by:
1. Opening your Google Sheet
2. Going to Extensions > Apps Script
3. Using a script to push data programmatically to Clay
This method works with passthrough tables (enterprise feature) and automatically sends new rows from your Google Sheet to Clay for enrichment.