Replygrow logo

Replygrow

Find leads

Reach out

Reply

Run many accounts and clients

Stay safe

All features
Pricing
Help CenterSearchImport a custom list from Google Sheets

Import a custom list from Google Sheets

Use a Google Sheet to import leads you collected yourself or exported from another lead tool. Each row is one prospect. You can also import a CSV file as a custom list.

Prepare your sheet

Add one column for each piece of information you need. Typical columns are:

  • first_name and last_name
  • email and phone
  • company
  • profile_url

The sheet must include a column named profile_url with each person's LinkedIn profile URL.

Example Google Sheet with first_name, last_name, company and profile_url columns

You can use this example Google Sheet as a template.

Share the sheet

Replygrow needs permission to read the sheet, so change its sharing settings first.

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

    Google Sheets Share button in the top-right corner

  2. In the dialog, click Change to anyone with the link and set the permission to Viewer.

    Google Sheets share dialog with link access set to Viewer

  3. Click Copy link and close the dialog.

    Google Sheets share dialog with the Copy link button

Import it into Replygrow

  1. Go to Search and click Create search.

  2. Choose Import Google Sheets list.

    Create new search with Import Google Sheets list selected and the Google Sheet URL field

  3. Paste the link into Google Sheet URL. Replygrow fills in a search name, which you can change. Click Next.

    Google Sheet URL pasted with the search name filled in

  4. On Match Google Sheet Columns, match each of your columns to a placeholder.

    Match Google Sheet Columns with first_name matched to First name

  5. Save. Replygrow processes the list and adds the leads.

Rows without a LinkedIn profile_url aren't imported.

Limits and tips

  • Matched columns override LinkedIn data. A column you match to a placeholder such as first_name or company_name replaces the value Replygrow gets from LinkedIn.
  • New columns become placeholders. Columns with unique names are added as new placeholders automatically.
  • Skip a column. Select Ignore this key next to it.
  • CSV works too. You can import a CSV file as a custom list.

Next step

Add the search to a campaign: on the Leads step, choose Existing Search list. See Create a campaign.