.png){kind=logo}
Integrating Apify Scrape Results with New Clay Table: Options Explained
Can i feed Apify Scrape results directly into new clay table. or do i have to download it as CSV from apify then upload into clay
Can i feed Apify Scrape results directly into new clay table. or do i have to download it as CSV from apify then upload into clay
Yes, you can feed Apify scrape results directly into a new Clay table without needing to download and upload a CSV. We offer a native Apify integration that allows you to import data from Apify actor runs directly into Clay. To do this: 1. When creating a new table, select "Import data from Apify actor" as your source. 2. Connect your Apify account if you haven't already. 3. Choose the Apify actor you want to run. 4. Configure the input data for the actor. This integration simplifies your workflow by eliminating the need for intermediary steps. You can find this option under "other" in the Source Modal when creating a new table.
Was that helpful?
awesome
Glad to hear that!
Thanks! We've reopened this thread. You can continue to add more detail directly in this thread.
what would the input data be
When feeding Apify scrape results directly into a new Clay table, you'll need to provide input data in JSON format. This data specifies what the Apify actor will use for scraping. Here's what you need to do:
1. Select "Import data from Apify actor" when creating a new table.
2. Choose the Apify actor you want to run.
3. In the Input Data section, enter the data body in JSON format.
For example, your input might look like: LBKS{ "email": "[sam@clay.com](mailto:sam@clay.com)", "name": "Sam" }LBKSWhen using column tokens (dynamic data from your Clay table), keep the key in quotes, but don't wrap the value in quotes: LBKS{ "email": ##{{email field}}, "name": ##{{name field}} }LBKSThe specific input data required will depend on the Apify actor you're using.
Is that what you were looking for?
what plan do you need to have to run the Apify pull data intergration
Good news! The Apify pull data integration is available on all Clay plans. You don't need a specific plan to use this feature. It's included as part of our native integrations, allowing you to import data from Apify actors directly into Clay tables regardless of your subscription level. If you need any help setting up or using the Apify integration, feel free to ask for more details.
Was that helpful?
How do i keep updating the table with new apify scrapes.
To keep updating your table with new Apify scrapes, you have a couple of options: 1. Automatic updates: When setting up the Apify integration, don't specify a particular run as input. This allows your table to automatically update with data from subsequent future runs of the actor. 2. Enable auto-update: In your table settings, enable the auto-update feature. This will automatically run all columns when new rows are added or edited. 3. Manual refresh: You can manually trigger an update by clicking the Apify column header and selecting "sources". 4. Scheduled updates: The import is set to refresh every 24 hours by default. Remember to configure the "Autoupdate" setting when setting up the Apify integration to ensure new rows are automatically enriched when added to the table.
Is that what you were looking for?
I'm glad I could help. Let me know if you have more questions.
Thanks! We've reopened this thread. You can continue to add more detail directly in this thread.
How do i deduplicate by company name in clay
To deduplicate by company name in Clay, you have two main options: 1. Auto-dedupe: • Click the Auto-dedupe icon at the bottom right of your table • Select "Enable automatic deduplication" • Choose the company name column • Click "Save Changes" 2. Manual dedupe: • Right-click the company name column • Select "Dedupe" > "Delete Duplicate Row" Additionally, you can normalize company names before deduplication to ensure consistency. Use the "Normalize Company Name" function in the Tools section of the enrichment panel. If you need further assistance, you can request human help by clicking on "Talk to a person" in the chat.
Was that helpful?
.