How to connect Facebook lead ads Google docs google sheets

Connecting your Facebook Lead Ads to Google Docs and Google Sheets can streamline your lead generation process and make it easier to manage and analyze your leads. Here's how to connect your Facebook Lead Ads to Google Docs and Google Sheets.

Connecting Facebook Lead Ads to Google Docs

1. Create a new Google Doc or open an existing one that you want to use to store your leads.

2. Click on "Tools" in the menu bar and select "Script Editor."

3. In the Script Editor, click on "File" and select "New Project."

4. Give your project a name and click "Create."

5. In the Script Editor, paste the following code:

function getFacebookLeads() {

  var accessToken = 'your_access_token';

  var formUrl = 'https://graph.facebook.com/v11.0/your_form_id/leads?access_token=' + accessToken;

  var response = UrlFetchApp.fetch(formUrl);

  var data = JSON.parse(response.getContentText()).data;

  var sheet = SpreadsheetApp.getActiveSheet();

  sheet.clear();

  sheet.appendRow(['Timestamp', 'Email', 'Full Name', 'Phone Number', 'City', 'State', 'Zip Code']);

  for (var i = 0; i < data.length; i++) {

    sheet.appendRow([

      new Date(data[i].created_time),

      data[i].field_data[0].values[0],

      data[i].field_data[1].values[0],

      data[i].field_data[2].values[0],

      data[i].field_data[3].values[0],

      data[i].field_data[4].values[0],

      data[i].field_data[5].values[0]

    ]);

  }

}

6. Replace "your_access_token" with your Facebook Access Token, and "your_form_id" with your Lead Ad Form ID.

7. Save the script and close the Script Editor.

8. In the Google Doc, click on "Tools" and select "Script Manager."

9. Select your script from the list and click "Run."

10. Your script will run, and your leads will be added to your Google Doc.

Connecting Facebook Lead Ads to Google Sheets:

1. Create a new Google Sheet or open an existing one that you want to use to store your leads.

2. Click on "Tools" in the menu bar and select "Script Editor."

3. In the Script Editor, click on "File" and select "New Project."

4. Give your project a name and click "Create."

5. In the Script Editor, paste the following code:

function getFacebookLeads() { var accessToken = 'your_access_token'; var formUrl = 'https://graph.facebook.com/v11.0/your_form_id/leads?access_token=' + accessToken; var response = UrlFetchApp.fetch(formUrl); var data = JSON.parse(response.getContentText()).data; var sheet = SpreadsheetApp.getActiveSheet(); sheet.clear(); sheet.appendRow(['Timestamp', 'Email', 'Full Name', 'Phone Number', 'City', 'State', 'Zip Code']); for (var i = 0; i < data.length; i++) { sheet.appendRow([ new Date(data[i].created_time), data[i].field_data[0].values[0], data[i].field_data[1].values[0], data[i].field_data[2].values[0], data[i].field_data[3].values[0], data[i].field_data[4].values[0], data[i].field_data[5].values[0] ]); } }

6. Replace "your_access