Step 1: Add Your List to Clay

• Use my Clay template -

Go to market with unique data — and the ability to act on it

• Add your niche prospect list — just Name, Email, and Company fields are enough.
• Clay will auto-populate:
  • LinkedIn profile
  • Podcast/Webinar appearances
  • SOC 2 certification status (and more!)
• All enrichments are pre-configured and work even on free trial.

Step 2: Export the Table

• Once Clay has enriched your list:
  • Click on “Export” → “CSV”.
  • Upload the CSV to Google Sheets.

Step 3: Set Up Gmail in n8n (Important)

• Before configuring anything in Sheets:
  • Connect the Gmail node in your workflow.
  • This gives permission to access Google Sheets.
• 📌 Without this, the Sheet node won't work.

Step 4: Configure the Sheet Node

• Open the n8n workflow

Niche_DB_Workflow.json

• In the Google Sheets node:
  • Select the Sheet you uploaded.
  • Verify the columns like name, email, company, certification.
• Update the messaging template if you want to tweak the tone or logic.