Can data be pulled in from a google sheet?
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.
How do I create a google app script to send data to clay
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.