.png){kind=logo}
Exclude Blacklist Companies from Clay Table in Google Sheets
Hi if I have a google spreadsheet with companies on my blacklist, can I somehow exclude these companies from my clay table?
Hi if I have a google spreadsheet with companies on my blacklist, can I somehow exclude these companies from my clay table?
You can exclude companies from your Google spreadsheet blacklist when using the Find Companies source. First, import your Google spreadsheet blacklist into a Clay table. Then, when configuring the Find Companies source, use the "Exclude companies" option and select your Clay table containing the blacklisted companies. This feature allows you to exclude specific companies from your search results, similar to excluding existing clients.
how do I import my google spreadsheet into a clay table?
To import your Google spreadsheet into Clay: 1. Download as CSV: Export your Google spreadsheet as a CSV file 2. Import to Clay: • Click "Create New" → "table" → type "CSV" • Select "Import from CSV" and upload your file Alternative method: ** In your table, click "Actions" → "Import" → "Import from CSV" ** Upload your CSV file and map the columns For automation, you can set up a Google App Script with webhooks to automatically sync data from Google Sheets to Clay.
no without CSV. I want an automatic prozess. so that if I add companies to my blacklist on my spreadsheet they will automatically be added to my clay table
You can automate this using Google App Script with webhooks. Set up a Google App Script that sends data from your Google Sheets blacklist to a webhook table in Clay whenever changes occur. Here's how: 1. Set up webhook in Clay: Click "+ Create New" → select "Import data from Webhook" → choose existing table or create new one → copy the generated endpoint. 2. Create Google App Script: Use the webhook endpoint to automatically send new blacklist entries from your Google Sheet to Clay. 3. Enable auto-update: Your Clay table will automatically process new data coming through the webhook. This creates a live sync where adding companies to your Google Sheets blacklist automatically updates your Clay table without manual CSV imports.