Google Sheets is a powerful part of the Google Drive and GSuite package – and is one of the most flexible spreadsheet programs around. And Riddle’s online quiz maker fully supports sending leads to a Google Sheet.

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.

Video: Sending leads to Google Sheets

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.

Pick ‘Google Sheets’ 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’.

Here’s why.

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
Setting up a Google Sheet for Riddle Quiz Maker

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.

Delete save to riddle option

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.)

Allow Google Access for Riddle Quiz Maker

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.

Riddle Data Mapped to a google sheet

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.

Always test your Google Sheets connection

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’

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):

Google Sheets error with connection
  • “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.

  1. Bob sets up a connection between Riddle and Google using his Google account: bob@gmail.com
  2. 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.
  3. She next tries to add a Google Sheet ID from a sheet created by her Google account: sarah@gmail.com.
  4. 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:

  1. 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.
  2. Or, just share your sheet directly with the same Google account (that you used to create the existing Google connection on riddle.com.
  3. In our example, Sarah could just share the sheet with Bob – inviting him as an editor.
Sharing Google sheets

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 transcript

(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.)

Hi there, my name is Mike and I am one of the co-founders here at Riddle, and today I’m really excited to show you how you can easily send all of your quiz leads and their quiz responses automatically to Google Sheets.

No downloads, no files to upload. It’s just an automatic process. It’s really cool. So first off, obviously, you’ll want to create a Riddle quiz or other format. And in this case, I’m just creating a just a quiz, with seven questions.

Next, what you’re going to do is pop over to Google Docs and just create a Google sheet – you’ll want to add a column for every field that you’re going to collect in your lead form. So in this case, first name, last name, email, but then you also need a place to store all their data from the quiz. I’m tracking – question one answer question one, did they get it right or wrong?

I’m going to ask for their total score. Did they get seven out of ten, eight out of ten? And the result title like, “Hey, you’re at low risk of cybersecurity” or “You’re at high risk”, things like that.

Next, I’m going to copy this you URL and then popover back to Riddle and go to the collect email step. Now here is just a quick form I’ve created. I’ve asked for first name, last name and email address.

You can also map fields like check boxes and things like that. And now I’m going to go down to the safe step. Now you might see that this has two options. So you have either the Google Sheets or the ‘Save to Riddle’.

In this case, we’re going to choose Google and I already set up my integration here. If you’ve not done that, you’ll just be asked to enter your username and password.

But I’m assuming everyone’s done that already. Now I’m just going to paste my spreadsheet URL from Google to here and you’ll see here, Google is like, OK, cool – here are all the columns from the spreadsheet.

All these columns are now here. Next you just go through and map the colums  to your lead form. So in this case, first name matches up with first name, last name with last name. And you might see here, this is actually a good segue. You see here this last name, it doesn’t say last name in this case. You’ll see here the field idea is coming up as short text and with a six digit number.

So I’ve just changed that. Let’s go back to here and let’s go remap this field. I’m going to delete this. And now you’ll see here that last name is actually showing up as last name.

OK, I’m next going to get email. And now for question one, I’m going to go down here and scroll and say, “For question one, I need their answer. And then did they get it right or did they get it wrong?” I’m going to use answer correctly.

True or false, I’ll do the same thing for question two. So again, their answer. And did they get it right or wrong?

And then finally, I’m going to choose from some of our result options. So I’m going to use the score. How many questions that they get, right? Or how many points did they get?

Plus, I’m going to use result title. So I’m just going to grab the score text and this is going to say, “Hey, you’re this type of person” and there we go.

If you want, you can also turn on double opt in, which will send out an email before that data is saved to Google. Your users will have to click that link. Some people like to do this just because it makes people take an extra step and say, “Yes, I am absolutely sure I want you to have my data”.

But there we go. I’m now going to click publish and I’m going to take the quiz.

So let’s go pop over to here. Just ignore that logo. That’s from a just a demo logo we use as a placeholder. And now I’m just going to go through here. I’m going to pause this video and quickly finish the quiz.

And I’m back. OK, so here we are. We’re on question seven of seven. I am going to click false. Got that correct.

Here’s the lead form. I’m just going to enter Santa Claus and Santa at Santa dot com just because that’s a nice, easy one to remember.

(So Santa, if you’re getting this email, I apologize.)

Click the checkbox then submit and you’ll see the results. So here we go. The score is four. Here’s the score text.

And let’s go over to Google Sheets. And here you go. You’ll see that name and email address I entered. I selected for question one, I got it wrong – we show a zero for ‘wrong’ answers, and a one for ‘correct’.

I got four points and there’s my result title.

So there you go. That is how you use Google Sheets with Riddle.

Just one last thing. You can also set up Google Sheets at the same time as MailChimp, AWeber, and ActiveCampaign – so you can have a spreadsheet and also send all of your data to your CRM tool. You can do them both at the same time.

OK, any questions? Please don’t hesitate to ask us on support chat.

Myself, my co-founder Boris, and all of our developers – well, we all race each other to answer quickly.

So seriously, any questions? Just ask away. We love to help.

Thanks so much. And Happy Riddling!

Leave a Comment

Scroll to Top