Want to automatically add your Riddle quiz leads and their quiz responses to Google Sheets?
No problem. You can easily use our native Google Sheets integration – with no coding required.
What is Google Sheets?
Google Sheets is a powerful part of the Google Drive and GSuite package.
It’s one of the most flexible spreadsheet programs around – and for most users, easier to use and better than Excel.
Why save your quiz leads to Google Sheets?
Riddle’s online quiz maker fully supports sending leads to your Google Sheet account.
- Automatically sending your riddle’s leads and responses to a Google spreadsheet in real-time.
- Avoid the need to download your leads and upload to your favorite CRM or marketing software.
- For most folks, Google Sheets can be used for free with a Google Mail account.
Riddle 1.0 – saving your quiz leads to Google Sheets
Here’s where to find these options in any of your quiz, poll, or personality tests with Riddle 1.0.
- Save to Google: 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 is the most convenient option..
Video: Sending leads to Google Sheets (Riddle 1.0)
Are you using our legacy online quiz maker – Riddle 1.0?
This video is for you – it shows the steps to connect your Google Sheet to your 1.0 Riddle content.
Riddle 1.0: Setting up your Google <> 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.
Riddle 1.0: 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
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’
Troubleshooting your Google Sheets connection
Google’s API is a bit strict (due to security) – so you might occasionally see an error when you try to connect your quiz to a Google Sheet.
Here’s the most common error message we see from our quiz makers (read more info from Google):
- “success”: false,
- “error”: {
- “msg”: “The caller does not have permission”,
- “code”: 403
- }”
Why does this happen?
This message appears in our multi-user team account – when you try to connect a Google Sheet that is not shared with the same Google account that was connected to Riddle.
It’s for security – Google wants to make sure that only authorized people have access to your Google Drive documents.
For example, let’s imagine Bob and Sarah both belong to the same team or workspace in Riddle.
- Bob sets up a connection between Riddle and Google using his Google account: bob@gmail.com
- Sarah is creating a quiz in the same Riddle team as Bob. She uses Bob’s Google connection to save data to a Google sheet.
- She next tries to add a Google Sheet ID from a sheet created by her Google account: sarah@gmail.com.
- If that sheet is not shared with bob@gmail.com, she will get the error message shown.
How to solve this error
To fix this connection issue, we recommend these two options:
- Set up a new Google connection here: https://www.riddle.com/creator/integration/account
- IMPT: You need to use the same Google credentials for the Riddle Google connection, that you used for the Google Sheet you want to connect to your form.
- In our example, Sara would set up a new Google connection in Riddle – using Bob’s credentials.
- Or, just share your sheet directly with the same Google account (that you used to create the existing Google connection on riddle.com.
- In our example, Sarah could just share the sheet with Bob – inviting him as an editor.
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 hello@riddle.com.
Our whole squad of quiz geeks race each other to respond super quickly. 🙂
*********
Video transcripts
(We try to add a transcript for each of our help videos – Riddle is an accesssible quiz maker, and we like to make our blog accessible as well. Transcripts are easier for folks using screen readers or other devices.)