en
en

Notion database items from new Google Form responses

Create Notion database items from new Google Form responses

8/10/20242 min read

To create Notion database items from new Google Form responses, you'll need to use an automation tool like Zapier, Make (formerly Integromat), or a custom script with Google Apps Script and the Notion API. Below are the steps for both Zapier and a custom script approach.

1. Using Zapier or Make

Zapier is a no-code automation tool that can connect Google Forms and Notion.

Steps:

  1. Create a Google Form: Design your Google Form with the questions you need.

  2. Create a Notion Database: Set up a Notion database with columns that match the questions in your Google Form.

  3. Connect Google Forms to Google Sheets:

    • In Google Forms, go to the Responses tab.

    • Click on the Google Sheets icon to link the form responses to a Google Sheet.

  4. Create a Zap in Zapier:

    • Trigger: Set the trigger to "New Spreadsheet Row in Google Sheets" when a new response is submitted.

    • Action: Set the action to "Create Database Item in Notion."

    • Map the Google Sheets columns to the appropriate fields in your Notion database.

  5. Test the Zap: Submit a test response in Google Forms and ensure it creates a new item in your Notion database.

  6. Turn on the Zap: Once the test is successful, activate the Zap, and it will automatically create Notion items from new Google Form responses.

2. Using Google Apps Script and Notion API

For more control and customization, you can write a Google Apps Script that triggers when a new response is submitted and then sends the data to Notion using their API.

Steps:

  1. Create a Google Form and Link it to Google Sheets (as in step 3 above).

  2. Enable Google Apps Script:

    • Open the Google Sheet linked to your form.

    • Go to Extensions -> Apps Script.

  3. Write the Script:

    • Write a script that listens for form submissions and then sends the data to Notion via an API call.

  1. Set Up the Trigger:

    • Run the setupTrigger function to set up the trigger for form submissions.

  2. Test the Integration:

    • Submit a response to your Google Form and verify that a new item is created in your Notion database.

  3. Deploy the Script:

    • Ensure the script is set up and running to automatically create items in Notion when new responses are submitted.

Conclusion

The Zapier approach is more user-friendly and faster to set up, while the custom script offers greater flexibility and control. Choose the method that best fits your needs.

PLUGGAI