Clay Account Research Reports

Automation guide: Clay šŸ‘‰ Zapier šŸ‘‰ Google Docs šŸ‘‰ Slack

Hey, Claymakers!

Account research can take A LOT of time.

This is true for SDRs, Account Executives, and even Customer Success.

Itā€™s one of the most common inefficiencies that I hear from RevOps and Sales Leaders in weekly conversations.

Todayā€™s post goes into 1 way to deliver this info to reps in the form of automated research reports generated in Google Docs from Clay tables. (Including a Slack DM notification.)

The flow looks like this:

Letā€™s dive in.

But, first - if you arenā€™t using Clay yet, take advantage of my referral link that gives you 3,000 free credits when you signup for a paid account.

1. Build Account Research Table

This will be our data foundation that weā€™ll use to fill variables in the Google Docs template.

Iā€™ll be using a table that pulls in tech stack data and integrates with API Ninjas, pulls DNS records, and then analyzes the record for cloud hosting insights.

2. Build Google Docs Template

This will be a template that you reference within Zapier.

The variables like will ultimately map to columns in your Clay tables.

2 things to note here:

  • You must have a pair of curly brackets on each side

  • There canā€™t be any spaces such as

Mine looks like this (pardon my horrendous design skillsā€¦):

3. Setup HTTP API > Zapier

Part 1:

  • Put the method to PUT.

  • Input the Zapier API Endpoint that youā€™ll find in Zapier on the first step of the automation flow (more on that below)

HTTP API Example:

Part 2:

Now weā€™ll map the Clay columns to the variables that you setup in Gdocs.

This is a JSON format, so it goes as follows (be sure to add a comma in between each matching:

{ā€œVariableā€: COLUMN}

Tip: if a column doesnā€™t have data, youā€™ll want to flip the ā€˜requiredā€™ blue switch. This means that itā€™s not required to run. If you donā€™t have it flipped, then youā€™ll get a run error.

4. Zapier Workflow

Thereā€™s multiple setups in the wizard that guides you. But ultimately, you do the following:

  1. Send test data to the Zapier webhook

  2. Authenticate into Google

  3. Define the action event (in this case its ā€œCreate Document from Templateā€)

  4. Map data to the variables

  5. Test

  6. Then setup the Slack Direct Message so you get an alert to your report

5. The Flow & Example Report

Now when you run a row in your Clay table it will:

  1. Automate all your manual research

  2. Send that into Zapier

  3. Zapier creates a report

  4. Zapier sends you a Slack notification

Hereā€™s an example report:

Around the Kiln

What Iā€™ve been reading:

Clay University 2.0 Launches:

Yash Tekriwal, Head of Education at Clay, has been putting out some incredible enablement.

Check it out here: https://www.clay.com/university

Highlights from the 2024 SaaS Benchmarks Report:

Big fan of Kyle Poyarā€™s LinkedIn content and newsletter, Growth Unhinged.