Learn how to set up and use the Zapier integration to automate the export of question submissions from your flipbooks to Google Sheets.
Note: For this to go smoothly, you need an Enterprise plan to add a question and integrate it with Zapier.
Step 1: Create the Flipbook and set up the quiz
Log in to your Flipsnack account and create a flipbook by uploading a PDF or creating it from scratch. Then, you must add a quizz and publish your flipbook, which can be found in Zapier. This article will guide you on how to add a lead form to a flipbook.
Step 2: Obtain your API key from Flipsnack
- Go to the main dashboard.
- Navigate to Settings, in the lower left corner.
- Click on Integrations.
- Locate the API key for Zapier specific to your workspace, click on the Copy icon, next to the code, to copy this key as you will need it for the next steps.
Step 3: Set up a Zap in Zapier
- Go to Zapier and create or log in to your existing account.
- Once logged in, click on Create Zap button in the top left corner and select Zaps from the newly opened dropdown menu.
- A new page in the editor will open. Click on the first step, called Trigger. In the search apps modal, type "Flipsnack" and click on the first result, as in the image below.
In the left panel, click on Trigger Event input, and a dropdown will appear with all the Flipsnack events. Choose New Quiz Data.
Click on the Continue button and move to the Account tab .
- When prompted, log in to your Flipsnack account. In the newly opened window, paste the API key obtained in Step 2 and click Yes, Continue to Flipsnack.
- Now click on the Continue button and move on to the Configure tab.
Here, you must select the flipbook to which you added the quiz in the step 1 and in the Quiz section you will the name of the quiz from the flipbook. If you can't find the flipbook it with the search function, you need to load more results by scrolling down until you see the Load more button.
Step 4: Choose a destination app - Google Sheets
- After setting up the trigger, you must select an app where you want the lead form data to be sent. For example, you can choose to connect with a Google Sheets to keep up with your quiz answers in real time.
Note: If you want to export your quiz submissions to a different CRM (HubSpot, SalesForce, etc.) you can choose from all the available apps in Zapier.
- Before clicking Continue, you need to make sure that you have the spreadsheet created and ready in your Google Drive, with the information you want to collect. Name the spreadsheet something easy to find and remember, as you'll need to locate it later.
Important: When formatting your worksheet, create column headers with the desired statistics you want to add, and assign titles such as ID, question one, question two, etc and Total score. Each statistic you want to track should have its own column. This setup helps Zapier map the data correctly, as shown in the image below.
- After selecting Google Sheets, on the Action event tab click on the dropdown menu. From the options that appear, choose Create Multiple Spreadsheets Rows.
- After that, move to the Account section where you will have to login to your Google account. Once logged in, click on Continue and move to the Configure tab. Here, you'll select your Google Drive, the specific spreadsheet, and the worksheet you want to use.
Step 4: Map the data
Next, under the Rows section, you'll need to map the column headers from your spreadsheet to the corresponding data fields. For instance, map the Name with the participant’s ID. Then, add their answers for each question in the corresponding fields (e.g., question one, question two). After that, total score to max possible score (here depends on how many questions you added).
Finally, double-check all entries, and click Continue to test it.
Next, in the Test tab, you can click Skip test or Test step. We recommend selecting Test step to ensure everything is functioning correctly. The test is successful if the green checkmark appears. Afterward, click Publish.
And this is how you can automate the flow of quiz data submissions from Flipsnack to your preferred third-party applications, improving your workflow efficiency.
More integrations
Additionally, you can set up contact form submissions to Hubspot or questions submission to Google Sheets, to centralize all information you need automatically.
And we're not stopping here! Would you like to export a particular event from Flipsnack to Zapier? Let us know by filling out this form.
Please contact us via live chat if you have any questions or suggestions.