Home

Clay Announcements
Clay Support
Discuss Anything
Feedback & Requests
GTM Career Advice
Introduce Yourself
Member Spotlight
Share Content and Events
Share Full-time Jobs
Share Part Time Jobs
Share Tables, Tools, and Workflows

Community Guidelines

Explore Events
Learn Clay here
Clay Cup

Powered by Tightknit

Can data be pulled in from a google sheet?

·

·

Can data be pulled in from a google sheet?

Can data be pulled in from a google sheet? | Clay

3 comments

· Sorted by Oldest

Channeled
APP
·
·
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.
Sources: Google Sheets [Clay 101] - Clay University Google Sheets [Clay 101] - Clay University
Sarah C.
·
·
How do I create a google app script to send data to clay
Channeled
APP
·
·
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.
Source: Send Data from Google Sheets to Clay Using a Webhook