Yes, you can import data from Google Sheets to Clay in two ways:
1. Manual import: Download your Google Sheet as a CSV file, then in Clay click "Create New" → "table" → type "CSV" → "Import from CSV" and upload your file.
2. Automated import: For enterprise users with passthrough tables, you can set up a Google App Script to send data to Clay using a webhook.
Note that you'll need Clay's Starter plan ($149/mo) to use the Google Sheets integration.
To create a Google App Script that sends data from Google Sheets to Clay:
1. Open your Google Sheet
2. Click "Extensions > Apps Script"
3. Paste the provided script code (which loops through rows and sends data to Clay via webhook)
4. Customize these parameters:
• maxRows: total rows to process
• Utilities.sleep(): time between row processing
• url: your Clay webhook URL
5. Run the function by clicking "Run"
Note: This method only works with passthrough tables (an enterprise feature) and is designed for single-column data.
.png){kind=logo}
