simmatrix / facebook-leads-google-sheets-integration

[DEPRECATED] Transfer Facebook Leads to Google Sheets in Realtime
46 stars 25 forks source link

Not working anymore because of Facebook required permissions #5

Open mchiz opened 11 months ago

mchiz commented 11 months ago

Hey! I have been using your script for a few months and it worked perfectly. However, a few weeks ago it started failing. I'm getting this error when I'm trying to create a test lead:

CRM access has been revoked from Lead Access Manager

and this is the advice to fix it:

Please make sure your CRM is added in the Lead Access Manager setting for the page (https://www.facebook.com/business/help/1440176552713521)

But I can't see how I can add my app as a CRM. Have you faced this problem?

mchiz commented 10 months ago

Update without the solution yet: it seems that now is required to be a verified business. I'm having problems to become verified.

For now, I'm trying to make work the new CRM integration "Google Sheets" (the one that is not from Zapier). It is providing me the leads that the form has already collected, but it is not updating the spreadsheet with the new ones.

I will come back with news.

mchiz commented 5 months ago

After more tried, it worked. The bad news is that I'm not sure how... if I have more news, I will come back to post them.

Rose2395 commented 5 months ago

Update without the solution yet: it seems that now is required to be a verified business. I'm having problems to become verified.

For now, I'm trying to make work the new CRM integration "Google Sheets" (the one that is not from Zapier). It is providing me the leads that the form has already collected, but it is not updating the spreadsheet with the new ones.

I will come back with news.

You do not need to have a verified Business Manager to setup a webhook or to receive leads in real time.

Rose2395 commented 5 months ago

After more tried, it worked. The bad news is that I'm not sure how... if I have more news, I will come back to post them.

This might be an issue with the Token that you were using. You can always check your token status here and it is life span.

lehieu76 commented 4 months ago

Does this script still work? I'm having trouble with the Approval issue

Rose2395 commented 4 months ago

@lehieu76 , Yes it does work. Can you be mor specific with the issue you are facing or post a screenshot of the error, so we can help you.

lehieu76 commented 4 months ago

@Rose2395 Thank you for your quick response! Because Facebook changed the interface, when I created the App I couldn't find the Start a Submission button

I had to go through a complicated process to get Approved

Can you make a short video to guide me?

Below is an image of what I'm having trouble with. Facebook asked me for the app URL and login account While pushing data via Google Sheet does not have a URL and Login?

image

image

Rose2395 commented 4 months ago

@lehieu76 , you do not have to verify the app. Which objective did you choose while creating the app? It should be other and then Business type. I can also make a video for you if that helps you.

lehieu76 commented 4 months ago

@Rose2395 I chose again and started on the right path However, I can't find the button Start a Submission

Please support me! image

Rose2395 commented 4 months ago

@lehieu76 , you do not have to do anything in the App review section. You only need to do the following in the app interface.

1- Go to App Setting then Basic. Provide contact email , privacy policy page of your website in the privacy policy url field, and choose Business and pages as category.

2- Go to webhook section and select page from the dropdown menu. Subscribe for leadgen field, and then click on edit subscription and provide google app script url.

3- On the top, enable the app mode from development to Live.

lehieu76 commented 4 months ago

@Rose2395 Thank you for helping me get on the right track!

Instruction 1: Go to the Add a Permission selection list, click on the subsection Events Groups Pages, then tick on the manage_pages checkbox Because Facebook changed the interface, I couldn't find manage_pages. Can I tick all? All available checkboxes are: pages_manage_cta pages_manage_instant_articles pages_show_list read_page_mailboxes pages_messaging pages_messaging_subscriptions page_events pages_read_engagement pages_manage_metadata pages_read_user_content pages_manage_ads pages_manage_posts pages_manage_engagement ads_management ads_read business_management instagram_manage_events

Instruction 2: Key in me/accounts to the text field beside the Submit button, and make sure you have pasted your long-lived user access token into the Access Token I only get blank data { "data": [ ] }

Please guide me. Thank you for your time!

image

Rose2395 commented 4 months ago

@lehieu76 , select your application from the first dropdown and then grant these permissions and generate access token pages_show_list ads_management ads_read leads_retrieval pages_read_engagement pages_manage_data pages_manage_ads

Then from the second drop down select user token and then again click on generate access token, you will see this window in this step

lead app example

Click on the edit previous setting and select the page you would like to connect with this app.

Now you should be able to see the page in the User or Page dropdown and your query should return the data.

lehieu76 commented 4 months ago

I'm really sorry for wasting your time. You have helped me go step by step and get closer to the finish line I have created the Access token Never Expires However, I am getting an error in Step 7 (photo below) Please help me!

image image

Rose2395 commented 4 months ago

@lehieu76 , did you manage to get your page in the User or page dropdown menu?

lehieu76 commented 4 months ago

@lehieu76 , did you manage to get your page in the User or page dropdown menu?

@Rose2395 I choose Page. Can you help me via Teamviewer, Anyviewer or Chrome Remote Desktop?

image

Rose2395 commented 4 months ago

I can help you on a google meet. Send me an email on this address mehroseyoc@gmail.com