WorkflowIcereach logo

Import a custom list from Google Sheets

Alexander Dahud
Posted by Alexander Dahud
Updated on November 7th, 2022

A Google Sheet is an online free spreadsheet program similar to Microsoft Excel.

You can use it to collect a list of people yourself or as an export from a lead collection tool.

Each row should contain information you need for a prospect you want to connect with or message, such as first_name, last_name, email, phone, company, and profile_url ...

Your Google Sheet should always include a URL to a user's LinkedIn profile named  profile_url.

See an example below:

search-gsheet-example

Add Google Sheets to Icereach

Once you fill your spreadsheet with prospects, you need to change visibility rights to enable Icereach to read it.

1. Click on Share in the top-right corner of your spreadsheet.

share

2. Wait for the dialog window to pop up and select the Change to anyone with the link button and set permission to Viewer.

image

3. Copy the link by clicking on Copy link and close the window.

copy

4. Add the URL to Icereach and click match placeholders.

run

5. Match placeholders so that the values you are importing can override the default ones from LinkedIn, such as first_name, company_name ...

If you add unique placeholders you don't need to match them they will be automatically set. If you wish to skip some of them you can set it to ignore this key.

test

6. Click save and the system will process the results

Need help?
Product demo?
Icereach logo

Icereach is a safe cloud-based automation platform that helps you generate more business from LinkedIn.

Icereach © 2022

Disclaimer: Icereach is not affiliated, associated, authorized, endorsed by, or in any way officially connected with Microsoft or LinkedIn, or any of their subsidiaries or affiliates. The name LinkedIn, as well as related names, marks, logos, emblems, and images are registered trademarks of their respective owners.