Adding quiz leads and responses to Google Sheets
Google Sheets is a powerful part of the Google Drive and GSuite package – and is one of the most flexible spreadsheet programs around.
You can easily connect your Riddle quizzes with any of your Google Sheets – automatically sending all leads and answers to your trivia questions to a google doc in real-time.
Using Google Sheets as a Quiz Cache – Video walkthrough
We made this quick video guide to show you just how easy it is to connect your Riddle quiz to Google Sheets.
Why save quiz leads to Google Sheets?
Google Sheets as a quiz lead cache has a big advantage – it’s incredibly convenient because it avoids the need for manual downloads of all leads. It’s an easy-to-read spreadsheet with your quiz info online, and all in one place.
Instead, automatically send each lead’s personal information (name, email, etc.) and their answers to your trivia questions to your Google Doc.
No muss, no fuss – you get to skip having to download all quiz data as a spreadsheet.
Instead, the Google Sheets with test results will be constantly updated in real-time.
- For most folks, Google Sheets can be used for free with a Google Mail account.
- According to Google, storing data in Google Sheets is GDPR-compliant.
- This means you can safely store your lead data there and still be in compliance with the strict EU data privacy regulations.
- Make sure to follow the instructions from Google though, which includes signing a data privacy agreement with them.
- We’re not lawyers and things in the legal world change all the time. So please double-check that Google is still compliant with GDPR – and chat with your lawyer for their legal opinion.
Google Sheets as a Quiz Cache or ‘Save to Riddle’?
We have two ‘save to spreadsheet’ options – so which one is best?
Riddle is a fully GDPR-compliant quiz maker. We give you a full range of options to save your quiz takers’ personal data.
- Save to Google: Well, we just talked about that – your data will be saved to Google’s servers.
- Save to Riddle: Saves all leads and quiz data to Riddle’s servers. You’ll need to download the data manually.
The choice is yours.
For most users, using Google Sheets for the quiz cache is the most convenient.
‘Save to Riddle’ – manual process, but 100% EU-hosted data
However, if your organisation is EU-based, or very concerned about data privacy, you might prefer ‘Save to Riddle’.
In July, 2020 – there was an EU court ruling that made the US/EU Data Privacy Shield invalid. So storing personal data on cloud servers by US companies (like Google) could be problematic.
(Google still says they’re compliant – so it’s something you’ll have to decide for yourself.)
You can use either:
- Our webhook – send all data will be sent directly to your software (needs a bit of coding skills).
- Or, we recommend using our ‘Save to Riddle’ option.
It’s better from a GDPR perspective – as this way, all your leads’ personal information will go directly to Riddle’s servers in Luxembourg and Germany.
(That’s why we include this default text below for your users if you’ve selected the ‘save to Riddle’ option.)
Setting up your Google Sheets for Test Results <> Riddle connection:
1. Create a Google Sheet
- Name the columns for each piece of data you want to store from your Riddle.
- IMPT: Column names must start with a letter – Google freaks out and adds blank columns if you use special characters (ex. you should use Number, not #Number – as a column name).
- For example, imagine you wanted to store an email and a name from the lead form plus the test result.
- In this case, you’d type “Name” in Column A/Row 1, “Email” in Column B/Row 1 and “Testresult” in Column C/Row 1
2. Name the Google Sheet – this will save your sheet automatically.
3. Set up a Riddle quiz and include a Lead Form in the ‘Collect emails’ step.
Not seeing ‘Save to Google Sheets?’
If you don’t see the “Auto-save quiz leads and responses to any Google Sheet” option, you might have the “Save with Riddle” option activated.
Please disable the “Save with Riddle” option first.
To disable it, hover your mouse over the green “Save” card on the left and click the trash can icon as highlighted in the screenshot below.
4. Under Step 3: “Save” – select “Google Sheets”.
5. Click on “Login to your Google Account” to connect Riddle with Google – then follow the steps Google sends you through to authenticate your account.
(For technical reasons, Riddle needs permission to view and manage your spreadsheets in Google Drive. If you cannot grant that permission, alas you will not be able to use Google Sheets with Riddle.)
6. Copy your spreadsheet URL and paste it into the form on Riddle.
7. Does your Google Sheet has multiple tabs or worksheets? Select the correct worksheet in the dropdown on the right – then hit the blue refresh button.
8. Riddle will now display your column headers from row 1 of your sheet. You can now map data from your lead form or quiz as shown in the example below.
9. Once you mapped all fields, continue setting up your Riddle and hit publish.
10. IMPORTANT: We always recommend testing your connection to Google Sheets.
Go to the publish step, click the link – then run through your quiz a few times. Send a few demo leads through – just to make sure everything is working smoothly.
Mapping quiz question answers – and right/wrong to Google Sheets
You can also save the question answers – plus whether each user got each question right or wrong.
You can also take a look at our sample spreadsheet here – where we mapped our quiz lead data and quiz answers.
- Incorrect answers: show as ‘0’
- Correct answers: show as ‘1’
Any questions @ saving your quiz leads to Google Sheets?
There you have it – we hope you found this helpful.
If you run into trouble setting up your Google Sheets, please don’t hesitate to contact us via support chat or firstname.lastname@example.org… our whole squad of quiz geeks race each other to respond super quickly. 🙂