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

STEP1 Setting Up Google Sheets

1. Click on "When a row is added" in the app trigger.

‍

‍

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

Click Next.

3. On the API connection settings for the app trigger 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 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. It may not work correctly if values are duplicated.

‍

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

STEP2 Setting Up Gmail

1. Click on "Send Email."

‍

2. On the email settings page, change to any title and set the email content. ※Be sure to fill in the required fields.

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

‍

Click Next.

3. On the email sending test page, you can check the configured email content.

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 active!

‍

Other Automation Examples Using Google Sheets and Gmail

Yoom offers many other examples of automation using Google Sheets and Gmail, so here are a few to introduce.
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 Sheets and Gmail

These are flow bots that can link received email content to Google Sheets or issue invoices based on customer information in Google Sheets and send them via Gmail.
Additionally, when a hotel reservation form is submitted, it can be added to Google Sheets 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 with 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 flowbot 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

By automatically adding records to Google Sheets based on the registered information, you can eliminate the hassle of manually entering data and improve work efficiency.

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.

Example of Automation 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 an attachment in Gmail, you can automate the process of uploading the file to Google Drive and sending a notification to a chat tool.

Benefits of Integrating Google Sheets and Gmail

Benefit 1: Streamlined 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, potentially reducing work time and improving management efficiency.

Benefit 2: Smoother 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, potentially preventing information gaps and misunderstandings.

Conclusion

This time, we introduced the benefits of integrating Google Sheets and Gmail, as well as how to integrate them.
Using this integration, you can automatically notify 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 translations!

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