How to Send an Email with Gmail When a Row is Added in Google Sheets

[What is Yoom]

How to Create a Workflow Integrating Google Sheets and Gmail

Now, let's introduce the steps to integrate Google Sheets and Gmail without code using Yoom.
The flowbot we will create is "Send an email with Gmail when a row is added in Google Sheets."

Preparation

Preparing in advance will make the process smoother.

Free Registration and Login to Yoom

Yoom is a tool that allows you to implement app integration without code.
Please issue an account from the Yoom Free Registration Page and start with the free plan. You can register in 30 seconds!

Please log in to the registered account.

App Integration

1. Integrate the Google Sheets and Gmail apps. Select the app from "New Connection" in My Apps.

‍

‍

‍

2. Log in with the account you will use.

・For Google Sheets and Gmail, select the desired account on the screen below and log in.

‍

‍

3. Once integrated, an icon will appear in My Apps.

Copy the Template

1. Click "Try it" from the template link below.

2. Select the desired workspace from the workspace list.

3. You have successfully copied the template you will use!

STEP1 Setting Up Google Spreadsheet

1. Click on the app trigger "Once the row is added".

‍

‍

2. On the page to select the linked account and action, change to any title you like and select "Once the row is added" as the trigger action.

Click "to the next".

‍

‍

‍

3. On the app trigger API connection settings page, configure the following items:
※ Spreadsheet ID and Sheet ID can be selected from the options.
※ Please manually enter the column name for the table range and the column with unique values.

・Trigger activation interval: Select any time from 5 minutes, 10 minutes, 15 minutes, 30 minutes, 60 minutes ※ The selectable time varies depending on the plan.
・Spreadsheet ID
・Sheet ID
・Table range (start)
・Table range (end)
・Column with unique values ※ Be sure to enter a unique column. If values are duplicated, it may not work correctly.

‍

‍

Click Test.
Once you confirm "Test successful", click Save.

STEP2 Setting Up Gmail

1. Click "Send us an email".

‍

‍

2. On the email settings page, change to any title you like and set the email content. ※ Required fields must be entered.

・To: Enter the email address of the recipient
・Subject: Enter the email title
・Body ※ Use manual input and output to enter the content you want to notify.

‍

‍

Click "to the next".

3. On the email sending test page, you can confirm the email content you set.

‍

‍

If there are no issues, click Test.
Confirm "Test successful" and click Save.

‍

‍

The flowbot setup is complete.
Finally, turn on the trigger to ensure the flow is operational!

Other Automation Examples Using Google Spreadsheet and Gmail

Yoom has many other examples of automation using Google Spreadsheet and Gmail, so here are a few introductions.
All of them can be used with simple settings, so if you find something interesting, please give it a try!

Other Automation Examples with Google Spreadsheet and Gmail

This flowbot can link received email content to Google Spreadsheet or issue invoices based on customer information on Google Spreadsheet and send them via Gmail.
Furthermore, when a hotel reservation form is submitted, it can be added to Google Spreadsheet and a preliminary reply can be sent via Gmail.

You can retrieve customer information from Google Sheets at a specified date and time, send template emails via Gmail, and extract and add Gmail content to Google Sheets.

Automation Example Using Google Sheets

Delete Registration Information When a Row is Updated in Google Sheets

This is a flow bot that allows you to delete registered information when a row is updated in Google Sheets.
It should help reduce the risk of forgetting to delete information or retaining outdated data.

Add a record to Google Sheets when a schedule is registered

Automatically adding records to Google Sheets from registered content eliminates the need for manual entry, leading to increased efficiency in operations.

Retrieve information and add it to Google Sheets at the specified schedule

This is a flow bot that automatically retrieves information and adds it to Google Sheets at the specified schedule.
By automating the process of adding to Google Sheets, it should help prevent manual transcription errors and omissions.

Automation Example Using Gmail

Send a Thank You Email via Gmail When a Payment is Made

This is a flow bot that automatically sends a thank you email from Gmail to the purchaser when a payment is made.

Upload Gmail Attachments to Google Drive and Notify

When you receive attachments in Gmail, you can automate the process of uploading files to Google Drive and sending notifications to a chat tool.

Benefits of Integrating Google Sheets and Gmail

Benefit 1: Streamlining Project Management

In project management, it's crucial to quickly notify the entire team about progress and new tasks.
By integrating Google Sheets and Gmail, you can automatically send email notifications when information is entered into Google Sheets.
This eliminates the need for manual notifications, reducing work time and improving management efficiency.

Benefit 2: Facilitating Smooth Communication

By automatically sending email notifications to the entire team whenever tasks are added or changed, you can ensure smooth information sharing.
This helps team members stay updated with the latest information, preventing information gaps and misunderstandings.

Conclusion

In this article, we introduced the benefits of integrating Google Sheets and Gmail, as well as how to do it.
Using this integration, you can automatically notify about information within the sheet, potentially making task management more efficient.

Yoom offers a wealth of other convenient features.
For example, you can easily create various workflows such as automatic notifications to chat tools and text translation!

Start with a free plan. You can easily begin from this page.
Utilize the abundant templates to experience various features!