About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

Help with connecting Facebook Leads from Messenger to Google Sheet

Z
Userlevel 1

I am trying to send Lead information from Facebook Messenger into a Google Sheet. I am having issues getting the information out of messenger into the google sheet and am not sure what I need to do. When I select the form, it just has a messenger number whereas the messenger chat bot has a name in Facebook.

To clarify, from Facebook I am placing a Lead objective with a message template as a chat where a lead will give me name, ph number and email within the chat under custom fields. 

Can anybody send me to a link to help set this up correctly?

icon

Best answer by SamB 2 September 2021, 17:26

View original
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

M
Userlevel 4
Badge +9

Hi @Zesty,

Thanks for the question! 

Facebook Messenger has the following trigger available: https://zapier.com/apps/facebook-messenger/integrations#triggers-and-actions - New Message Sent to Page.  

To use Facebook lead information in your action, you may want to look at Facebook Lead Ads instead: https://zapier.com/apps/facebook-lead-ads/integrations#triggers-and-actions - the New Lead trigger would provide name, phone, email and other data from your leads once they complete.

The permissions for Facebook Lead Ads need to be just right to get that data into Zapier, and we have the steps described here: https://zapier.com/help/doc/common-problems-facebook-lead-ads

Hope this helps!

SamB
Rank
Userlevel 7
Badge +11

Just wanted to follow up here as @Zesty reached out to Support who confirmed that the we don’t get the chat bot names, only their IDs.

I’m sharing their suggestion here in case it’s helpful to others also looking to identify which form to select:

“Although it's not available in Zapier, you can have access the messenger IDs using this path Facebook > Publishing Tools > Forms Library. Once you have managed to find the ID of the form you would like to use, you can search for it in the Zap editor”

Terms & Conditions