Steps to Use Notion with Gmail and Google Sheets using Apps Script?

Google Sheets can be a fast and easy way to store and retrieve data. Notion is an online word processor that helps you collaborate with others, organize your ideas, and share documents in real time. You can create a document in Notion using Gmail, but you’ll need to install the Apps Script integration first. This article will go over how to use Notion with Gmail through Google Apps Script (GAS).

Step 1: Create a new spreadsheet and connect it with Gmail.

Click on the File menu at the top left of your screen, then click New.
Next, select Spreadsheet under “Spreadsheets” in the left column, then give your document a name and click Create.

Step 2: Create a new script in Apps Script and copy and paste the code below into the editor window.

In the Google Sheets editor window, click “New Sheet.”

In the Apps Script editor window, click “Create” and then choose Blank Project.

Paste these lines into your new script:

var MAX_INDEX = 100; // The maximum number of emails to load at once. If you have more than this many emails in your Gmail account or have old ones that you don’t want loaded yet (because they’re not relevant), increase this number accordingly

var NOTION_KEY = ‘insert_your_notion_key’; // This is what allows Notion to access Gmail data via its API

function onEdit() {

In this function, we are getting the email message that was just edited.

We will then use this information to create a new spreadsheet and add a row for each column in our original spreadsheet.

//get the email message that was just edited

To get the email message that was just edited, add the following code.

The result should be the original message you saw in your Gmail inbox.

var message = gmailApp.getSelectedMessage();

The code below will get you started with the basics. The first line is var message = gmailApp.getSelectedMessage(); This line creates a variable named message and then assigns it to the result of calling the getSelectedMessage() method on your Gmail App object, which has been stored in gmailApp.

Next you’ll want to add some logic so that when someone clicks on an email in their inbox, we can read its contents and insert them into Notion. To do this we need to add another script block below our previous one:

var subject = message.getSubject();

var body = message.getBody();

var content = message.getBody() ;

You can use the getBody() method to get the content of the email. The getBody() method returns a string, not a list.

The getBody() method returns the plain text of an email message.

//create a new row in notion with a title, link, and description fields

To create a new row in Notion, you must use the _createRow() function. This function requires three parameters: title , link and description .

The title field is used to store the name of your document or spreadsheet. The link field contains a URL that points to an external webpage (e.g., http://www.google.com). Finally, description contains text describing what the document/spreadsheet does (e.g., “This is my first document”).

Once we’ve created our row object with these three fields inside it, we can add them as children of our Google Sheets document by using _addChild() .

var row = notionApp.createNewRow(title);

The first step is to create a new row. This is done by invoking the createNewRow() method of the notionApp object, which represents the Notion app instance (we’ll talk more about this in a bit). The first argument of this method is title, and it expects you to pass in a string value representing your new row’s title. You can use any name you want for your titles–it doesn’t have to be unique across all of your documents!

The second argument url specifies where people should go when they click on this link; if this field is left blank, then no external URL will be opened when someone clicks on it. If you specify an external URL here (like “https://example.com”), then Google Sheets will open that page instead of loading up another tab within itself like most browsers would do when clicking an external link without any parameters specified in its query string (e..g https://examplecom).

row[‘url’] = “https://docs.google.com/document/d/” + subject;

The URL field is used to create a link, which is then automatically added to the spreadsheet.

Notion is a powerful tool that can help you organize your emails, create spreadsheets and more. The best part? It’s free to use! If you’re looking for a way to add some organizational power into your Gmail account, look no further than Notion.

This is a great way to make use of your Gmail messages and Google Sheets. You can create new rows in Notion with the title, link and description fields from your email message or spreadsheet. This allows you to quickly add new content into your project without having to switch apps or copy/paste information manually.

Outline of the Article:

I. Introduction

Introduce Notion as a popular productivity tool and its integration capabilities.
Explain the importance of integrating Notion with Gmail and Google Sheets for streamlined workflow management.

II. Setting Up Notion Integration with Gmail and Google Sheets

Discuss the prerequisites for integrating Notion with Gmail and Google Sheets.
Explain the basics of Google Apps Script and how it facilitates integration between Notion, Gmail, and Google Sheets.

III. Step-by-Step Guide: Integrating Notion with Gmail

Provide detailed instructions on how to connect Notion with Gmail using Google Apps Script.
Walk through the process of setting up triggers and automation for emails in Notion.

IV. Step-by-Step Guide: Integrating Notion with Google Sheets

Provide a comprehensive guide on integrating Notion with Google Sheets using Google Apps Script.
Explain how to transfer data seamlessly between Notion and Google Sheets for efficient data management.

V. Automating Workflows with Notion, Gmail, and Google Sheets

Discuss real-life scenarios where automated workflows enhance productivity.
Provide examples of how to create custom automation using Google Apps Script to synchronize data between Notion, Gmail, and Google Sheets.

VI. Benefits of Notion Integration

Highlight the benefits of integrating Notion with Gmail and Google Sheets, including time-saving, improved collaboration, and data accuracy.
Discuss the impact of automation on reducing manual tasks and human errors.

VII. Common Challenges and Solutions

Address common challenges faced during integration and provide solutions.
Include troubleshooting tips for resolving potential issues.