Hi, I have started using Zapier a couple of days back. I use apollo for lead generation and I want to automate the process of getting data from Apollo and put it in a google sheets.
I have integrated both the apollo and zapier. That sheet that I have created in google sheets have all the fields that i want to be imported from apollo and bring it to sheets. All the headings are on top.
Now when I enrich the data in apollo from which I get the emails and domains and also linkedin of user and the company. I can clearly see all the details website, linked etc as per my requirements on apollo and on the downloaded sheets.
The problem occurs that when I check the google sheets where I want to data to be copied when the trigger “new contact created” hits, it should pull all of the details and bring in to google sheets.
Which in my case is not working, I can see the other details like name, and other fields but cant find the domain/website in Zapier field mapping.
Mapping of some fields from Apollo to Google Sheets is causing problems
+11- Zapier Solution Partner
Can you post a screenshot of how you have the fields mapped for the Google Sheets step.
Here are the screen shots of zapier and also the google sheet
This post has been edited by a moderator to remove personally identifiable information (PII). Please remember that this is a public forum and avoid sharing personal or potentially sensitive details.
+11- Zapier Solution Partner
In this field you’ve harded coded the text “Company LinkedIn URL coming from Apollo” instead of mapping a field - that’s why it’s showing that in the Google Sheet.
You need to map this field (and the Website one) with a variable value from Apollo like you did the other fields.
I couldnt find the fields in the mapping. As you can see in the screenshot that Domain value is false.
+11- Zapier Solution Partner
This likely means the domain value isn’t available to you from Apollo and therefore can’t be mapped.
Any solution for it? As I want to have a business web domain?
I can clearly see websites of the companies on the sheet that I have downloaded from apollo.
I have further tried to enrich it again in apollo to see the domain and refreshed the list and created new contacts but cant see anyting. Its the same
+11- Zapier Solution Partner
I'm a Zapier solution partner, so I'm happy to help you out:
https://zapier.com/experts/andrewjdavison
I sent you a DM.
+11- Community Manager
Hey there
Let us know if you still need any help. I’d be happy to lend a hand if you’re still stuck at all 🙂
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.