How to integrate Google Sheets – Notion bundle using Zapier?

Automate your workflow by linking Google Sheets with Notion using Zapier. Follow our simple guide to create seamless data transfers and improve efficiency in your daily tasks.

Creating a new Notion database when a new row on Google Sheets is created

A step by step guide for integrating Google Sheets – Notion bundle using Zapier

1. Google Sheets setup

• For this tutorial, we’re gonna create a table with the following rows:
  • Name
  • Email
  • Task
  • Date
• Fill the rows out with required information.

2. Notion setup

• Create a database on Notion with the required fields. For example:
  • Name -> type text
  • Email -> type email
  • Task -> type text
  • Date -> type date

How the integration works:

• A new row is created on a table in Google Sheets;
• Zapier creates a new row on the database in Notion.

1. Creating a Zap. On the “Home” tab, click on “Create””: 

2. Select “Zaps”.

Adding a Trigger for Google Sheets

3. To create a trigger on Zapier, click on “Trigger” button.

4. Select the trigger app (Google Sheets in our case)

5. Select the trigger event: In “Trigger Event” field, select “New Spreadsheet Row” (fig. 1) and connect your Google Account (fig. 2 & 3) Then click on “Continue” (fig. 4)

6. Next, fill out the required fields and click on “Continue”.

7. Next, test the trigger by clicking on the corresponding button

8. Next, the system will find and display the information requested. If everything is okay, click on “Continue with selected record”.

That’s how our data on Google Sheets looks like

Adding Notion as an action app.

9. Select the action app.

10. Select the action: In the “Action Event” field, select “Create Database Item” (fig. 1). Then connect your Notion account (fig. 2 &3). Then click on ”Continue”(fig. 4).

When connecting your Notion, select the page with the database and click on “Allow access”

11. Setup the action:

• Select the Notion database you want for the data to be sent to.

Connect your Google Sheets fields with corresponding fields on Notion. 

• Connect “Name” field on Google Sheets to the same field on Notion.

• Connect “Email” field on Google Sheets to the same field on Notion.

• Connect “Task” field on Google Sheets to the same field on Notion.

• Connect “Date” field on Google Sheets to the same field on Notion.

When you’ve done everything, click “Continue”.

12. Testing the integration

Click on “Test Step”, to test data transfer between Google Sheets and Notion.

13. If the test was successful, click on “Publish”.

14. Go to your Notion and check if the data was received.

15. If the data was received, click on “Transfer existing data” to transfer the remaining data.

16. Select the data that’s needed to be transferred, then click “Next” and then “Send data”.

17. Click on “Turn On Zap”. From now on, when you create new rows on the Sheets spreadsheet, data from them will be automatically transferred to your Notion database.