How to Create a Google Sheets-Notion bundle using Zapier
Andrey Boyko
CEO @ Glivera-Team ? Creating websites that sell ? WordPress developer ? ReactJS developer ? NextJS developer ? I do web animation that others can't
When we add a new line to the document, we create a corresponding sheet in the required category.
Let's create a new Zap and choose a platform from where our data will come from. In our case, it's Google Sheets.
Next, we need to select a trigger event, which will activate our bundle.
Select "New or updated spreadsheet row". After that, we connect our Google account, provide access, and select the desired table - sheet. Specify the trigger column, which will be used to add data to Notion; in our case, it is Title.
Next, we run the test, and Zapier finds the data we need, which we have previously added to the document.
Click "Continue" and then select the platform where our data will be transferred to - Notion. We also need to specify the event that will occur when data is added to our Google Sheets document. (Create page)
Next, we connect our Notion account and provide the accesses.
Select the data from the table that will be passed to Notion. They have already been pre-defined in the document.
Click "Continue" and complete the test.
After we get the message that the test was successful, go to Notion, open the page, and see that our data has been transferred.
Setting up the Google Sheets - Notion combination is complete.