Automatically Import Meta Leads from Google Sheets to Clay Table

Tobia D. · 2025-07-31T07:33:33.873Z

hey guys - I want to import Meta campaign leads into Clay. They currently are in a google sheet where they're automatically added to once they're acquired. How can I add them automatically to a clay table from sheet?

Automatically Import Meta Leads from Google Sheets to Clay Table | Clay

Clay
APP
·
·
To automatically import your Meta campaign leads from Google Sheets to Clay, use Google Apps Script with a webhook: Setup: 1. In your Google Sheet, go to Extensions > Apps Script 2. Create a script that monitors for new rows and sends data to Clay via webhook Alternative method: 1. In Clay, click + Create New > "Import data from Webhook" 2. Copy the generated webhook endpoint 3. Use the endpoint with your Google Apps Script to automatically push new leads Full instructions are available in our webhook guide.
Sources: Send Data from Google Sheets to Clay Using a Webhook Import Data to Clay Using Webhooks
Ahtasham H.
·
·
There is an option in clay enrichment to import data from Google sheet
Clay
APP
·
·
To automatically add Meta campaign leads from your Google Sheet to Clay, use Google Apps Script with a webhook: Setup Steps: 1. In your Google Sheet, go to Extensions > Apps Script 2. Create a script that monitors for new rows and sends data to Clay via webhook 3. In Clay, create a webhook table to receive the data The Google Apps Script will automatically detect new leads added to your sheet and push them to your Clay table in real-time. Full instructions are available in our webhook guide. Are you familiar with setting up Google Apps Scripts, or would you prefer step-by-step guidance for the webhook configuration?
Source: Send Data from Google Sheets to Clay Using a Webhook
Tobia D.
·
·
do I need a specific subscription for webhooks?
Tobia D.
·
·
it's not letting me create one
Clay
APP
·
·
No, webhooks are free to use. They're available on all paid plans starting with the Starter plan. You can create webhook tables to automatically receive data from external sources at no additional cost.
Sources: Import Data to Clay Using Webhooks Webhooks in Clay | Documentation | Clay University Clay Plan Feature Overviews
Clay
APP
·
·
To create a webhook table in Clay: 1. In a workbook, click + Add at the bottom 2. Search for Webhooks and click Monitor webhook Alternatively: 1. On your Clay home page, click + Create New 2. Scroll to "Other" section and select "Import data from Webhook" Webhooks are available on all paid plans starting with Starter. If you're still unable to create one, you may need to upgrade your plan or there could be a technical issue.
Sources: Webhooks in Clay | Documentation | Clay University Import Data to Clay Using Webhooks Webhooks in Clay | Documentation | Clay University
Ahtasham H.
·
·
No not any subscription need to use webhooks
Tobia D.
·
·
this isn't working - can you guys please help?
Tobia D.
·
·
https://app.clay.com/workspaces/275886/workbooks/wb_0t096u3Q8toi9xkaYjF/tables/t_0t096ueoDtfWwodeGjw/views/gv_0t096uecVF3zCdteBAP
Tobia D.
·
·
Clay S.
Tobia D.
·
·
Hasnain R.
·
·
Use Clays Google Sheets sync: In Clay click + New Table choose Google Sheets as the source. Connect your Google account and select the sheet with your Meta leads. Clay will auto-sync new rows as they’re added no manual upload needed. That’s it your leads will flow into Clay in real time.
Sayli G.
·
·
Hello Tobia! Thanks for reaching out! I clicked on the table but it says the table has been deleted. Did you try recreating it in another table? I can see you solved the webhook issue which is great!
Tobia D.
·
·
Hi yes - but I had to upgrade my plan (which frankly I really didn't want to at this stage : ))

17 comments