Want to automatically add your Riddle quiz leads and their quiz responses to Google Sheets?

Automatically save quiz leads and quiz responses to Google Sheets with Riddle's online quiz maker
Send your quiz leads & their 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.

Google Sheets – easier to use 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.

Video: Sending leads to Google Sheets (Riddle 2.0)

We made this quick video guide to show you just how easy it is to connect your quiz from Riddle 2.0 to Google Sheets.

Sending your riddle leads & quiz responses to a Google Sheet

Choosing ‘Google Sheets’ or ‘Save to Riddle’?

We have two ‘save to spreadsheet’ options – so which one is best?

Choosing ‘Save to Google’ or ‘Save to Riddle’?
  • Google Sheets = more convenient – saving your quiz leads and responses to Google Sheets is definitely faster.
    • Every new leads automatically appears.
  • Data privacy = ‘Save to Riddle’ – if your data privacy teams are strict from a GDPR-perspective, you can use our ‘Save to Riddle’ option.
    • All your leads’ personal information will stay on Riddle’s servers in the EU, and not in the cloud with Google.
    • In July, 2020 – there was an EU court ruling that made the US/EU Data Privacy Shield invalid.
    • Storing personal data on cloud servers by US companies (like Google) could be problematic.

Choose both ‘Save to Google’ and ‘Save to Riddle’ – at the same time

Can’t decide?

You can also use both spreadsheet options with Riddle 2.0 – at the same time.

Save quiz leads to Riddle or save leads to Google Sheets
‘Save leads’ options with Riddle

Is saving leads to Google Sheets GDPR-compliant?

Riddle is a fully GDPR-compliant quiz maker.

We give you a full range of tools to save your quiz takers’ personal data – from our ‘Save to Riddle’ option to CRM tools like MailChimp to AWeber.

Review Google Sheet’s GDPR policies

If you choose our Google Sheet option, please review Google’s GDPR policies:

  • 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 – which includes signing a data privacy agreement with them.
  • We’re not lawyers and things in the legal world change all the time.
  • Please double-check that Google is still compliant with GDPR – and chat with your lawyer for their legal opinion.

Saving your quiz leads to Google Sheets (Riddle 2.0)

Creating a quiz in Riddle’s newest quiz maker – Riddle 2.0?

You’ll find our Google Sheet native integration under ‘Save leads’ in the ‘Publish’ step:

Connect your Google Sheet to your Riddle quiz maker account

You’ll need to authorize Riddle to connect with your Google Sheet account.

After that, you’ll see this handy ‘Test your integration’ pop-up.

Send test lead to your Save to Google Sheets integration with Riddle's quiz maker
Send test lead to Google Sheets

To save you time, we automatically:

  • Create a sheet in your Google Docs. It will have a title like Riddle: 35QoMRx7 (Riddle + <your riddle’s ID>).
  • Send a test lead to your Google Sheet.
    • You can see the test leads in your Google Sheet (see below)
Test leads sent to your Google Sheet with Riddle's quiz maker
Test leads sent to Google Sheets from Riddle

Once the lead comes through, your riddle will be good to go.

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.

Video: Sending your Riddle leads & responses to a Google Sheet (Riddle 2.0)

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

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.

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
Mapping your riddle’s lead fields to 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 Sheet connection

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

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.

Your Google Sheet must shared with the Google account integrated with 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 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.)

Sending quiz leads to a Google Sheet (Riddle 2.0)

Hi there, my name is Mike and I’m one of the cofounders here at Riddle.

And in this help video I’m going to show you how you can connect your quiz, personality test, poll, or survey built with Riddle 2.0 and send all your quiz leads and their responses to a Google Sheet.

And the genius of this is that it automatically updates with every new quiz taker. You will not have to download and re upload files of leads.

In Riddle 2.0, this will work in any of our interactive content formats, whether it’s a quiz, a personality test and so on.

I’m going to use a personality test as an example.

Once you are finished in the Create step, where you’ve added all of your quiz questions and answers and results, you’ll need to click on Publish and then click on Save Leads.

Now you’ll see here we actually have two ways to save your quiz leads. As a spreadsheet, we have a save with Riddle, which is our default option. It’s a little old school, but it’s very reliable and it’s a nice backup option to have. We will actually save all of your leads as a spreadsheet on Riddle servers.

You can at the same time, however, also use a Google Sheet integration.

And this is how you do it.

Just click on Add and you’re going to click on your Google account and allow permission to use this once this is set up.

And you’ll see here, I’m going to turn this on. Once you turn the switch, Riddle then goes off to your Google Documents account and creates a spreadsheet and sends you a test lead. I’m going to go click on ‘View leads’ – there’s a column for every single question, personality, result, basically every possible variable in your quiz, including a timestamp, which is kind of nice because it actually shows when that person took your quiz.

We’ll also automatically create a title which it says is Riddle + your quiz ID. You can of course rename it to be a little more descriptive.

That’s pretty much how easy it is to automatically send your quiz pull or personality test leads and their responses to Google Sheets.

If you have any questions, however, please do use our customer support. We take a lot of pride in being really fast to respond. So our entire product team, myself, my co founder, we all race each other to respond first.

If you send a message and we’re awake (we are based over in Europe, so do be aware of time zones), but if we’re awake, you’ll get an answer to your question within about two minutes or less.

That’s Riddle and our Google Sheet integration.

Any questions?

We look forward to hearing from you on support. All right, thanks again and happy riddling!

Sending quiz leads to a Google Sheet (Riddle 1.0)

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