How to Send an Email with Gmail After Updating Information in Google Sheets

This Flowbot procedure consists of two steps in total!

Setting Triggers in Google Sheets

First, prepare a Google Sheet to be integrated with Gmail and pre-enter the items.

This time, I created a Sales List as shown in the image.
Once the Google Sheet is created, proceed to the next step.
　　　　　↓
Click on "My Projects" on the left side of the screen and select "Send an email with Gmail when a row is updated in Google Sheets (Copy)"!
Click on Edit at the top right.
　　　　　↓
Click on the Google Sheets icon "When a row is updated".
Since the necessary items are pre-entered using the template, just make sure the account information is correct.
Click Next.
　　　　　↓

First, enter the ID of the spreadsheet.
Click inside the box to display a list as shown in the image, and select the Google Sheet you want to integrate with Gmail.
The Sheet ID below is the tab name, so click inside the box and specify the tab.

Other required items depend on the prepared Google Sheet, so enter them according to the contents of the Google Sheet.
This time, I chose "Date" for the column to detect updates.
By updating the date, emails will be sent via Gmail!

For columns with unique values, choose something that doesn't overlap with others, like phone numbers.

　　　　↓

Once you've entered everything, click the Test button at the bottom of the screen. If "Test Successful" is displayed in blue, you're good to go!

Don't forget to click the Save button. Next, we'll move on to Gmail settings!

Gmail Settings

Click on the Gmail icon "Send Email".
Again, since the necessary items are pre-entered using the template, just make sure the account information is correct.

Scroll down the screen as it is

　　　　　↓

Set the contents of the email. First, decide the recipient.
You can also set CC and the sender's name, so enter them if necessary.
　　　　　↓

The next setting is the last one! Decide the content to be notified by Gmail.

Click inside the box, and when you click on the Google Sheets icon "When a row is updated", the contents of the Google Sheet you test-sent earlier will be displayed.
Click on the content you want to notify and add it!

I tried it like the image this time!
Adding colons ":" and such can make it easier to read. Please try to imitate it!

Press Test, and if "Test Successful" is displayed in blue, save it. If an email has arrived from Gmail to the specified email, it's OK!

This concludes the integration of Google Sheets and Gmail. Well done!
Yoom has many other Flowbot templates available, so please take a look.

Other Automation Examples Using Google Sheets and Gmail

In addition to the integrations introduced today, various automations can be achieved by utilizing the APIs of Google Sheets and Gmail.

If you find something interesting, please give it a try!

Automation Examples Integrating Google Sheets and Gmail

It is possible to set up an integration that sends a notification to Gmail when information is added to Google Sheets.
Additionally, you can automate the creation of quotes based on information in Google Sheets and send them via Gmail, or notify Gmail with information from Google Sheets at a specific schedule.

Automation Example Using Google Sheets

Add Registered Database Content to Google Sheets

Automatically add content registered in systems like OneDrive or Salesforce to Google Sheets.

When a new employee is registered in the employee management app, also add them to Google Sheets

Once employee information is registered in Google Workspace or BambooHR , it will be automatically added to Google Sheets.

Use OCR to Read Documents Stored in Cloud Storage and Add to Google Sheets

When files are uploaded to Google Drive, Dropbox, or similar services, use OCR to read the content and automatically add it to Google Sheets.

Examples of Automation Using Gmail

Forwarding Files Received in Gmail to Chat Tools

Automatically forward files received in Gmail to platforms like Slack or Discord.

Send a Template Email via Gmail from the Lead Detail Page

Send a template email with one click from customer management pages like Salesforce or HubSpot.

Save Documents Received in Gmail to Cloud Storage

Automatically save documents received in Gmail to services like DropBox or OneDrive.

Benefits of Integrating Google Sheets with Gmail

1. Automatically Send Updates via Gmail When Google Sheets Rows Are Updated!

By integrating Google Sheets with Gmail, you can automatically send updated data using Gmail!
By enabling email notifications, you can quickly detect when data in Google Sheets has been updated.
This can help reduce the time lag before you check the updated data.

2. Easily Check Updates on the Go!

For example, by integrating Google Sheets that manage client data with Gmail, you can receive emails every time the transaction status with a client is updated.
If you set the emails to be viewable on your smartphone, you can quickly detect updates even when you're out and about, allowing you to respond according to the latest transaction status.
For instance, if you have email addresses or phone numbers listed in Google Sheets, you can directly create an email or make a call!
Additionally, it's recommended for daily sales management and task progress tracking.

Conclusion

Google Sheets is very convenient, but when working with multiple Google Sheets, have you ever found it difficult to remember which data is in which Google Sheet?
With this integration, you can save the effort of searching for Google Sheets and automatically send necessary information via email, simplifying your workflow and improving work efficiency.

Please try using Yoom to experiment with app integration without any coding!