Skip to main content
Note: Sending an Assessment to Google Sheets with Zapier does not require a paid Google or Zapier account.

​
Test an Assessment

Note: Be sure to enable automatic grading for your Assessment to generate results.
To send Assessment results to an external source like Google Sheets, you first need to create an Assessment and enter test data for Zapier to collect. To create test data:
  1. Open the Contacts tab from the Dashboard.
  2. Select Assessments.
  3. Click the ellipsis … to the right of the Assessment you wish to test.
  4. Select the Preview icon.
Preview Assessment
  1. In Preview mode, complete and submit your Assessment. Your completed Assessment will create results for Zapier to collect when creating your Zap.

​
Create a Zap

Now that you have created test data, create your Zap using Zapier.

​
Create the Trigger

  1. In your Zapier account, click Make a Zap.
  2. Choose Kajabi as your trigger app.
  3. Select Assessment Completed as your Trigger.
  4. Click Continue.
  5. Then, select your Kajabi account.
Select Kajabi account See Use Zapier with Kajabi to connect your Kajabi Account.
  1. After connecting your Account, click Continue.
  2. Select your Site Name and Assessment Title.
  3. Click Continue.
  4. Then, click Test trigger to find data:
Test trigger Zapier will test the Trigger by pulling the data created previously.
  1. Click Continue after Zapier locates data from your Assessment test:
Data located If you receive an error message, learn how to troubleshoot Zapier.

​
Set up the Action

Before setting up the Action, create your Google Sheet. Learn how to work with Google Sheets in Zapier. In this example, we’ll send the Customer Name, Email, and Test Grade to a Google Sheet document named Assessment Results.
  1. Choose Google Sheets as your Action App.
  2. Select Create Spreadsheet Row.
  3. Then, click Continue:
Choose Google Sheets
  1. Connect your Google Account and click Continue.
  2. Skip the Drive field.
  3. Select the Google Sheet title in the Spreadsheet field.
  4. Select the Worksheet from the dropdown. If you have not changed the worksheet name in your Google Sheet, it will be Sheet1.
  5. After selecting the Spreadsheet and Worksheet, Zapier will pull the header titles you created in your Google Sheet. Proceed by matching each header title to the appropriate Kajabi data:
Match header titles
  1. Click Continue.
  2. Test your Zap by clicking Test & Continue.
  3. Testing your Zap will send the sample data to your Google Sheet. Check your Google Sheet to ensure your Zap has been set up correctly.

​
Turn on the Zap

After checking your Google Sheet, give your Zap a name and turn it on to begin sending Assessment results to your Google Sheet. Turn on Zap
Note: Assessments inside of Courses have been sunset. This feature may still appear in older accounts. Quizzes are available inside of Courses and Offers’ advanced functionality. Assessments can still be added to Web Pages.