Import custom variables to Active Campaign

Hi @ianroderick, thanks for the update. So you set up an automated way to go from Typeform to google Sheets then Google Sheets to Active Campaign? When you say ‘export’ the data was this done manually?

@Gabi Amaral and @Liz is there a way to automatically export the results from once a quiz id completed  to Google Sheets then to another application?

Cheers :)

Thanks @john.desborough, appreciate the assistance. I’ve created a Google Sheet and added in some extra columns and also had Typeform send the data from previous responses and it populated the new Google Sheet … but upon running the quiz a few more times the google Sheet doesn’t update the new information. I feel stuck now as what was easy enough to set up isn’t working seamlessly.

@Liz and @Gabi Amaral is TF working on being able to provide the @score and @variable information as part of the integration? It seems pointless to have have a quiz that just stops with it and don’t allow seamless integration with other Apps like ActiveCampaign by providing all the data from the quiz. Having to use Google Sheets and then Zapier to connect with AC is very messy and time prone to errors as a number of systems are required to make everything work.

Thanks.

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:

@tayloredhealth4you I feel your pain my friend.

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.

@Kosta @tayloredhealth4you I read this post as I was looking for a similar solution (at least, I hope I understood you correctly). It seems to work this way:

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!

Hi @Kosta @ianroderick and @Liz!

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.