Overview
Pipl helps you find and add personal profile information to your email contact lists. With this spreadsheet integration for Google Sheets and Microsoft Excel, you can lookup name, address and contact information for a list of email addresses.
What you can do
With this integration, you can:
- Lookup name, age, gender, and addresses for a list of contacts
- Verify personal profile information for a list of contacts
- Enrich an email list with name, address and contact information
What you need
You need to have a Pipl account and your account's API key to use this integration. Also, if you haven't already installed the Flex.io add-on for Excel or Google Sheets, you need to set this up as well.
Functions and Syntax
This integration for Microsoft Excel or Google Sheets includes the following functions:
Pipl People Enrichment
Return a person's profile information based on their email address.
Syntax
=FLEX("YOUR_TEAM_NAME/pipl-enrich-people", email, [properties])
Sample Usage
=FLEX("YOUR_TEAM_NAME/pipl-enrich-people", "jeff.bezos@amazon.com") =FLEX("YOUR_TEAM_NAME/pipl-enrich-people", "bill.gates@microsoft.com", "first_name, last_name, birth_date")
Parameters
| Property | Type | Description | Required |
|---|---|---|---|
email |
string | The email address of the person you wish you find. | true |
properties |
array | The properties to return (defaults to all properties). See "Returns" for a listing of the available properties. | false |
Returns
| Property | Type | Description |
|---|---|---|
id |
string | The Pipl identifier for the person |
first_name |
string | The first name of the person |
middle_name |
string | The middle name of the person |
last_name |
string | The last name of the person |
full_name |
string | The full name of the person |
gender |
string | The gender of the person |
birth_date |
string | The birth date of the person |
mobile_phone |
string | The mobile phone for the person |
work_phone |
string | The work phone for the person |
address_house |
string | The house part of the address for the person |
address_street |
string | The street part of the address for the person |
address_city |
string | The city part of the address for the person |
address_state |
string | The state part of the address for the person |
address_zipcode |
string | The zipcode part of the address for the person |
address_country |
string | The country part of the address for the person |
Need help?
Have questions? Need help getting started? Need other Pipl templates or functions for Microsoft Excel or Google Sheets? Chat with us; we're happy to help!