<aside>

Prerequisites

• Clay account (Pro plan recommended)
• Google Sheets access
• SalesRobot account (optional for automation)
• Prospect list with LinkedIn URLs </aside>

👏 Clay Table Configuration

Step 1: Create Your Base Table

Import Your Prospect List

<aside>

Required columns:

Person LinkedIn Profile (LinkedIn URLs)

Company Name (current company)

First Name

Last Name

Title/Role

</aside>

<aside> 💡

Optionally: Use SalesRobot to export your prospect list as a CSV file.

You can pull from LinkedIn and Sales Navigator search URLs (Guide in the next page).

</aside>

Add Job Change Detection Columns

• Right-click → Add Column → Add Enrichment
• Select “Signals” → Job Change → Select prospect table

• Configure the LinkedIn job change enrichment
• Set date range to "Last 90 days" → Set frequency to “Monthly”

Step 2: Google Sheets Integration

Column: "Lookup, Add, or Update Row"

1. Add "Google Sheets" enrichment

1. Configure your target spreadsheet
2. Set up the lookup/update logic:

• Lookup column: Person LinkedIn Profile
• Update if found: Yes
• Add if not found: Yes
• Columns to update: All relevant fields

Column: "Data Added"

• Boolean field tracking successful exports