Hi there,
I’m trying to transfer leads from LinkedIn conversation campaign to a Google Sheets, but the “Mappable answers” field, where all the answers comes in, is empty when mapping inside Make.
How can I get these “mappable answers” fields?
Thank you, everybody!
I just read and watched something about the use of “iterators” module. Is it the right way to start?
Hi @WEBK_SEO
You can directly map the email by expanding the “Mappable answers” section. To do this, click the small arrow next to it.
Regards,
Msquare Automation - Gold Partner of Make
Explore our YouTube Channel
for valuable insights and updates!
Hi Msquare!
There’s no arrow on this. So, after watching some explanations about bundles and collections, I put the “iterator” in the flow, and now I’m getting the “mappable answers” separated, but couldn’t receive in the Google Sheet yet.
How to map these out in the flow and get the answers in the sheet? That’s the question for me, now.
Thanks for your helping!
Hi @WEBK_SEO
Could you please share the output bundle of the linked in watch module.
To obtain the input and output bundles for each module:
This will allow you to download the necessary data for further analysis and sharing.
If you require additional assistance, please don’t hesitate to reach out to us.
MSquare Support | Book Live Implementation
Visit us here
Youtube Channel
Hello!
Of course, here it is:
[
{
"campaignUrn": "urn:li:sponsoredCampaign:318490953",
"formUrn": "urn:li:adForm:11270873",
"creativeUrn": "urn:li:sponsoredCreative:447757203",
"createdTime": "2024-07-24T03:34:24.390Z",
"accountUrn": "urn:li:sponsoredAccount:513928647",
"adFormResponseUrn": "urn:li:adFormResponse:f3ac6ea7-7a00-4cdd-99a6-4fbe6cbc3514-4",
"adFormResponse": {
"creative": "urn:li:sponsoredCreative:447751203",
"testLead": false,
"form": "urn:li:adForm:11270873",
"leadType": "SPONSORED",
"campaign": "urn:li:sponsoredCampaign:318420953",
"id": "urn:li:adFormResponse:f3ac6ea7-7a00-4cdd-99a6-4fbe6cbc3514-4",
"account": "urn:li:sponsoredAccount:51362847",
"hiddenFields": [],
"formName": "Form ADV",
"answers": [
{
"question": "urn:li:adFormQuestion:(urn:li:adForm:11270873,1)",
"questionId": 1,
"name": "Nome",
"title": "Nome",
"type": "Text Question",
"answer": "Raquel"
},
{
"question": "urn:li:adFormQuestion:(urn:li:adForm:11270873,2)",
"questionId": 2,
"name": "E-mail",
"title": "E-mail",
"type": "Text Question",
"answer": "raquel@xxxxxxxxxx.com.br"
},
{
"question": "urn:li:adFormQuestion:(urn:li:adForm:11270873,3)",
"questionId": 3,
"name": "URL do perfil do LinkedIn",
"title": "URL do perfil do LinkedIn",
"type": "Text Question",
"answer": "https://www.linkedin.com/in/raquel-segalla-xxxxx0b8b923"
},
{
"question": "urn:li:adFormQuestion:(urn:li:adForm:11270873,4)",
"questionId": 4,
"name": "Número de telefone",
"title": "Número de telefone",
"type": "Text Question",
"answer": "+55 47 999999-1009"
},
{
"question": "urn:li:adFormQuestion:(urn:li:adForm:11270873,5)",
"questionId": 5,
"name": "Custom question 0",
"title": "Há clientes suficientes para sua empresa crescer DENTRO da sua cidade?",
"type": "Multiple Choice",
"index": 0,
"options": [
"Sim, podemos crescer dentro da cidade",
"Não, preciso aparecer em mais cidades"
],
"answer": "Sim, podemos crescer dentro da cidade"
}
],
"consentResponses": [],
"submittedAt": "2024-07-24T03:34:24.390Z",
"mappable_answers": {
"Nome": "Raquel",
"E-mail": "raquel@xxxxxxxes.com.br",
"URL do perfil do LinkedIn": "https://www.linkedin.com/in/raquel-xxxxxx-1xxx8b923",
"Número de telefone": "+55 47 999999-1009",
"Há clientes suficientes para sua empresa crescer DENTRO da sua cidade?": "Sim, podemos crescer dentro da cidade"
},
"campaignName": "Adv > Leads > Form"
}
}
]
Please watch the loom Explanation.
Explore our YouTube Channel
for valuable insights and updates!
Hello @Msquare_Automation !
Thanks for your explanation, but LinkedIn module doesn’t work like that:
As I understand, we can only map this answers after actually receiving the answers, and then, send it to the sheet.
But thanks anyway. I really appreciate your help.
Thank you.
PS: The lead is coming into the sheet this way below, with each response in one line:
Hi @WEBK_SEO
We are really sorry for the confusion. The earlier loom explanation was missing out some points. I have created a new loom video here to get it resolved.
The points I mentioned in my loom:
Map the “mappable answers” variable in parse json module. parse json module shows us the variables we cannot access while mapping but they exist.
Map from parse json module as shown in earlier loom.
Copy the mapped variable somewhere and change the number of module from where you want to map.
Copy the variable now and paste in your field location. Now you can delete the parse json module.
Regards,
Msquare Automation - Gold Partner of Make
Book a Free Consultation | Connect Live
Explore our YouTube Channel for valuable insights and updates!
@Msquare_Automation thanks for your helping!!!
Hi @WEBK_SEO
Glad to know that your issue is resolved.
Regards,
Msquare Automation - Gold Partner of Make
Explore our YouTube Channel for valuable insights and updates!
