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
Hi
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:
+14Please provide screenshots of how you have your Zap steps configured.
Hi
The problem lies in the Steps 1 to 2, which then rollover to affect my Step 5.
+14Please include screenshots of how each Zap step is configured, thanks.
Hi
(have hidden some info as they’re confidential, but otherwise, the steps are configured as below)
+14The redacted info in the screenshots makes it hard to troubleshoot.
Without knowing what exact data points are missing on what Zap step we can only provide suggestions about what to troubleshooot.
Would need specific examples in order to help more.
Other things to check...
Perhaps put a filter step in place to check that required fields are being sent from FB Lead Ads.
When in doubt, test it out and follow the data trail to troubleshoot.
+8Hi
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:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
