This topic was automatically generated from Slack. You can find the original thread here.
how do I connect Facebook Lead Ads to my Airtable CRM via pipedream
To connect Facebook Lead Ads to your Airtable CRM using Pipedream, you can follow these steps: 1. Create a new workflow in Pipedream. 2. For the trigger, search for “Facebook” and select the “New Lead” trigger. You’ll need to connect your Facebook account and choose the Facebook Page and Form you’d like to receive leads from. 3. Next, add an action to your workflow. Search for “Airtable” and select the “Add Record” action. You’ll need to connect your Airtable account, and provide the Base ID and Table Name where you want to store the lead data. 4. Map the fields from the Facebook Lead Ads trigger to the corresponding fields in your Airtable CRM. Here’s an example of how the code for the Airtable action might look: export default defineComponent({ async run({ steps }) { const lead = steps.trigger.event; const fields = { "First Name": lead.field_data.find((field) => field.name === "first_name").values[0], "Last Name": lead.field_data.find((field) => field.name === "last_name").values[0], "Email": lead.field_data.find((field) => field.name === "email").values[0], // Map other fields as needed }; return await this.addRecord({ baseId: "your_base_id", tableName: "your_table_name", fields, }); }, }); Replace your_base_id and your_table_name with the appropriate values for your Airtable CRM. After setting up the workflow, new leads from your Facebook Lead Ads will be automatically added to your Airtable CRM.
Is this is the integration you’re looking for?
There was some progress on the integration, but I’ll check with the team to see the latest changes. Please feel free to comment on that issue as well to receive real time updates.
And just to clarify, only the pre-built actions and triggers are blocked, we have an API integration with Facebook Leads available:
mmm not exactly
let me see if I can find the link
I want to be able to post to the FB conversion API using pipedream, whenever a record in my Airtable CRM gets updated to reflect that a conversion happened
Understood, thanks for the background details.
Then you’ll need to craft the API request using your connected Facebook Leads account.
Do you know which specific Facebook Leads API endpoint that needs to be hit to record conversions?
https://graph.facebook.com/API_VERSION/PIXEL_ID/events?access_token=ACCESS_TOKEN
the variables in that URL are known to me
Great, so you can use your connected Facebook Leads account in a Node.js code step, or an HTTP request step in the workflow builder
can you show me how I can use a Facebook Leads API connected account in a Node.js code step to send a POST request to
https://graph.facebook.com/API_VERSION/PIXEL_ID/events?
Sure, here’s an example of how to use a connected Facebook Leads account in a Node.js code step to send a POST request to the Facebook Conversion API: import { axios } from "@pipedream/platform"; export default defineComponent({ props: { apiVersion: { type: "string", label: "API Version", description: "The API version for the Facebook Conversion API", }, pixelId: { type: "string", label: "Pixel ID", description: "The Pixel ID for the Facebook Conversion API", }, accessToken: { type: "string", label: "Access Token", description: "The access token for the Facebook Conversion API", }, eventData: { type: "object", label: "Event Data", description: "The event data to be sent to the Facebook Conversion API", }, }, async run({ $ }) { const url = `https://graph.facebook.com/${this.apiVersion}/${this.pixelId}/events`; const response = await axios($, { method: "POST", url: url, headers: { "Content-Type": "application/json", }, params: { access_token: this.accessToken, }, data: this.eventData, }); return response; }, }); Replace the apiVersion, pixelId, accessToken, and eventData props with the appropriate values for your use case. This component will send a POST request to the Facebook Conversion API with the provided event data.
thanks!
Sure, I would suggest opening a new step, clicking Facebook Leads and then Use any Facebook Leads API endpoint as a Node.js code step, that will autopopulate the access token from your account
The Pi code is close, but slightly off when it comes to passing the access token