In this workflow, you'll be able to:
- Send data from your CRM to Clay from a webhook
- Enrich company data using company domain and company LinkedIn URL as well as the people that were hired in the last 12 months
- Update rows in Google Sheets with company reports.
It's important to note that you will need to connect it to your own Google Sheet. To help you, here's the Google Sheet template that you can copy to your own workspace. Be sure to add your data to "Data Company."
This template utilizes a combination of data providers to find work emails, starting with personal emails. Here's how it works:
- Finds a person's professional profile identifier via their personal email
- From their profile, finds their current company and that company's domain
- Finds their work email using their name (from the newly found profile) and company domain
To find each of these data points, the template utilizes waterfalls – a powerful Clay feature that allows fetching data from multiple sources, providers, or databases with ease.
In this workflow, you can:
- Import a list of emails and extract and clean the company name
- Determine Google PageSpeed data based on the company domain
- If the website is slow, this recipe will analyze whether the page has a blog, the last post interval, and last post date
- Lastly, check for Google and Facebook Ads status
This workflow will help you:
- Identify a prospect's skills and personal interests based on their LinkedIn profile
- Suggest a gift for you to send based on their interests
- Provide a gift URL to show where you can purchase it
For detailed instructions on how to use this template, check out this Claybook