When a new data comes in from Facebook, I link in to Google Sheets via Zapier. But somehow, the data is not entirely translated into my Google Sheets (i.e. there’s missing data such as names). From Google Sheets, I link to ClickSend and Google Contacts. But there’s missing data in Google Contacts. It’s a chain effect and all these are via Zapier.
Hence, how do I solve this issue of missing data when I link FB to Google Sheets using Zapier?
Best answer by Liz_Roberts
Circling back here as I see you were in touch with Clint in Support and, in an effort to help other members who may have a similar question, want to share their response.
Hoping you’re squared away but if you have any additional questions, just reply back to the thread you had going wit Clint!
It looks like the issue here is that the Lead from the Facebook Lead Ads trigger that was used to build the Zap contained different field names than real live data does.
You can follow these steps to get the correct fields matched:
- Go to the Find Data step in the Zap trigger, open the dropdown, and click “Load More”
- Once you have a new Lead, go to your action step(s) and replace the fields that don't have any data with ones that do
- Test the Zap to make sure it's still working and turn it back on