WorkflowIcereach logo

Import a custom list from Google Sheets

Alexander Dahud
Posted by Alexander Dahud
Updated on November 1st, 2024

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

You can use this example Google Sheet as a preview.

Add Google Sheets to Replygrow

Once you fill your spreadsheet with prospects, you need to change visibility rights to enable Replygrow 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.

share google sheet

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

copy google sheet

4. Add the URL to Replygow 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.