All blogs

Google Forms Notion Integration | Make Tutorial

Table of content

The Google Form to Notion automation is a simple way to collect answers from your Google Form and add them to your Notion database. In this tutorial, we'll use the automation app Make, which you can use for free.

TL;DR - Google Forms Notion Automation

  1. Create a Make account and create a new scenario.
  2. Add a Google Forms module, using "watch responses" as the trigger.
  3. Add a Notion module, using "create a new database item" as the action.
  4. Map all fields together.
  5. Schedule and activate the scenario.

Google Form to Notion

Before following the steps below, make sure you have a Notion database ready to accept the answers. Match all fields together, and also match the type of properties (date with date, checkboxes with multi-select, etc.)

1. Create a Make account

If you don't have one already, please create an account on Make. This automation app will allow you to connect both tools together so that we can transfer answers from Google Form to Notion.

2. Create a new scenario

Once you're logged into your Make account, go to the Scenarios tab, and click "Create a new scenario". Scenarios are the names of the different automations you'll create.

3. Add a Google Forms Module

Google Forms Notion Automation Initialization

Click the button in the middle to add a new scenario, and search for Google Forms. Then, select "Watch Responses". This is what will trigger the automation to run.

4. Setup Google Forms

Setup the Google Forms Module

In the connection field at the top, click "Add" to create a new connection. Make sure to select the Google account where your form is located.

In the "Form ID" field, you can either search for your form by its name, or you can directly input your form's ID. The form ID is the part of the form URL that comes after "d/" and before "/edit" (https://docs.google.com/forms/d/FORM_ID/edit)

Finally, set the limit, which is the number of answers the automation will process at once.

Before adding the Notion module, I suggest you fill out your form with dummy data, then click the "Run once" button at the bottom-left. This will ensure that you have sample data to facilitate the matching process.

5. Add a Notion module

Setup the Notion module

Once your Google Forms module is set up, click the "Add another module" button on the right side of the Google Forms module. Search for Notion and select the "Create a database item" action.

Using the same principle, connect Make to your Notion account, then search for your database name or input your database ID directly.

How to find Notion database ID
Source: Notion API documentation

Then, at the bottom, match all Google Forms fields to Notion fields. Make sure to select the correct values; you'll know which one to select because it will contain the sample data on its right (see below).

Google Forms Notion automation mapping fields

6. Run & Test the Scenario

Now that you've set up everything, answer the form again, and click the "Run once" button at the bottom-left. Then check your Notion database to make sure all properties have been filled correctly.

You can then define the time between each scenario run using the clock button at the bottom-left.

Finally, make sure to switch the scheduling from off to on.

Specific Fields

Google Form Checkboxes to Notion's Multi-select

If you have a checkboxes question in your Google Form (the one where the user can select multiple answers), there's an additional step to retrieve all choices into Notion's multi-select property. This is because the automation doesn't recognize the answer as a string, but as an array.

In your Make field, add the map() function — you can find it in the "Working with arrays" tab.

Make map() function

Before the semicolon, add the "textAnswers" option related to your question. After the semicolon, simply type "value.”

Google Form checkboxes to Notion multi-select

That's it! This will ensure that all selected choices from the Google Form appear in the multi-select field, and not just the first one.

Google Form multiple choice to Notion checkboxes

For Notion checkboxes to work, they need to receive either "Yes" or "No" as values. So when you set up your form, use a multiple choice question with option one being "Yes", and option 2 being "No". Simple as that.

Select & Multi-Select Length Limit

Lastly, make sure that all Google Forms answers going into a select or multi-select property in Notion don't exceed 100 characters. Otherwise, you'll get an error.

Conclusion

The Google Form to Notion automation provides a convenient and efficient way to collect responses from a Google Form and seamlessly integrate them into a Notion database. By following the steps outlined in this tutorial, you can easily set up the automation using Make as the automation app.

This process allows you to save time and effort by automating the transfer of data between these two platforms. Always better than typing everything manually!

Start now & create your Notion account 🙃
(#NotionPartner)
How can one integrate Google Form data into a Notion database?

You can integrate Google Form responses into a Notion database using an automation app like Make. Once you create a Make account and set up a new scenario, add google forms module using 'watch responses' as the trigger and add Notion module using 'create a new database item' as the action. Match all fields and then schedule and activate the scenario.

What is the limitation while using Google Form Multiple choices with Notion checkboxes?

While using Google Form multiple choice with Notion checkboxes, you need to ensure the inputs for Notion are either 'Yes' or 'No'. In your form, setup a multiple choice question with option one being 'Yes', and option 2 being 'No'.

What is the process to convert Google Form Checboxes to Notion's Multi-select?

In your Google form, if there's a checkbox allowing multiple selections, when automating to Notion multi-select, you would need to add the map() function in your Make field from the 'Working with arrays' tab to ensure all selections from the google form get recorded there, and not just the first one.

Latest posts

Master Notion, 5 minutes a week

Want to be in the loop with everything Notion? Join the 15,000+ Notioneers on the #1 Notion-focused newsletter.
Every Tuesday, I’ll hit you up with an email, giving you 3 tips on how to make the most of Notion, 2 (awesome) resources, and 1 Tweet of the Week.