How to Create Notion Database Items from Google Sheets Using Pabbly Connect

Learn how to automate the creation of Notion database items from Google Sheets using Pabbly Connect. Step-by-step tutorial with clear instructions. This comprehensive guide reveals exactly how to connect your applications and automate repetitive tasks — accessible for professionals of all technical backgrounds.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for Integration

To create Notion database items from Google Sheets, you first need to set up Pabbly Connect. Start by signing in to your existing account or create a new one by clicking on the ‘Sign up for free’ button, which gives you 100 tasks each month for free.

Once logged in, navigate to the Pabbly Connect dashboard. Click on the ‘Create Workflow’ button on the top right corner. Name your workflow, such as ‘Create Notion Database Items from Google Sheets’, and save it in a folder named ‘Google Sheets to Notion’. This organization helps in managing multiple workflows efficiently.

2. Defining Trigger and Action in Pabbly Connect

In Pabbly Connect, the next step is to define your trigger and action. For this integration, your trigger application will be Google Sheets, and the trigger event should be set to ‘New or Updated Spreadsheet Row’. This means that every time you add or update a row in your Google Sheet, it will trigger the workflow.

• Select Google Sheets as the trigger application.
• Set the trigger event to ‘New or Updated Spreadsheet Row’.
• This will capture any new lead details added to your Google Sheet.

After setting up the trigger, proceed to the action application. Here, select Notion as your action application and set the action event to ‘Create Database Item’. This allows Pabbly Connect to create a new item in your Notion database using the lead details captured from Google Sheets.

3. Connecting Google Sheets to Pabbly Connect

To connect Google Sheets to Pabbly Connect, you will need a webhook URL. This URL acts as a bridge between Google Sheets and Pabbly Connect. Copy the webhook URL provided in the trigger setup and head over to your Google Sheets.

In Google Sheets, go to the ‘Extensions’ menu, select ‘Pabbly Connect Webhooks’, and choose ‘Initial Setup’. Paste the copied webhook URL into the designated field and set the trigger column. The trigger column should be the final column in your sheet, as it will indicate when to send the data to Pabbly Connect.

4. Adding Lead Details in Google Sheets

Now that your Google Sheets is connected to Pabbly Connect, you can start adding lead details. Each time you enter a new lead in a new row, ensure that you click on ‘Send on Event’ from the same ‘Pabbly Connect Webhooks’ menu. This action sends the data to Pabbly Connect, triggering the workflow.

• Enter lead details such as first name, last name, email, phone number, city, and inquiry form details.
• Remember to refresh the page after sending the event to capture the new data in Pabbly Connect.
• Check Pabbly Connect to see if the lead details have been captured successfully.

Once you’ve added the lead details, you will see a confirmation in Pabbly Connect that the data has been received. This indicates that your trigger is working correctly and ready to create a Notion database item.

5. Creating Database Item in Notion

With the lead details successfully captured in Pabbly Connect, you can now create a database item in Notion. Click on the ‘Connect’ button in the action setup for Notion. You will be prompted to allow access to your Notion account.

Select the relevant pages and allow access. Once connected, choose the database where you want to create the item. Use the mapping feature in Pabbly Connect to insert the lead details into the corresponding fields in your Notion database.

After mapping all necessary fields, click on ‘Save and Test Request’. You should receive a positive response indicating that the item has been created in your Notion database. Check your Notion database to confirm that the new lead item appears with all the correct details.

Conclusion

Using Pabbly Connect, you can seamlessly create Notion database items from Google Sheets. This automation saves time and ensures that your lead details are backed up efficiently. By following these steps, you can streamline your workflow and enhance productivity.