Are you struggling to manually create emails for each contact in your sales list?
Imagine if you could generate and send responses to your emails automatically. It's possible, with ChatGPT and Google Sheets integration :) ChatGPT can generate personalized emails based on your contact list stored in Google Sheets. This integration ensures your communication is both efficient and accurate.
In this article, we'll show you how this integration can transform your email handling process and boost your work efficiency.
Meet Yoom: No-Code Automation
Yoom is a next-generation no-code automation that lets you connect and automate tasks between your favorite apps. Connecting different apps can be challenging for non-engineers, but Yoom makes automation accessible to everyone.
🌐 Connect with apps like ChatGPT, Google Sheets, and more.
📖 Use automation templates - no technical setup required
📈 Boost productivity and reduce human errors
You don't need to go through a complex setup and IT jargon, you can build your automation workflows with just a few clicks :) It's designed for those who want to streamline their daily work and save hours of time and stress from repetitive work.
■Overview The flow 'Automatically generate and send guidance emails using ChatGPT from a Google Spreadsheet list' is a business workflow that streamlines the creation of guidance emails for customers or team members.
■Recommended for ・Those who want to send emails based on data managed in Google Spreadsheets ・Those who want to automatically generate email content using ChatGPT ・Sales or public relations personnel who spend time creating emails manually ・Owners of small and medium-sized enterprises who want to achieve efficient communication ・IT personnel who want to automate business workflows using Yoom
■Notes ・Please integrate Google Spreadsheets, ChatGPT, and Yoom. ・To execute ChatGPT (OpenAI) actions, a contract for OpenAI's API paid plan (a state where payment can be made when the API is used) is required. https://openai.com/ja-JP/api/pricing/ The use of ChatGPT's API is provided by OpenAI for a fee, and it is a pay-as-you-go system based on tokens during API communication. Therefore, please be aware that an error will occur if payment cannot be made when using the API. ・You can select the trigger interval from 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes. ・Please note that the shortest trigger interval varies depending on the plan.
🙌 What You Can Do by Integrating Google Sheets with ChatGPT
By integrating Google Sheets with ChatGPT, you can unlock a variety of automation options, seamlessly connecting Google Sheets data to ChatGPT.
Here are some practical, ready-to-use templates that you can try out. Just click on the "TryIt" button to get started quickly!
Automatically Generate and Send Guide Emails
If you manage a sales list or customer data in Google Sheets, you can easily automate the process of generating and sending personalized guide emails. ChatGPT can take care of creating emails, directly pulling data from your Google Sheets.
Automatically generate and send informational emails using ChatGPT from a list in Google Sheets.
■Overview The flow 'Automatically generate and send guidance emails using ChatGPT from a Google Spreadsheet list' is a business workflow that streamlines the creation of guidance emails for customers or team members.
■Recommended for ・Those who want to send emails based on data managed in Google Spreadsheets ・Those who want to automatically generate email content using ChatGPT ・Sales or public relations personnel who spend time creating emails manually ・Owners of small and medium-sized enterprises who want to achieve efficient communication ・IT personnel who want to automate business workflows using Yoom
■Notes ・Please integrate Google Spreadsheets, ChatGPT, and Yoom. ・To execute ChatGPT (OpenAI) actions, a contract for OpenAI's API paid plan (a state where payment can be made when the API is used) is required. https://openai.com/ja-JP/api/pricing/ The use of ChatGPT's API is provided by OpenAI for a fee, and it is a pay-as-you-go system based on tokens during API communication. Therefore, please be aware that an error will occur if payment cannot be made when using the API. ・You can select the trigger interval from 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes. ・Please note that the shortest trigger interval varies depending on the plan.
Perfect for those who want to organize data like survey responses or meeting minutes. Whenever a new row is added in Google Sheets, ChatGPT can summarize the content and automatically add the key points to your Google Sheets. This can help you stay on top of key information :)
When a row is added in Google Sheets, summarize it with ChatGPT and add it to Google Sheets.
🚀 Let's Create a Flowbot to Integrate Google Sheets with ChatGPT!
Let's walk through how to set up a flow that automatically composes an email using ChatGPT based on the data based on a Google Sheet.
⏱️ Setup time: 10 minutes
🔧 What You’ll Need
A free Yoom account
Access to Google Sheets and ChatGPT
If you don’t have a Yoom account yet, register now from thisregistration form!
⚠️ Note: To run ChatGPT (OpenAI) actions, you’ll need a paid OpenAI API plan. Make sure you have your payment set up ready for smoother transactions when the API usage fees are incurred. For more details, visitOpenAI API Pricing.
Automatically generate and send informational emails using ChatGPT from a list in Google Sheets.
■Overview The flow 'Automatically generate and send guidance emails using ChatGPT from a Google Spreadsheet list' is a business workflow that streamlines the creation of guidance emails for customers or team members.
■Recommended for ・Those who want to send emails based on data managed in Google Spreadsheets ・Those who want to automatically generate email content using ChatGPT ・Sales or public relations personnel who spend time creating emails manually ・Owners of small and medium-sized enterprises who want to achieve efficient communication ・IT personnel who want to automate business workflows using Yoom
■Notes ・Please integrate Google Spreadsheets, ChatGPT, and Yoom. ・To execute ChatGPT (OpenAI) actions, a contract for OpenAI's API paid plan (a state where payment can be made when the API is used) is required. https://openai.com/ja-JP/api/pricing/ The use of ChatGPT's API is provided by OpenAI for a fee, and it is a pay-as-you-go system based on tokens during API communication. Therefore, please be aware that an error will occur if payment cannot be made when using the API. ・You can select the trigger interval from 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes. ・Please note that the shortest trigger interval varies depending on the plan.
Step 1: Connect Google Sheets and ChatGPT with Yoom
After logging into Yoom, go to "My Apps" from the left side menu, and click the "+ Add" button.
Search using the app name and select it to register the app in Yoom.
Connect Google Sheets
Search for Google Sheets from the app list and select it. Click on "Sign in with Google".
Select the account you want to connect to, then click "Continue".
Connect ChatGPT
Search for ChatGPT in the app list and select it.
Enter the account name. Use a name that's easy to recognize, such as your company name or the person responsible for the account.
To get your access token, you need to create and obtain the API Secret key. First, log in to theOpenAIAPI platform. Then click the gear icon at the top right → API Keys in the left menu → Create new secret key at the top right in order.
Set each item and create the Secret key.
Copy the displayed Secret key and save it in a secure location. ‼️ Once you leave this screen, you will not be able to view the key.
Paste it into the AccessToken field, and click "Add".
Step 2: Copy the Template
Click the "Try It" button to copy the pre-built template into your project.
Automatically generate and send informational emails using ChatGPT from a list in Google Sheets.
■Overview The flow 'Automatically generate and send guidance emails using ChatGPT from a Google Spreadsheet list' is a business workflow that streamlines the creation of guidance emails for customers or team members.
■Recommended for ・Those who want to send emails based on data managed in Google Spreadsheets ・Those who want to automatically generate email content using ChatGPT ・Sales or public relations personnel who spend time creating emails manually ・Owners of small and medium-sized enterprises who want to achieve efficient communication ・IT personnel who want to automate business workflows using Yoom
■Notes ・Please integrate Google Spreadsheets, ChatGPT, and Yoom. ・To execute ChatGPT (OpenAI) actions, a contract for OpenAI's API paid plan (a state where payment can be made when the API is used) is required. https://openai.com/ja-JP/api/pricing/ The use of ChatGPT's API is provided by OpenAI for a fee, and it is a pay-as-you-go system based on tokens during API communication. Therefore, please be aware that an error will occur if payment cannot be made when using the API. ・You can select the trigger interval from 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes. ・Please note that the shortest trigger interval varies depending on the plan.
Click "OK" and give the Flowbot a name to recognize.
This template will be copied to your “My Project”.
Step 3: Set Up Google Sheets Trigger
Click on the trigger action labeled "When a row is added".
Give your trigger a title (optional). Check if the setup is correct, and click "Next".
Set your trigger interval (frequency of sync) to how frequently Yoom checks Google Sheets for updates. It can be set to 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes. We recommend setting the trigger to the shortest activation interval available for your plan.
⚠️ Note: The trigger interval varies depending on your Yoomplan. Be sure to check your current plan’s limit.
Select the Spreadsheet ID from the displayed options.
For this example, we will set the table range as below. For the Column with Unique Values, select a column that contains no duplicate values, such as email addresses or IDs. This column will act as the "unique key" for your data.
📚 Reference: For more details on how to set the table range, you can refer to this guide.
👇 This is the Google Sheet file we are using for this example.
Click "Test" and if successful, your retrieved value will get updated. Make sure you save :)
Step 4: Set Up Text Generation with ChatGPT
Next, click on the action labeled "Generate Text".
Give your action a title (optional). Check if your account info is correct, then click "Next".
Click on the input field to display data retrieved from Google Sheets as names or phone numbers. You can use these dynamic values to create your instruction. Using the retrieved values will create personalized messages that change each time the flow is triggered. Avoid entering fixed text in the message content, as it will generate the same way every time.
📚 Reference: For more details on retrieved values and how to set it up, see the guide here.
Settings like temperature and maximum token count are optional, so feel free to adjust them as needed. Refer to the annotations for guidance when modifying these settings.
Step 5: Send Email
This is the final step :) Click on the action labeled "SendEmail".
Click the input field to quote information retrieved from Google Sheets as shown in the screen below.
Then, insert the response generated by ChatGPT into the body as shown below. Once set, click "Next" to preview the email.
Step 6: Activate the Flowbot
Toggle the "Trigger On" button to activate your flow!
Check if the Flowbot you set up is working properly.
That’s it!
Your Flowbot is complete!
🔁 Want to Connect ChatGPT Data into Google Sheets Instead?
You can also go the other way around, send ChatGPT data to Google Sheets.
Record Email Message in Google Sheets
When an email is received, ChatGPT will process the content and automatically add it to Google Sheets. Perfect for quickly organizing inquiry emails without missing any key details :)
When an email arrives, have a conversation with ChatGPT and link it to Google Sheets to record the content.
Categorize Form Responses and Add to Google Sheets
When a form is submitted, use ChatGPT to categorize the response (e.g., Product questions, price inquiries) and save it in Google Sheets. Perfect for efficiently sorting and tracking various types of inquiries.
When there is a form response, use ChatGPT to categorize the response type and add it to a Google Spreadsheet.
■Overview ・When a survey response is made to Yoom's form, use ChatGPT to categorize the response type and store the information in Google Sheets. ・You can centralize the categorization and accumulation of data according to the form response content.
■Preparation ・Pre-registration (integration) with the app to be used is required. The following is a reference guide for integration. ※There may not be a detailed guide for apps that can be easily integrated. https://intercom.help/yoom/en/collections/3041779 ・Prepare a spreadsheet to accumulate application information in advance.
■Spreadsheet used for accumulation (view-only access. Please copy if you wish to use it.) ・https://docs.google.com/spreadsheets/d/1bluRKYuqY7oMyXdaQN3HezyanrlLJaYzryrUg-lS4pk/edit#gid=0
■Creation Method ①Select the form trigger, set the following, and save. ・Each question item: Set necessary items such as name, contact information, and question content for the form. ・Acquired values: You can enter demo values on the next page. Please enter demo values as they will be used in the subsequent test. ※For details on form settings, please refer here. https://intercom.help/yoom/en/articles/8009267
②Press the + mark under the trigger, select ChatGPT from the operation to integrate with the app, set the following, test, and save. ・Action: Converse ・Message content: Embed the inquiry content obtained in ① and instruct the following judgment. ・Role: Select the ChatGPT response role. ※The default is user setting ・Temperature: Specify a value less than 2. A high value like 0.8 increases randomness, while a low value like 0.2 makes it more focused and deterministic. ・Maximum token count: The maximum number of tokens allowed for the generated response. By default, it is 4096 tokens. ・Model: Select the ChatGPT AI model. ※For embedding output, please refer here. https://intercom.help/yoom/en/articles/8223528 ーーーーーーーーーーーーーーー {{Inquiry Content}}
Check this text and if it is related to sales, judge it as "Sales", if it is related to questions, judge it as "Question" If it is spam-like content, judge it as "Possible Spam". ーーーーーーーーーーーーーーー
③Press the + mark, select Google Sheets from the operation to manipulate the database, set the following, test, and save. ・Execution action: Add record ・Spreadsheet ID: Click the field and select the prepared spreadsheet from the candidates. ・Spreadsheet tab name: Click the field and select the target sheet from the candidates. ・Table range: Enter the target range including column names. In this example, it is set as A1:E. ・Values of the record to be added: Embed the output obtained in ① and the judgment result obtained in ② corresponding to the displayed column names. ※For the definition of the Google Sheets table range, please refer here. https://intercom.help/yoom/en/articles/8703465
■Notes ・The use of ChatGPT/OpenAI's API is paid. Depending on your OpenAI plan, you may not be able to use it, so please check your plan in advance. https://intercom.help/yoom/en/articles/8687581
■ Overview Are you manually copy & pasting the survey and inquiry responses collected via Google Forms into Google Sheets one by one? Such routine transcription not only takes time but can also cause data entry errors. By using this workflow, submitting a form response triggers automatic record addition to the specified Google Sheet, eliminating manual effort and errors and enabling efficient data management.
■ Recommended for ・Those who manually transfer responses collected via Google Forms to Google Sheets ・Those who want to share and manage inquiry and application information from forms with their team in real time ・Those who want to eliminate data entry errors and build a more accurate information management system
■ Notes ・Connect Yoom with both Google Forms and Google Sheets. ・For how to retrieve response contents when using Google Forms as a trigger, please refer to the following: https://intercom.help/yoom/en/articles/6807133 ・The trigger can be set to run at intervals of 5, 10, 15, 30, or 60 minutes. ・Please note that the minimum run interval varies by plan.
■Overview This workflow allows you to automatically create a corresponding record in Notion just by adding a new row in Google Sheets. This automation eliminates the need for manual data entry and double management, maintaining consistency of information. With Yoom, you can easily connect apps without programming.
■Recommended for ・Those who use Google Sheets and Notion regularly and spend time on manual data entry ・Project managers who want to streamline team information sharing and update data without omissions ・Business owners who want to prevent errors from double data management and improve work accuracy ・IT personnel in companies interested in business automation through IT tool integration and considering implementation ・Freelancers or sole proprietors who need to regularly reflect data in Notion and want to save effort ・All business professionals looking to review and streamline their current workflow
■Notes ・You need to connect Google Sheets and Notion to Yoom. ・You can select the trigger interval from 5, 10, 15, 30, or 60 minutes. ・Please note that the shortest trigger interval varies depending on the plan.
■Overview The 'Extract and manage necessary information from received Gmail content using ChatGPT' flow is a business workflow that achieves email processing efficiency and automation of data management. Extracting necessary information manually from the large number of Gmail emails received daily takes time and effort. By utilizing this workflow, the content of emails received in Gmail can be automatically analyzed and extracted by ChatGPT, managing the necessary data. As a result, it can reduce the burden of manual work and improve the accuracy and efficiency of data management.
■Who should use this template - Business persons who handle a large number of emails daily in Gmail - Those who want to organize email content information and streamline management - IT personnel who want to automate data extraction using ChatGPT and improve business efficiency, aiming to reduce routine tasks for team leaders - Executives and managers who want to enhance the accuracy of data management
■Precautions - Please connect both Gmail and ChatGPT to Yoom. - You can select the trigger activation interval from 5 minutes, 10 minutes, 15 minutes, 30 minutes, to 60 minutes. - Please note that the shortest activation interval differs depending on the plan.
■Overview The "Organize and summarize meeting minutes created in Notion using ChatGPT" flow is a business workflow to streamline the creation and management of meeting minutes. It reduces the burden of creating meeting minutes and enables efficient information sharing.
■Who we recommend this template for: ・Those who manage meeting minutes in Notion but find it time-consuming to organize and summarize them. ・Those who find it challenging to manually organize detailed meeting minutes each time. ・Team leaders and project managers who want to share meeting content in an easy-to-understand manner. ・Those who want to smoothly share minutes and make decisions. ・Executives and managers who want to efficiently manage and update the content of minutes. ・Those who want to streamline regular meeting minute creation tasks. ・Those who want to automate tasks using AI and spend time on other important tasks. ・Those who want to focus on creative tasks.
■Precautions ・Please link Notion and ChatGPT with Yoom. ・By using the trigger with the Chrome extension, you can start the trigger directly from Notion. ・Please refer to the following for the setting method of the trigger using the Chrome extension. https://intercom.help/yoom/ja/articles/8831921
■Overview This workflow automatically summarizes incoming emails with ChatGPT and records the organized information in Notion, allowing for smooth organization and sharing of information. With this automation, you can accurately grasp the important contents of emails, making it easy to share information with the entire team. Using Yoom, you can easily connect applications without the need for programming.
■Recommended for ・Business people who receive a large number of emails daily and want to efficiently manage their contents ・Those who want to organize information using ChatGPT and Notion ・Project leaders who wish to automatically summarize email contents and share with the team ・IT personnel considering automation of business workflows
■Caution ・Please link Yoom with both ChatGPT and Notion. ・To execute actions with ChatGPT (OpenAI), a subscription to the OpenAI API paid plan is required. (Payments should be possible when the API is used) https://openai.com/ja-JP/api/pricing/ ・The use of ChatGPT API is provided for a fee by OpenAI, and it is a pay-as-you-go system based on tokens during API communication. Therefore, please be aware that errors may occur if payments cannot be made at the time of API usage.
■Overview When a message is posted on Discord, this flow generates a response with ChatGPT. By using Yoom, you can easily integrate apps without programming.
■Recommended for Discord server administrators ・For those who want to quickly respond to user questions
Companies or teams looking to streamline customer support ・For those who want to automatically provide answers to FAQs and common inquiries, reducing the support burden
Those who want to improve user experience ・For those who want to increase customer satisfaction through quick replies
Small and startup businesses looking to improve operational efficiency ・For those considering automation tools to maximize impact with limited resources
■Notes ・Please integrate Discord, ChatGPT, and Yoom. ・An OpenAI API paid plan contract is required to execute ChatGPT (OpenAI) actions. (The payment needs to be available when the API is used) https://openai.com/pricing/ ・ChatGPT API usage is provided by OpenAI on a paid basis, with metered billing through tokens during API communication. Therefore, please be aware that an error will occur if payment is not available at the time of API usage.
By integrating Google Sheets with ChatGPT, it seems we can significantly reduce the effort required to create emails! Based on the list registered in Google Sheets, ChatGPT can automatically create and send out informational emails. This eliminates the need to create emails one by one, improving both the speed and accuracy of operations. Manual errors can also be prevented, allowing for confident operation. The setup is easy with no coding required! By utilizing templates, anyone can quickly build the integration flow.
Why not take this opportunity to combine Google Sheets and ChatGPT to make your operations run more smoothly?
With Yoom, you can easily build the kind of collaboration described here without programming knowledge.
In today's era where the number of tools is constantly increasing, it can often be confusing to decide which ones to use. We aim to provide clear and useful information to make your work a little easier!
.avif)
.avif)
