How To Integrate Apollo io with Excel

‍

‍

Apollo io integrates with Microsoft Excel via Zapier to automatically add new Apollo contacts, accounts, or enriched leads as rows in your Excel spreadsheets. Here's the complete step-by-step guide:

‍

1. On your Zapier main dashboard, click Create Zap.
2. Click on the Trigger button, and choose Apollo as your trigger app.
3. Make sure that your Apollo account is signed in. If not, click on the Sign In button.
4. In the pop-up window, enter the API Key and Name, then click Continue.
5. To get your API Key, go to your Apollo main dashboard, click 'Settings', then select 'Integrations'.
6. In the Integrations section, scroll down to locate the API option and click on it.
7. Click the '+ Create new key' button in the upper-left corner, personalize your API key, then click the Create API Key button.
8. Copy your newly created API Key and paste it into the pop-up window. Click Done.
9. Click Trigger Event, and choose "New Contact," and test it to pull in sample data.
10. Once everything is confirmed, click Continue with selected record to confirm the trigger works.
11. Click Action to set up what happens next in your workflow.
12. Search for and select Microsoft Excel as your action app.
13. Connect Excel account - click Sign In and authorize OneDrive access.
14. In the dropdown list under Action event, select Add Row to automatically append new contact data to your spreadsheet.
15. After successful configuration of your trigger and action data, hit Publish to activate your Zap and start automating contact imports.