Today, we'll learn how to use RocketReach to research someone's email by using his name and company name stored in a Google Sheet and send an email using Sendgrid.
No Prerequisites but some content you might find useful :
Our workflow will look like this :
- Get the name and the company name of the new row added
- Make a request with RocketReach to retrieve the work email
- Send an email using Sendgrid
The Google Sheet contains information such as name and company name.
We want the script to run every time a new row is added. We'll add Google Sheet as Trigger. Set the mode to read and choose the sheet.
We'll use column_A for name and column_B for the company name.
With RocketReach module, we can easily find profiles for professionals. Lookup for a profile here will require name and company name.
We will work with Profile output. It contains the work email we are searching for.
To make it easier to send mail, we'll use the SendGrid module. Add it as a new step and let's configure it.
Configure it to Simple email mode and add the email you want to use to send mails. For the recipient and the message, we have Profile.email and Profile.name variables.
Now that's everything is build, switch on the Trigger. Now, if a new row is added, Wayscript will automatically run your script.