Now we need to filter the actions based on how far through the training they are and if they have done the quiz. Add in a Router step in Integromat.
On the top branch, we want to add in a route for if they have started the training, but haven’t completed it or done the quiz.
Add in an ‘add a row in Google Sheets’ module. You want to create a row in your spreadsheet that updates the name field with the firstname and lastname fields pulled through from the webhook. You also want to pull through the ‘Training progress’ variable and use this to populate the training progress column in your spreadsheet.
You will need to add in a filter on this branch that checks to see that ‘Training progress’ exists, that ‘Training progress’ does not contain completed and ‘quiz score’ does not exist.
We now need to add in an action for when they have completed the training but not yet done the quiz. Add in an ‘update row in google sheets’ module. You want to use the row number found when the search row module is called after the webhook module. You then want to update the training progress field with the ‘Training progress’ variable. It should look as shown below: