Apollo → Google Sheets
How to export Apollo contacts to Google Sheets
Short answer
Export the Apollo contacts with Scrupp, which finds work emails and phone numbers itself, download the list as CSV, and import it into Google Sheets with its own CSV import.
Step by step
From Apollo to Google Sheets
-
Step 1
Open your Apollo people search
Set the filters in Apollo’s People search as you normally would, or open a saved search.
-
Step 2
Click the Scrupp button
With the Scrupp Chrome extension installed, click its button on the Apollo results. Scrupp collects the people and finds emails and phones with its own lookup, so Apollo export credits are not used.
-
Step 3
Check the list in your workspace
The rows come back with name, title, company, LinkedIn URL and the work email and phone Scrupp found. Repeated people are flagged.
-
Step 4
Import the file into Google Sheets
Download the list as CSV, open a new sheet and use File → Import → Upload. Choose “Replace current sheet” for a fresh list or “Append” to add to one.
What is in the file
Columns you map in Google Sheets
Each row is one person. The export carries these columns, plus a few more you can leave unmapped:
- First name
- Last name
- Job title
- Company
- Company domain
- LinkedIn URL
- Work email
- Phone
Before you import
- Append adds rows without checking for duplicates. Sort by website or phone afterwards if you combine several exports.
- Test on ten rows first, open two or three records in Google Sheets and check the fields landed where you expected.
- The emails and phones in the file are the ones Scrupp found, not Apollo’s. Rows where nothing was found keep the person without a contact.
Scrupp also has a Google Sheets add-on with AI formulas for working on a list inside a sheet.
FAQ
Questions about Apollo to Google Sheets
Does this use my Apollo export credits?
No. Scrupp reads the people in your Apollo search and finds the emails and phones itself, so Apollo’s own export and reveal credits are not spent.
Does Scrupp have a native Google Sheets integration?
No. Scrupp exports CSV, Excel or JSON, and Google Sheets imports the file. Native pushes exist only for HubSpot and Pipedrive.
What does it cost?
Exporting a lead costs 1 credit, plus 1 credit when a work email is found and 2 when a phone number is delivered. Nothing extra is charged for contacts not found. The free plan gives 100 credits a month with no credit card.
Will every row have an email?
No. Across Scrupp exports a work email is found for 36.3% of people, and the share in your list depends on who is in it. Rows with nothing found are still in the file.
Google Sheets from other sources
LinkedIn to Google Sheets · Sales Navigator to Google Sheets · Google Maps to Google Sheets
Other places to send a Apollo list
Apollo to Airtable · Apollo to Close · Apollo to CSV · Apollo to Excel · Apollo to HubSpot · Apollo to Instantly · Apollo to lemlist · Apollo to Notion · Apollo to Pipedrive · Apollo to Salesforce · Apollo to Smartlead · Apollo to Zoho CRM
Tools for this export
Apollo scraper · Chrome extension · Google Sheets add-on · What costs no credits
Get your Apollo list into Google Sheets
Export it with work emails and phone numbers, then import the file.
No credit card