How to create a Notion database from a Google Form

By Jake Marsh · Updated

To create a Notion database from a Google Form, open the form, choose Add-ons > Formshelf for Notion > Send responses to Notion, connect Notion, and under Choose a Notion database click Create a new one from this form. Pick the Notion page to put it on, name it and click Create database. Formshelf makes one property per question, of the right type, already matched, so you can click Turn on and responses start arriving as pages.

Steps

  1. Share a Notion page with Formshelf first. The new database is created inside a page the connection can see. When you connect, tick that page, or add Formshelf under Connections on the page in Notion.
  2. Open your form in Google Forms and choose Add-ons (puzzle piece icon) > Formshelf for Notion > Send responses to Notion.
  3. Click Connect Notion and finish the Notion sign-in.
  4. Click Create a new one from this form.
  5. Under Put it on this Notion page, pick the page. If the list says no pages are shared yet, go back to step 1.
  6. Type a Database name, such as "Event registrations", and click Create database.
  7. Check Match questions to properties. Everything is matched already; this is where you'd set a fixed value, like a Status, once you add one in Notion.
  8. Click Send a test page, look at it in Notion, then click Turn on.

How questions become properties

Google Forms questionNotion property
Short answerText, or Email, Phone or URL when the question's title says so ("Email", "Phone", "Website")
Paragraph, time, duration, gridsText
Multiple choice, dropdownSelect, with the choices as options
CheckboxesMulti-select, with the choices as options
Linear scale, ratingNumber
Date, date and timeDate
File uploadFiles, with links to the uploaded files

Formshelf also adds Submitted (the date and time), Edit link, Response ID and, when the form collects emails, Respondent email. The Response ID is how an edited response finds and updates its existing page.

After creating it

  • Add your own properties in Notion, such as Status, Owner or Notes. Then reopen Formshelf and give Status a fixed value, like "New", under the mapping. Edits to a response never reset it.
  • Add views: a board grouped by a select question, or a calendar on a date question.
  • Bring in old responses with Send past responses. Responses already in Notion are skipped.

Changing the form later

If you add a question to the form, reopen Formshelf, add a matching property in Notion and match it. If your Notion database has properties the form doesn't ask, Add form questions for Notion properties nothing fills yet adds them to the end of the form for you.

What it costs

The free trial covers 100 responses or 14 days, whichever comes first. Then $8 a month or $69 a year. Install from the Formshelf for Notion page.

Formshelf for Notion

Every Google Forms response becomes a Notion page, with every answer in the right property $8 a month or $69 a year per Google account.


Questions

Can I use a Notion database I already have?

Yes. Pick it under Choose a Notion database, or paste its link, and match questions to its properties.

Why can't I see any pages to create the database on?

The connection only sees pages you shared with it. In Notion, open the page, choose Connections from its menu and add Formshelf.

Does it copy the form's sections or branching?

No. Each question becomes a property. Sections and branching stay in Google Forms, where they work.

Can I rename properties after creating the database?

Yes. Formshelf matches by property ID, so renaming a property in Notion doesn't break the mapping.


More Formshelf for Notion guides


More Google guides