T
Tim Zhang
Right now, the inbound webhook cannot parse the column details from the lead form webhook from Google Ads. It parses everything else properly to map the sub-headings, just not the important stuff like FIRST NAME, PHONE, EMAIL, etc.
This is the sample payload from Google Ads:
{
"lead_id": "TeSter-123-ABCDEFGHIJKLMNOPQRSTUVWXYZ-abcdefghijklmnopqrstuvwxyz-0123456789-AaBbCcDdEeFfGgHhIiJjKkLl",
"user_column_data": [
{
"column_name": "User Email",
"string_value": "test@example.com",
"column_id": "EMAIL"
},
{
"column_name": "User Phone",
"string_value": "+16505550123",
"column_id": "PHONE_NUMBER"
},
{
"column_name": "City",
"string_value": "Mountain View",
"column_id": "CITY"
},
{
"column_name": "First Name",
"string_value": "FirstName",
"column_id": "FIRST_NAME"
},
{
"column_name": "Last Name",
"string_value": "LastName",
"column_id": "LAST_NAME"
},
{
"string_value": "Example answer",
"column_id": "what_type_of_tree_services_are_you_needing?"
}
],
"api_version": "1.0",
"form_id": 317442547680,
"campaign_id": 22404897829,
"google_key": "clickrdigital",
"is_test": true,
"gcl_id": "TeSter-123-ABCDEFGHIJKLMNOPQRSTUVWXYZ-abcdefghijklmnopqrstuvwxyz-0123456789-AaBbCcDdEeFfGgHhIiJjKkLl",
"adgroup_id": 20000000000,
"creative_id": 30000000000,
"headers": {
"host": "services.leadconnectorhq.com",
"cf-ray": "9be8f2217b73454f-ORD",
"x-forwarded-for": "192.178.15.1,10.10.1.21",
"cdn-loop": "cloudflare; loops=1",
"cf-connecting-ip": "192.178.15.1",
"accept-encoding": "gzip, br",
"cf-ipcountry": "US",
"x-forwarded-proto": "https",
"content-length": "904",
"content-type": "application/json",
"cf-visitor": {
"scheme": "https"
},
"user-agent": "Google-Ads-Notifications",
"x-envoy-external-address": "10.10.1.21",
"x-request-id": "3bf4adb3-c1e8-40a2-8866-d589191df16c",
"x-envoy-attempt-count": "1",
"x-forwarded-client-cert": "By=spiffe://cluster.local/ns/default/sa/default-automation-workflows;Hash=0d6e49a9aab5d0b610fb3aef36fcdf30411670fcf709a81ca10d83d4556868c0;Subject=\"\";URI=spiffe://cluster.local/ns/istio-system/sa/istio-ingressgateway-service-account",
"x-b3-traceid": "a6ef57e72e6a16f9f65a1ab266ec7f80",
"x-b3-spanid": "1c53db2a4b82dcc4",
"x-b3-parentspanid": "f65a1ab266ec7f80",
"x-b3-sampled": "0"
}
}