Hi there,
I have created custom variables that are based on Typeform responses. Is it possible to import them into Active Campaign as a field?
Best answer by Kosta
View originalHi there,
I have created custom variables that are based on Typeform responses. Is it possible to import them into Active Campaign as a field?
Best answer by Kosta
View originalHi
Hopefully that helps a bit!
Hi
The short answer is yes you can. You Crete the fields in ActiveCampaign first and then you connect Typeform, using the Apps feature on the bottom left hand corner on your ActiveCampaign screen, and when you’re in the process of doing that you can select the variables to import.
I have a quiz where I calculate the total score and 7 sub-scores and need to pass all 8 scores individually to ActiveCampaign. But, the problem is that none of the variables I’ve created in Typeform appear on the list viable to Active Campaign. So answers to questions can be passed but if you’re trying to pass the score of a quiz I too would like to know how to make this happen.
Any ideas
Cheers :)
So this actually is not possible. The only solution that I found was to export Typeform answers first to Google Sheets, and then set up the Google Sheets/ActiveCampaign integration, and import from Google Sheets to ActiveCampaign.
It is a messy solution, but it works.
Hi
Cheers :)
sorry if that is repetitious or seemingly pedantic but it is pretty straightforwad.
you then have the option to create additional tabs with ‘simpler’ field names and pull the data across to the second (etc) tab and then set up your integration to AC (or other tools) using the simpler field names.
hope this is a help and not noise.
des
Thanks
Thanks.
Hi
I am hoping to map the +score variable that is calculated in TypeForm into Active Campaign.
The idea is the be able to send certain email automations to people based on their score: if a person scores between 15-18 they get email #1. If they score 19-22 they get email #2. If they score 23-30 they get email #3.
When viewing the logs of the import from TypeForm to Active Campaign, I see the
"calculated":{"score":19},"variables":[{"key":"score","type":"number","number":19}],"definition":
My only issue is figuring out how to get each individual person’s score added into their Contact Profile. In the Field Map section the +score variable is not an option for a Field Source (see image below).
If anyone has any advice on the matter, that would be greatly appreciated!
Here is the link to the form itself for reference:
Hi
I tried the same thing attempting to export the scores to Active Campaign and I was given instruction to use Google Sheets then Zapier to get the data across to Active Campaign. This was a messy and at best hit and miss solution which isn’t sustainable. I have no solution creating a scorecard in Typeform so I used a differ to system all together much better suited to a quiz with a score (scorecard) that provides specific results and reports based on the range of the respondents score, eg. low, medium or high.
Connect Typeform to Google sheets. Data entries in Typeform are automatically pushed into sheets. Then, in stead of adding columns in the data entry sheet (cause this will not work with new entries), add a new tab, naming it for example ‘Adrenal Fatigue score 15-18’. Then, using the IF formula, extract data (name, email adress, etc) from the first tab with the original data entry, to the new tab (‘Adrenal Fatigue score 15-18’). E.g., only the contact information from respondents with adrenal score 15-18 will be shown in this tab. Repeat this for other scores, creating multiple tabs. Then, connect AC to Sheets.
In AC you will see the following steps:
step 1 - connect AC to sheets
step 2 - select spreadsheet
step 3 - select sheet
step 4 - subscribe to a list
This way, I believe you can send certain email automations to people based on their score.
I haven't used Zapier for this. It is a little work to create the Sheet (and excel formula are not my friends…..), but I believe I managed.
Hopefully this is helpful!
I found that I needed to use Zapier to make it work and then only sometimes. We need a solution that’s seamless without multiple steps and potential issues. It needs to be easy for everyone so we could make it work simply :)
I hope your solution works :)
Hi
There’s a quick fix that you can do here.
Simply get the typeform user to input your scores back into the typeform.
Let me explain….
Once you’ve calculated the scores, you can add it to a question and simply get the typeform user to write it as an answer again.
If you do this, the scores will be inputted as an ANSWER TO A QUESTION! 🎉
Then you can use that answer as a field.
You can see in the below question, is use @score in the question.
Then I get the typeform user to input @score into the “Type your answer here”
Below is a screenshot from my activecampaign account where you can see how I’ve added that as a field.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.